An optimized function for converting a HEX string into a SMALLINT. Built for being faster then other HexToDec converters.If there is any faster function to do this conversion, I am intrested of using it instead.
2006-10-11 (first published: 2005-04-19)
127 reads
Most of the luhn scripts assume that you are working with credit-cards and then IMPROPERLY calculate their luhn check-digit by starting at the left side (assuming that the core number is always 15 digits). However, if you don't know the length of your core number, then such an approach will fail when the length is […]
2006-10-10
283 reads
In this article I will try to justify why Table variables are superior to temporary tables.
2006-10-10
1,056 reads
Pagination of the records helps in faster and better display while generating a huge report or displaying hundreds of records on the screen. Performing the pagination through SQL script is some what tricky and an average developer finds it difficult to implement. Here I am suggesting the script to resolve the pagination problem.Use this script […]
2006-10-09 (first published: 2006-05-09)
822 reads
This function returns a formated calendar table. It came in handy a few times for me, so I thought it may be a good contribution. There would be a few better ways to create this function if date-part were a valid data type. It is a pretty straight-forward function. You may edit it if you […]
2006-10-05 (first published: 2006-03-29)
429 reads
This is a replacement for SP_who and modification of sp_who2. It will always list only active, nonsystem processes, and will list the number of seconds a transaction has been running for. Some transactions do not report a last batch time, so I forced a large value to display so you can see any issue with […]
2006-10-02 (first published: 2006-04-28)
2,340 reads
This script will give you the facility to search for Particular Data in the Database, To know where exactly that data store(Table Name and Field Information)You Have to Just chage the Name of the Database and the Search String....
2006-09-29 (first published: 2006-09-13)
700 reads
This script will create two views and select the data from the TableReferences view. This view will give list of all the foreignkeys of the selected database with its constraint name, the table name and column name(s) on which the constraint is created and the referencing table name and column name(s).
2006-09-25 (first published: 2006-08-25)
606 reads
Below script will Get SQL job status for all servers running on the same network. All you have to do is create a linked server with msdb on local machine. Executing this script will give you all job status on any number of servers. Good for an environment where a DBA had to see job […]
2006-09-20 (first published: 2006-08-25)
756 reads
Often in development environment you want to truncate all the tables to insert new data from production, but you cannot do easily as there were a bumch of Foreign Keys and triggers. Dropping all triggers and FK's and then recreating them again is a tedious job. That to dropping and recreating FK's in a particular […]
2006-09-19 (first published: 2006-08-31)
259 reads
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Comments posted to this topic are about the item Another Model, More Data Loss
Comments posted to this topic are about the item Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers