Rebuild index selectively
Rebuild index is expensive most time. So you don't rebuild all index blindly.
2015-11-04 (first published: 2015-10-05)
1,864 reads
Scripts
Alter all/specific columns by double dynamic SQL
The script uses dynamic SQL twice
first to get the detail about the database structure and create ddl out of it
second to execute each DDL created
2015-11-03 (first published: 2015-10-07)
1,000 reads
Paginating a SQL query result set
How to Paginate a query result set to keep from pulling the whole result set to the client side
2015-11-02 (first published: 2014-05-05)
3,742 reads
Security Queries: Database-level
A set of queries which attempt to gather as much security-related information on a single database as possible.
2015-10-30 (first published: 2013-10-24)
5,771 reads
List of Stored Procedures modified in past 7 days
Provide list of Stored Procedures that have been changed in past 7 days.
2015-10-29 (first published: 2013-04-11)
3,610 reads
2015-10-27 (first published: 2014-07-08)
4,434 reads
2015-10-23 (first published: 2014-05-13)
3,757 reads
Calculating Working Hours
Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.
2015-10-22 (first published: 2014-05-22)
3,770 reads
2015-10-21 (first published: 2013-12-26)
4,084 reads
What's changed recently?
Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...
2015-10-20 (first published: 2013-05-30)
3,961 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