|
|
-
|
|
2003, 2008, 2008 R2
SQL Server 2000, 2005, 2008, 2008 R2, 2012
*/
sp_configure 'show advanced options',1
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'xp_cmdshell',1
RECONFIGURE WITH OVERRIDE
GO
DECLARE @TimeZone NVARCHAR(100)
,@ProductVersion SYSNA...
|
|
-
|
|
Today, I am going to share few very useful scripts which will report us on Database Backup from different view points. To get the List/History/Log of all the Successful Backups SELECT b.machine_name, b.server_name, b.database_name...
|
|
-
|
|
It's my bad that I did not made a post since long lately. I would not make an excuse like I was busy, rather, I would say I am little lazy DBA, but I now onward I will try to post blog more frequently.
Well, if you remember, earlier I have posted som...
|
|
-
|
|
Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement
SELECT * FROM
MASTER..SYSPROCESSES
WHERE BLOCKED != 0
Yes, I’ve found the culprit SPID that is occupying more resour...
|
|
-
|
|
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation goes like: FB Friend: Hi I : Hi FB Friend: I need your help FB Friend : My SQL Server is not starting... I : What is an error you are gett...
|
|
-
|
|
Last week I had interesting (or I can say weird ? ) case of Maintenance Plan. One of the server that we monitor has reported job failure – this was a part of maintenance plan. Looking at the job history and log file I came to know that this job was failin...
|
|
-
|
|
In recent past while working on an assignment I have encounter an error 701 There is insufficient system memory to run this query . I had a quick look at the server and noticed that server is not configured proper for max memory, and have suggested client...
|
|
-
|
|
Deepak Kumar (friend of mine and founder of http://www.sqlknowledge.com ) were chatting yesterday. We were discussing about audit feature in SQL 2008, Deepak has enabled this feature for one of his client since month. And when he was looking at the log h...
|
|
-
|
|
While working on an assignment of troubleshooting performance issue few month back I have come across a situation where I have to provide good information about the different waittypes and what they do, while researching a good documentation on wait type...
|
|
-
|
|
Few month ago I have written a post about what is Auto Growth and what is the best practice for Auto Growth. In this post I have discussed about why should we have Auto Growth for databases set in a fixed MB instead in percentage and how it will impact...
|
|