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,383 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,372 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
819 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,904 reads
Reseeding Identity values
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
745 reads
2007-08-15 (first published: 2007-08-02)
295 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,831 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
843 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
353 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
195 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
Alamat BCA KCU BANJARMASIN Telp:(0817825533)
WA CS 62 817-825-533 Jl. Lambung Mangkurat No.11-13, Kertak Baru Ulu, Kec. Banjarmasin Tengah,...
Alamat Kantor BCA KCU TARAKAN Telp:(0817825533)
WA CS 62 817-825-533 Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar.,...
Alamat BCA KCU PONTIANAK Telp:(0817825533)
WA CS 62 817-825-533 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak...
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers