Skip to content
June 27, 2022
  • 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
  • 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

Tag: query tuning

SQLFun

SQL Server Performance Tuning – Serious SQL Fun

October 3, 2014October 4, 2014 - by Amit Bansal - Leave a Comment

Share it if you like it!

SQL Server Performance Tuning – Serious SQL Fun Read More
SQLFun

SQL Server Query Tuning – Serious SQL Fun

October 3, 2014October 2, 2014 - by Amit Bansal - Leave a Comment

Share it if you like it!

SQL Server Query Tuning – Serious SQL Fun Read More
SQL Server

SET STATISTICS PROFILE ON

September 23, 2014September 30, 2014 - by Amit Bansal - Leave a Comment

For example, in the above plan (zoomed out), it’s tedious to figure out where cardinality estimation has gone bad. You hover the mouse cursor over every arrow to see the numbers …

SET STATISTICS PROFILE ON Read More
SQL Server

SQL Server Implicit Conversion

September 19, 2014September 30, 2014 - by Amit Bansal - 1 Comment

Hi Friends, Are SQL Server Implicit Conversions expensive? Yes, they are! Not only does a SQL Server Implicit Conversion takes extra CPU, it can also cause loss of precision or fail …

SQL Server Implicit Conversion Read More
SQL Server

SQL Server – Did you know about Trace Flag 4136 ?

September 25, 2012December 9, 2014 - by Amit Bansal - 2 Comments.

Hi Friends, Parameter Sniffing, in general, is a good thing and your queries can benefit from that. Here are some of my blogs posts that you can read to get some …

SQL Server – Did you know about Trace Flag 4136 ? Read More

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

Subscribe To Our Newsletter

loader

Virtual Symposium

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