Reports on all indexes on user tables within a databaseReports Tables with Missing Clustered indexReports Tables with Missing Primary KeysReports Possible Redundant Index keysReports Possible Reverse Index key
2006-12-21 (first published: 2004-09-16)
494 reads
Here's an alternative to Clinton Herring's ufn_vbintohexstr which should be much faster with large varbinary values. First, in his original version, the inner-loop CASE statements can be replaced with this: select @value = @value + CHAR(@vbin/16+48+(@vbin+96)/256*7) +CHAR(@vbin&15+48+((@vbin&15)+6)/16*7) How does it work? By adding 6 to a hex-digit in (@vbin&15), you have a value from 16 […]
2006-12-20 (first published: 2005-05-07)
145 reads
This script sets the recovery model for all databases to simple. It also truncates the log files before shrinking the databases.
2006-12-19 (first published: 2005-06-03)
336 reads
This is just an optimized version of Daniel Payne's two scripts, base64_encode and base64_decode, with changes to end-of-block handling and a bug fix or two. If the encoded string ends in =, the last character is truncated. If ending in ==, two characters are chopped off. That seems better than replacing NUL characters with spaces, […]
2006-12-18 (first published: 2005-06-04)
7,771 reads
Challenged by Hans Lindgren's stored procedures of the same name, I created this. Note that it produces strange results on non-hexadecimal strings, overflows at 0x80000000, and could have issues with byte-ordering on some architectures.How does it work? Well, the distance between one after '9' (':') and 'A' is 7 in ASCII. Also, if I subtract […]
2006-12-15 (first published: 2005-05-04)
238 reads
SQLStackEngine - simulate a character stack using a string. This script was developed specifically to support the operator stack in SQLCalcEngine(also on this site). However, the implementation is complete enough to stand on its own.There are several functions in the package that correspond to the common stack functions of Push, Pop, Peek, and so on.In […]
2006-12-12 (first published: 2004-06-22)
168 reads
Sometimes you want to modify an object (like a stored procedure, Function, trigger and view) and you can not remember the name of that object, but you remember some words of the comments that you placed in the body of that object. If this is your case, you can use the following procedures depending on […]
2006-11-30 (first published: 2006-01-10)
201 reads
2006-11-30
1,153 reads
Drops the specified column from the specified table as well as any constraints that depend on the column. By default the script will just find the corresponding column and constraints.Comes in handy for patching databases.
2006-11-29 (first published: 2006-05-17)
985 reads
2006-11-28 (first published: 2006-10-11)
566 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Hyperscale Replicas II
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Comments posted to this topic are about the item Your Favorite Quotes
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers