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,372 reads
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,372 reads
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,355 reads
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
801 reads
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,889 reads
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
726 reads
2007-08-15 (first published: 2007-08-02)
283 reads
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,814 reads
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
832 reads
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
343 reads
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
184 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers