|
|
-
|
|
The SQL server Jobs which are running on a Instance are very Important. As a DBA you need to take care of these Jobs and have all information about the Job. Your will get information on Jobs is SysJobs but again not in the way you want. So just thought of pulling the Job information and below is the......
|
|
-
|
|
As a DBA you always need to monitor various metrics of a Database server. Disk space is one such metric you gotta watch out for. Monitoring Disk space for SQL server 2000 is bit difficult through script. Just happened to write a Script for SQL server 2000 which gives you free disk space in GB for al......
|
|
-
|
|
This seems to be an very interesting error which one may receive while running DBCC ShrinkDatabase command. The full error is as follows Cannot use the PAGE granularity hint on the table “tablename” because locking at the specified granularity is inhibited. The error occurs when you have one or m......
|
|
-
|
|
It happens so that when you drop/delete a Database Role in SQL Server Database, the Role members who were assigned to this role wont get de-associated from this Role. No doubt the role will be dropped/deleted but the member will be having this Role still existing in their permission list. So I came ......
|
|
-
|
|
There are times where the SQL Server and SQL Server Agent Services are running fine post installation but your SQL Server Agent might not start after a restart of your SQL Server and SQL Server Agent services post installation. There may be many causes out of which the one which I am discussing is o......
|
|
-
|
|
Recently I came across a situation where in I had to change the Email ID for all alerts and Mail Items on multiple servers. If you want to accomplish this through GUI it would be quite painful. After digging out I found out an easy way. 1. You can accomplish this by running the below set of query o......
|
|
-
|
|
Restore the Source Database to Destination Database with parameter KEEP_CDC. Only “KEEP_CDC” needs to be included in “WITH” Option while restoring database. Ex: WITH KEEP_CDC <span style=......
|
|
-
|
|
Hello!!.. At times i came across situations when i need to search for particular index name and on which table it is and for which database. To help me out i came across with this small piece of code yet very useful. So posting it out thought might help out. Query: EXEC sp_MSforeachdb 'USE ? s......
|
|
-
|
|
<p>Change Data Capture popularly known as CDC is a new feature in SQL Server 2008 that records insert, update and delete activity in SQL Server tables. A good example of how this feature can be used is in performing periodic updates to a data warehouse. CDC records (or captures) DML acti......
|
|
-
|
|
As a DBA its not only we need to check for SQL Server Error Logs but often we also need to check for Windows Event Log for any Critical Error or Warning as well. Incase a daily check list needs to be followed at that time reading events if in thousands and filtering is a big pain. Here is where WMI ......
|
|