Skip to content
February 7, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Rahul Sharma

SQL Server

Query to find the size of the database and database file

March 19, 2012September 18, 2014 - by Rahul Sharma - 5 Comments.

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 More
SQL Server

Find the Size of all Tables in a Database – SQL Server Query

March 13, 2012September 18, 2014 - by Rahul Sharma - Leave a Comment

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 …

Find the Size of all Tables in a Database – SQL Server Query Read More
SQL Server

SQL Server Change Job Owner – using ALTER LOGIN

January 16, 2012November 28, 2014 - by Rahul Sharma - 1 Comment

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 …

SQL Server Change Job Owner – using ALTER LOGIN Read More
SQL Server

SQL Server 2012 DENALI-new DMV- sys.dm_os_windows_info

December 1, 2011September 24, 2014 - by Rahul Sharma - Leave a Comment

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 …

SQL Server 2012 DENALI-new DMV- sys.dm_os_windows_info Read More
SQL Server

SQL Server 2012 DENALI new DMV- sys.dm_os_volume_stats

November 30, 2011September 24, 2014 - by Rahul Sharma - Leave a Comment

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 …

SQL Server 2012 DENALI new DMV- sys.dm_os_volume_stats Read More
SQL Server

SQL Server 2012: DENALI-new columns added to sys.dm_exec_query_stats

November 29, 2011August 28, 2014 - by Rahul Sharma - Leave a Comment

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 …

SQL Server 2012: DENALI-new columns added to sys.dm_exec_query_stats Read More
SQL Server

SQL Server: Did someone talk about DBCC ROWLOCK? – Its discontinued !

September 27, 2011August 28, 2014 - by Rahul Sharma - 2 Comments.

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 …

SQL Server: Did someone talk about DBCC ROWLOCK? – Its discontinued ! Read More
SQL Server

SQL Server: Removing a specific plan from the plan cache using DBCC FREEPROCCACHE

September 21, 2011August 28, 2014 - by Rahul Sharma - 1 Comment

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 …

SQL Server: Removing a specific plan from the plan cache using DBCC FREEPROCCACHE Read More
SQL Server

SQL Server error message severity levels – sys.messages

August 8, 2011November 14, 2014 - by Rahul Sharma - 2 Comments.

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 …

SQL Server error message severity levels – sys.messages Read More
SQL Server

Detect SQL Server CPU Pressure

August 4, 2011November 14, 2014 - by Rahul Sharma - Leave a Comment

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 …

Detect SQL Server CPU Pressure Read More

Posts navigation

1 2 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.