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 MoreSQL 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’ …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
Read More