An updated script to find the longest running query in SQL Server 2005 and 2008, with the divide by zero error fixed and time now shown in milliseconds.
SQLAuthority News – Milestone of 6 Million Visits – 60 Lak Visits – Search and Job
SQLAuthority.com crossed 6 Million Visits in 2 years and 3 months. Thank you, readers! I also announce a small surprise for readers who take part here.
SQLAuthority News – SQLAuthority News – Ahmedabad User Group Meeting January 17 2009 – Review
A review of our first Ahmedabad User Group Meeting of 2009, with three back to back performance tuning talks on index usage, query optimization and MERGE.
SQL SERVER – Rules for Optimizining Any Query – Best Practices for Query Optimization
My quick rules for query optimization: a primary key, a clustered index, the right non-clustered indexes, fewer views and triggers, and other simple checks.
Securing Linked Servers
Securing linked servers requires explicit login mappings, limited RPC settings, remote privilege checks, and dependency ownership.
SQL SERVER – Difference Between Index Scan and Index Seek
What is the difference between Index Scan and Index Seek? I explain how SQL Server uses search predicates to decide which index operation a query gets.
What TDS Is and Why It Matters to You
What TDS is becomes practical when a SQL Server connection fails: it carries login and query traffic, packet settings, and encryption negotiation.