Skip to content
March 6, 2021
  • 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   Data Platform Virtual Summit 2020   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
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra
    • Virtual Symposium Recordings
    • Geek Talks
  • PodCasts
  • Conference
  • Resources
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
    • Connect With Amit Bansal
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
Main Menu

Scripts

Scripts / SQL Server

Script: Find Top 10 CPU Intensive Queries

July 8, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

This blog post first appeared on SQLMaestros If you want to find the top ‘n’ queries that are currently in the cache, which are consuming more CPU, then you are at …

Read More
Scripts / SQL Server

Script: How to Identify Whether Optimizer is Reusing the Plans or Not

July 7, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

This blog post first appeared on SQLMaestros If you want to identify non parameterized queries that are hogging your SQL Server plan cache then you are at the right place. sys.dm_exec_query_stats …

Read More
Scripts / SQL Server

Script: Find FillFactor of All Indexes in a Database

July 6, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

This blog post first appeared on SQLMaestros In our previous blog posts, we have seen how to find fragmented indexes in a database and how to defrag them by using rebuild/reorganize. …

Read More
Scripts / SQL Server

Script: How to Defragment All The Indexes In a Database

July 3, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

This blog post first appeared on SQLMaestros In our previous blog post, we got to know, how to find out all fragmented indexes in a database. Now we will see how …

Read More
Scripts / SQL Server

Script: Find The Fragmented Indexes In A Database

July 2, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

This blog post first appeared on SQLMaestros We do create indexes to improve the search performance of our queries. But over a period of time, because of DML operations (inserts/deletes/updates), the …

Read More
Scripts / SQL Server

Script: Find Tables Without Clustered Index

July 1, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

This blog post first appeared on SQLMaestros Before we start fine tuning SQL Server, it is good to make sure all basic best practices are in place. One such best practice …

Read More

Subscribe to SQLServerGeeks

Ad

master classes

SSG_linkedin

SSG_fb

dps2017_logo_website

video courses

dps2017_logo_website

create your blog

guest_post

DataPlatformGeeks Social Media Channels

About Us

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

Subscribe To Our Newsletter

loader

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by SQLServerGeeks and DataPlatformGeeks.