SQL Server Education (by the geeks, for the geeks)
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’ …
Query to find the size of the database and database file Read MoreHi 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 …
Find the Size of all Tables in a Database – SQL Server Query Read MoreI 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 …
SQL Server Change Job Owner – using ALTER LOGIN Read MoreDear 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 …
SQL Server 2012 DENALI-new DMV- sys.dm_os_windows_info Read MoreDear 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 …
SQL Server 2012 DENALI new DMV- sys.dm_os_volume_stats Read MoreDear 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 …
SQL Server 2012: DENALI-new columns added to sys.dm_exec_query_stats Read MoreToday, 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 …
SQL Server: Did someone talk about DBCC ROWLOCK? – Its discontinued ! Read MoreDear 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 …
SQL Server: Removing a specific plan from the plan cache using DBCC FREEPROCCACHE Read MoreThere 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 …
SQL Server error message severity levels – sys.messages Read MoreDear 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 …
Detect SQL Server CPU Pressure Read More