[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Tips
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
SQL Server 2008
Tips
Troubleshooting
Tuning

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

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.