2017-05-10 (first published: 2017-05-02)
392 reads
Scripts
2017-05-09 (first published: 2017-05-03)
2,893 reads
Fix Orphan Users for All databases - Fixed Collation Problem
Most comman scenario which we face on everyday basis is to fix the orphan database users at the database level. You need to go to each database and fix the orphan users at the each databases.
2017-05-03 (first published: 2017-04-20)
693 reads
Quick and dirty script to ascertain datafile headroom
This is quick script to ascertain datafile headroom based on current size of the data in a file against the max size (which needs to be set for this to work!)
2017-05-02 (first published: 2017-04-19)
399 reads
2017-05-01 (first published: 2017-04-19)
1,230 reads
Find and Replace a value across all tables in database
End user has entered ‘goodmorning’ and ‘good morning’ interchangeably and it was causing logic failure at application level. So task was to replace ‘goodmorning’ with ‘good morning’ in database wherever it is there.
2017-04-28 (first published: 2017-04-10)
1,115 reads
Table Valued Function to factorize numbers up to 100 trillion
This table valued function will quickly find the prime factors of any number up to 10 trillion
2017-04-26 (first published: 2017-04-06)
421 reads
PowerShell 3rd Party tool Memory Alert
Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.
2017-04-25 (first published: 2017-04-13)
560 reads
Change Column datatype
This script is for converting Char to nChar and varchar to nVarchar with the same length.
This process has reduced the manual work by 80% (approximately) in our case.
2017-04-24 (first published: 2017-04-10)
593 reads
Getting resource name from blocked process report
The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.
2017-04-21 (first published: 2017-02-20)
2,074 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers