Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.
2014-04-07 (first published: 2014-03-12)
1,704 reads
2014-04-03 (first published: 2014-03-12)
1,220 reads
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,589 reads
2014-03-31 (first published: 2014-03-03)
1,249 reads
Script to Automatically Backup, Drop and create Agent Job to restore from that backup.
2014-03-25 (first published: 2014-03-03)
1,082 reads
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,368 reads
Script to Check the Database Backup duration of entire instances
2014-03-19 (first published: 2014-02-25)
2,145 reads
Script to get the Database restore history details including with the files by which the database is restored.
2014-03-17 (first published: 2014-02-25)
1,318 reads
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,549 reads
2014-03-13 (first published: 2014-02-25)
1,117 reads
Referrals have never been more important in the job market. They’re no longer nice...
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....
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers