Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,835 reads
Delete Duplicates using CTE
Delete duplicates with a CTE (common table expression).This script uses the same setup as the anonymous post using a cursor (http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1872).
2007-08-23
1,090 reads
Blogs
AWS RDS SQL Server Version List
AWS RDS SQL Server 2017 Builds RDS SQL Server version SQL Server...
What is a strong password anyway?
Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have...
Sorting in Stored Procedures – Food for Thought
We know that sorting can be one of the most expensive things in an...
Forums
Data Lake - Data Warehouse Strategies
Hi, Please forgive me if this is wordy. I am working on a future...
Looking for a tool for SQL Server that will show end-to-end column flow
Looking for a Windows app that will show the life of a column in...
Replication causing log bloating
Hello, We've had a snapshot replication process in place for several years. It seems...
Ask SSC