Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component in the system. Database servers are particularly sensitive to disk IO speeds. For example, introducing an SVC system may speed up writes, but wil...

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis...

A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti. The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored proc...

i-catching solutions...