|
|
-
|
|
As a SQL server DBA many times you may get to hear from users that he is not able to access the database, SQL server or any of the objects in SQL server. This may sometimes that the user is passing a wrong credentials or may be is trying to connect to SQL server through some applications but due to ......
|
|
-
|
|
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......
|
|
-
|
|
Sometimes we come across situation where in the Entire Space in TempDB will be unallocated space but we are unable to free up space neither we are able to shrink the database or file. This was how I was able to Free Up the unallocated space and it worked for me. So thought of sharing it. USE TempDB......
|
|
-
|
|
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 ......
|
|