2018-10-29 (first published: 2018-10-19)
1,407 reads
Scripts
Mechanism To Dynamically Build Pivot Table
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
995 reads
2018-10-24 (first published: 2018-10-15)
902 reads
2018-10-12 (first published: 2018-10-04)
1,163 reads
How to Identify backup tables within production databases
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
565 reads
number of rows and columns of an instance
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
501 reads
Data Collections restart and clear cache files
Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.
2018-10-02 (first published: 2018-09-25)
1,427 reads
Conditionally Order By Different Column
Order records based on a different column depending on which absolute value is greater.
2018-10-01 (first published: 2018-09-26)
637 reads
2018-09-26
457 reads
dba_CopyLogins
A copy of the late Robert Davis' dba_copylogins stored procedure with a bug fix. The SP copies logins, roles, and permissions between servers.
2018-09-24 (first published: 2018-08-28)
1,728 reads
Blogs
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Forums
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers