Query to find the size of the database and database file
Hi All, Query to find the size of the database and database file is a simple and most common requirement. There are many ways & techniques to do this. Here are ‘just’ …
Read MoreAuthor: Rahul Sharma
Find the Size of all Tables in a Database – SQL Server Query
Hi All, Find the Size of all Tables in a Database is a simple and most common requirement. And whenever I come across these requirements, I get a little nervous since …
Read MoreSQL Server Change Job Owner – using ALTER LOGIN
I read Amit’s blog on Replication regarding the server name change (https://www.sqlservergeeks.com/sql-server-replication-requires-the-actual-server-name-to-make-a-connection-to-the-server/). It also reminds me that after changing the name of the server, some jobs were failing because the original …
Read MoreSQL Server 2012 DENALI-new DMV- sys.dm_os_windows_info
Dear All, As I mentioned in my last few posts, I have started exploring new DMVs and some enhancements to existing DMVs in SQL Server 2012 DENALI. My last few posts …
Read MoreSQL Server 2012 DENALI new DMV- sys.dm_os_volume_stats
Dear All, As I mentioned in my last post, I have started exploring new DMVs and some enhancements to existing DMVs in SQL Server 2012 DENALI. In my last post I …
Read MoreSQL Server 2012: DENALI-new columns added to sys.dm_exec_query_stats
Dear All, I have started exploring new DMVs and some enhancements to existing DMVs in SQL Server 2012 (DENALI). Today, I will talk about sys.dm_exec_query_stats – this DMV is heavily used …
Read MoreSQL Server: Did someone talk about DBCC ROWLOCK? – Its discontinued !
Today, at my workplace, we talked about locking and DBCC ROWLOCK came up. Many of you know, but I still want to say – it has been deprecated now. If I …
Read MoreSQL Server: Removing a specific plan from the plan cache using DBCC FREEPROCCACHE
Dear All, It is possible to remove a single, specific plan from the plan cache. DBCC FREEPROCCACHE optionally accepts a parameter, plan_handle, which uniquely identifies a particular plan. But before you …
Read MoreSQL Server error message severity levels – sys.messages
There are about 98000 error messages as of SQL Server 2008 – including repitions for all the languages supported. sys.messages catalog view represents one row per error message. You can simply …
Read MoreDetect SQL Server CPU Pressure
Dear All, The other day I saw a blog post from Amit regarding version store troubleshooting. I have been involved in similar scenarios of performance issue where the SQL Server box …
Read More