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,366 reads
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,366 reads
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,285 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
695 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,882 reads
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
722 reads
2007-08-15 (first published: 2007-08-02)
278 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,803 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
825 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
337 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
179 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I have a column that contains comma separated values. I'm trying to figure out...
Have anyone implemented CDC, and if so, what has been your experience with it?...
I'm getting a error when using the Import and Export wizard to copy tables...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers