Deleting Duplicate Records
In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.
2015-09-11 (first published: 2012-10-31)
5,036 reads
Scripts
2015-09-10 (first published: 2014-05-08)
4,871 reads
Physical Server or a Virtual Machine?
Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM.
Note: This Script works only on 2008R2 SP1 and above.
2015-09-09 (first published: 2014-05-22)
4,809 reads
Create MERGE statements with data!
A script to create MERGE statements with data for specific tables.
2015-09-03 (first published: 2014-05-19)
5,205 reads
SQL Server Performance Base Line Script
Performance Base Line Report from SQL Server DMVs and Perfmon counters
2015-09-02 (first published: 2013-02-04)
17,230 reads
Block altering indexed views.
Altering an indexed view will drop all indexes on it without warning, even if nothing is changed.
This will prevent accidental alters.
Script is divided into 4 parts, included testing and cleanup scripts.
2015-09-01 (first published: 2015-08-13)
997 reads
Registered server documenter
Returns server and instance information via a registered server query, regardless of SQL version.
This script is more of how to get the data, and not so much about the data returned by my choice of columns.
Tested on 2008+
2015-08-28 (first published: 2015-08-07)
1,370 reads
Retrieving XML data to Table from dm_os_ring_buffers
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2015-08-27 (first published: 2015-08-03)
996 reads
Generate Login Script(2008R2 And Older)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,751 reads
Cleanup Older than 30 days of Files & Folder through SQL Job
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2015-08-24 (first published: 2015-08-04)
2,627 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers