2013-07-05 (first published: 2010-11-23)
20,638 reads
Sarvesh Singh
Indexed Views
This article will show you the importance of Indexed Views and how they can help performance.
2013-05-10 (first published: 2010-11-16)
24,214 reads
A Check and Foreign Key Constraint Improves Query Performance
Check and foreign key constraint do not degrade performance but actually improve it.
2013-04-26 (first published: 2010-10-21)
24,057 reads
2011-02-08
22,588 reads
Restore from LiteSpeed
Learn how to restore a LiteSpeed backup on a server without the software in 2 Simple Steps.
2010-10-12
5,098 reads
Blogs
sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Forums
Building Your Brand
Comments posted to this topic are about the item Building Your Brand
A Little Paranoia is Good
Comments posted to this topic are about the item A Little Paranoia is Good
Auto Rounding
Comments posted to this topic are about the item Auto Rounding
Ask SSC