statistics (data)

Managing SQL Server Statistics

  • Article

Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but if the statistics don't accurately reflect the current contents of the table you'll get a poorly-performing query. How do you find out if statistics are correct, and what can you do if the automatic update of statistics isn't right for the way a table is used?

2013-04-15

6,631 reads

Blogs

Database Fundamentals #22: Using the Join Operator, CROSS JOIN

By

While the CROSS JOIN is not used much, and, depending on the size of...

Automate Your SQL Notebooks with Two New Options

By

There are two new options for automating your SQL Notebooks with your SQL Servers....

Debugging techniques (focusing on T-SQL)

By

tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems....

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Publishing article revision updated intro comment date in article forum

By Solomon Rutzky

I recently revised an article, https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-2-sample-stored-procedure-and-function , and just noticed that, in the article-specific forum...

Date parameter

By khalil

Hii everyone I am trying to build a report but the date format in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers