Update Statistics - All Tables (No System)
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,370 reads
Maintenance and Management
Generate Drop / Create Script for views, stored Procedures
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,331 reads
proc to order xp_enumerrorlog
this is a quick stored procedure I put together when trying to find a log for a particular day (xp_enumerrorlogs returns the archive is as a varchar, so 1 is followed by 11, 12 etc rather than 2) sp_display_errorlogs with no parms returns output in archive id order. if the parm 'size' is passed in, […]
2007-09-21
769 reads
CPU Performance Check.
Script will Provide us about the person who is running query and from where and why it is slowing down your CPU.
2007-11-20 (first published: 2007-08-28)
2,885 reads
Reseeding Identity values
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
725 reads
2007-08-15 (first published: 2007-08-02)
280 reads
Extract More Than 1000 Active Directory Accounts
This is a simple method to load a SQL database with active directory account information without running into the 1000 record limit. You will need to change the SERVERNAME, PORT, DATABASENAME, USERID, AND PASSWORD values in the connection strings to your own values. You will also need to change the LDAP connection string values ('LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld') […]
2011-11-21 (first published: 2007-08-01)
2,810 reads
Get User Info
Returns database user information as a runnable script for the specified database. Great for restoring user access and permissions after a restore to a development server. Run this T-SQL script and copy the output to you favorite editor.Needed an easier way to script the user info than Enterprise Manager. Found a script by Clint Herring […]
2007-07-12
829 reads
Complete One Line Space Used
One line results sp_spaceused script. Also includes:DB Size= Data + DB Free Space + Transaction LogDB Data Size= Data + DB Free Space with no TLog DB Space Available= DB Free SpaceAll values are expressed in MB
2007-07-06
339 reads
Complete One Line Space Used
One line results sp_spaceused script. Also includes:DB Size= Data + DB Free Space + Transaction LogDB Data Size= Data + DB Free Space with no TLog DB Space Available= DB Free SpaceAll values are expressed in MB
2007-07-06
182 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...