SQLKnowledge.com

Day by day Experience of a Microsoft SQL Server production DBA & Consultant..

List of Undocumented DBCC command..

List of Undocumented DBCC command..
DBCC activecursors [(spid)]
DBCC addextendedproc (function_name, dll_name)
DBCC addinstance (objectname, instancename)
DBCC adduserobject (name)
DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)
DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag])
DBCC balancefactor (variance_percent)
DBCC bufcount [(number_of_buffers)]
DBCC buffer ( {‘dbname’ | dbid} [, objid [, number [, printopt={0|1|2} ][, dirty | io | kept | rlock | ioerr [...]

How long does a SP stay in the cache?

 As a SQL Database Developer or Administrator you must be eager to know how long does a stored procedure execution plan stay in the cache? On what basis and parameters MS SQL Server decide age of an execution plan to reside in cache?
Well the answer is, it is based on the cost factor and number [...]

Get Notification as soon as SQL Services are restarted

Being production DBA and responsible for a dozen to 100+ SQL Servers running in your organization or datacenter, Sometimes, you must be wondering that how you can make sure you are fully aware what is going when you are not at work. There is an easy way to stay in touch with your SQL Server(s), [...]

Script to find used and free space in Database files

Just imagine, you have over 100+ databases available on the server and suddenly disk space alarm hit your inbox. What will you do, storage can not be added or expended on the fly. Here is he tested script to find used and free space from SQL Server database’s data files that you can shrink to [...]

Website renovated

Dear site follower,
Due to some technical reasons we had to recreate whole website from scratch and team will be uploading latest SQL Server related data. Apologies if you are not able to find some of the link you have saved for future usage. SQL Forum is discontinued immediately and all formally registered users are requested to sign-in on new [...]