2019-10-31
873 reads
Design and Theory
2019-07-19
932 reads
2012-10-31
2,520 reads
2011-09-07
2,318 reads
2011-06-14
2,493 reads
2011-06-13
2,367 reads
2011-06-10
2,537 reads
2011-06-02
2,637 reads
2011-05-27
2,297 reads
2011-05-13
3,269 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
SSMS Freezing when Editing SQL Agent Job Steps
I've spent several hours trying to overcome an odd technical bug on two SQL...
cardinality estimation
Just a quick question I'm putting in a new SQL 2019 server and an...
Attribute in the hierarchy display as one value
Hello Friends, I want to display the attributes in a hierarchy as one value...
Ask SSC