2009-06-11 (first published: 2009-05-25)
782 reads
Scripts
Automated Script to Partition Tables
This script is used to print the alter statement and also partition the table with the respective partition Scheme and Partition Function.
2009-06-10 (first published: 2009-05-22)
2,410 reads
Dynamic Columns with PIVOT Operator
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
2,033 reads
Create Your Own Batch Runs Composed Of Existing Jobs
Here is a stored procedure that start a job, and then waits until the jobs is finished
2009-06-02 (first published: 2009-05-14)
1,071 reads
The Ultimate Dupe Finder & Performance Test Parameter Set Researcher
Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!
2009-05-29 (first published: 2009-05-05)
949 reads
2009-05-27 (first published: 2009-04-30)
2,622 reads
2009-05-22 (first published: 2009-04-28)
3,850 reads
Function to find non-printable characters
The function is used to find non-printable ASCII characters in an input string.
2009-05-21 (first published: 2009-04-24)
3,005 reads
SQL Server Database Backup Status
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-19 (first published: 2009-04-23)
3,009 reads
2009-05-14 (first published: 2009-04-08)
2,013 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers