Generate stored procedure parameter list based on table
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
2009-12-04 (first published: 2009-11-10)
2,016 reads
Scripts
t-sql first last day date of the month
Returns the First or last day date of the month for a given date.
2009-12-01 (first published: 2009-11-11)
2,858 reads
usp_ShrinkAllLogs
Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.
2009-11-27 (first published: 2009-10-30)
978 reads
Display COUNT(*) but ONLY TOP 100
Let’s say you have a result set with 5000 records but you want to display only 100 of them and in the same time to display the count of ALL records (5000).
2009-11-20 (first published: 2009-11-05)
2,464 reads
Split string into table, separator can be more than 1 char
Split string like ('123,43,5465,6788,1231,111', ',') into table, separator (,) can be more than 1 char
2009-11-19 (first published: 2009-11-05)
1,376 reads
Scripts for Full DB Compression at partition level
Data compression is a key feature with SQL 2008. This script, can compress all DB objects (partition/non-partitioned) according to Partition Range you specifiy.
2009-11-18 (first published: 2009-11-05)
1,158 reads
2009-11-17 (first published: 2009-11-06)
1,006 reads
Search in your T-SQL objects
This procedure searches for your criteria not only in code, but also in objectnames
2009-11-16 (first published: 2009-10-20)
1,090 reads
View Errors in the Default Trace
Returns records with errors from the default trace ordered by most recent first
2009-11-12 (first published: 2009-10-29)
701 reads
Wait for Mirror treshold
This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.
2009-11-10 (first published: 2009-10-23)
497 reads
Blogs
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
Forums
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
Comments posted to this topic are about the item Five SQL Server 2022 T-SQL...
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers