|
|
-
|
|
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...
|
|
-
|
|
On many forums I have found a very basic yet important query - “How can I know when was my Stored Procedure last executed?” And today through this blog I will try to answer this question.
Actually speaking, without explicit logging or tracing, it is not p...
|
|
-
|
|
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...
|
|
-
|
|
Friends,
Last Saturday, 21st we have 2nd meeting of SUG members and this time we made progress – I, Vinay and Matang was present in meeting .We have discussed following :
We have decided that portal management will be done by I, Vinay and Mata...
|
|
-
|
|
MS has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 Released? which has fixes reported after SQL Server 2008 SP 3, this build version is 10.00.5768.00.
Below are the bugs that have been fixed in this CU:
FIX: A backup operation o...
|
|
-
|
|
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...
|
|
-
|
|
Couple of week back I have received a special gift, from the person whom I admire as a elder bro and mentor – Satya SkJ. Recently he has written a cook book on SQL Server 2008 R2 Administration, forward written by MVP Brad McGehee, and reviewed by Vinod ...
|
|
-
|
|
Microsoft has recently released a Cumulative Update (CU) # 16 for SQL Server 2008 SP1 which contains hotfixes which were resolved after SQL Server 2008 SP1; once you will install / apply this CU the server version would be 10.00.2850.00 As always ...
|
|