SQLKnowledge.com

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

Audit databases – using ddl triggers

 
As a DBA, do you ever wonder what is going inside your production database? Who is changing database schema during production time without informing you. Now, you need not to worry, you can setup DDL triggers to easily records all changes in table; like what was changed, when and by whom etc. Given is two [...]

Common logshipping issues!

While working on SQL Server logshipping a DBA must consider following points to have log shipping setup running smoothly over a long period of time.
1. Transaction log Backup and restoration jobs should work constantly (in parallel) and if backup/restoration jobs are not in sync due to network/server or any other issue it will crash logshipping [...]

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 [...]

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 [...]