T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...
2019-10-30
7 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
53 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
6 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
1 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
4 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
2 reads
Behold! There’s a scary monster called skip-2.0, announced by ESET: This backdoor targets MSSQL Server 11 and 12, allowing the attacker to connect stealthily to any MSSQL account by...
2019-10-30
1 reads
PASS Summit 2019 starts up next Monday with pre-conference sessions. I’ve got my schedule all set, and I’m going to be busy: I’m speaking in two full-day pre-conference sessions,...
2019-10-30
5 reads
sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle...
2019-10-29
27 reads
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
9 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers