|
| |
Tips.
Configuring Antivirus for MSSQL servers
Known and possible issues with antivirus software. Exclusions from virus
scanning.
Database Snapshots- A summary of the
information available on Microsoft SQL Server Books Online about Database
Snapshots.
Determining Server Name using T-SQL
How to determine the Server Name using T-SQL
How to Disable SSL on Reporting Services
These are detailed steps to disable SSL (Secure Sockets Layer) on SQL Server
2005 Reporting Services.
How to install SQL Server 2005 SP3
SP3 setup requirements, pre-installation tasks, installation, post-installation
tasks.
Know What Sessions Were Assigned to Each Workload
Groups
This query let's you find out how each session was classified in Resource
Governor.
- Ports and Protocols Used by Microsoft SQL
Server 2000
- Network ports and protocols used by
Microsoft SQL Server 2000.
Ports and Protocols Used by Microsoft SQL
Server 2005
Network ports and protocols used by
Microsoft SQL Server 2005.
Ports and Protocols used by Microsoft SQL Server 2008
Network ports and protocols used by Microsoft
SQL Server 2008.
Speed Up Insert Performance
Some recommendations to speed up insert performance on Microsoft SQL Server.
- Using Transact-SQL for Full-text Indexing in
SQL Server 2005
- Useful t-sql statements when working with full-text indexing
|
![[Company Logo Image]](images/SQLCofee.jpg)
