If you sort by in ASC order by column that may include NULLs and empty strings ( if type is varchar), the records with nulls will always appear before any others.This script will show how to chagne this pattern and move all records with NULLs to the bottom of your recordset
2002-05-23
226 reads
When restoring a database to a different server, this script will sync the users to the system logins. (as a relative newcomer, I'm pretty proud of this)
2002-05-23
457 reads
2002-05-22
237 reads
When you have a variable that hold a comma separated numbers like '1,2,3' and you have a table with a column that has the value that should match a number in that list, you can use this script to avoid building a string and then executing it.You have to convert the columnID to varchar, the […]
2002-05-20
385 reads
This stored procedure produces a report of record counts for every table on your server. The record count report is organized by database, and table name.
2002-05-16
661 reads
I have a set of data that I need to display in a random order each time I displayed it. There are several ways to do this, for example using a CURSOR to add each record to a temp table with a GUID, but a quick and dirty way to do this is to use […]
2002-05-16
521 reads
Since SQL Mail periodically stops working and the simplefix is to stop and start it, this script does just that.It can be scheduled to run as a task as often as desiredusing an ISQL command (e.g. isql -U sa -P -i "e:\dba\mailstopstart.sql" -o "e:\dba\mailstopstart.out")or as a stored procedure. It has been tested on SQL 6.5 […]
2002-05-16
1,181 reads
The information for backup size is stored in the backup_size column of the backupset table in the msdb database as the total bytes for that backup. This script allow you to look at the total back to tape or file so you can plan space needs for those devices. This is a simple piece of […]
2002-05-14
4,640 reads
Procedure that net sends a message to any user who logged in as SA.IN. had to use this once in the company where SA password was blank for a while and managment did not want to set a password on the account. You can also set it to work with any username or for users […]
2002-05-14
887 reads
Here is handy procedure to generate random number.I find it useful when I generate large amount of test data in a database.For example if you need to create a Customer Data and what they have purchased in the last month to run perfrmance tests on large amount of data an set up necessary indexes.You can […]
2002-05-13
700 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Are there any good articles on all the trace flags that are enabled on...
Comments posted to this topic are about the item The Data Model Matters
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers