THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Indexes   (RSS)
Showing page 1 of 7 (66 total posts)
  • Geek City: Q&A

      I’ve done it again… I’ve neglected my blog so long that my name has been removed from the list of SQLBlog contributors on the right-hand side of the main page.  So I need to fix that. I have been accumulating a list of questions that have come up during my 5-day SQL Server Internals classes, that I cannot immediately answer. ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 15, 2015
  • Updateable Column Store Indexes in SQL Server 2014

    Introduction Column store indexes had been released with SQL Server 2012 to optimize data warehouse workloads that have specific patterns, data are loaded through T-SQL scripts or through SSIS packages, several times a day, in any case the frequency is not important, only that the available data is loaded in the same execution. At the end of ETL ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 16, 2014
  • Updated sp_indexinfo

    It was time to give sp_indexinfo some love. The procedure is meant to be the ''ultimate'' index information procedure, providing lots of information about all indexes in a database or all indexes for a certain table. Here is what I did in this update:Changed the second query that retrieves missing index information so it generates the index name ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on May 22, 2014
  • Geek City: Did You Know … that not everything you know is actually true!

    Software changes, new versions not only add new features, they also change internal behavior of old features,  and not all the changes are documented!  And how often, after a software upgrade, do you go through and test everything you knew was true, to make sure it is STILL true after the upgrade? I write books about the SQL Server ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 27, 2013
  • Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper for CTP2

    Last week at the PASS Summit in Charlotte, NC, the update of my whitepaper for CTP2 was released. The manager supervising the paper at Microsoft told me that David DeWitt himself said some very nice things about the technical quality of the paper, which was one of the most ego enhancing compliments I have ever gotten! Unfortunately, Dr. DeWitt ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 20, 2013
  • October Update to Rules-Driven Maintenance

    Happy Fall! It’s a beautiful October here in Minneapolis / Saint Paul. In preparation for my home town SQL Saturday this weekend, as well as the PASS Summit, I offer an update to the Rules-Driven Maintenance code I originally published back in August 2012. It’s hard to believe this thing is now more than two years old – it’s been an incredible ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on October 9, 2013
  • Incorrect Results Caused By Adding an Index

    It’s not often that a SQL Server bug really surprises me or makes me wonder how it was never spotted before, but this is one of those. To get right into it, say you have the following two tables: CREATE PARTITION FUNCTION PF (integer) AS RANGE RIGHT FOR VALUES (1000, 2000, 3000, 4000, 5000);   ...
    Posted to Page Free Space (Weblog) by Paul White on August 20, 2013
  • July, the 31 Days of SQL Server DMO’s – Day 23 (sys.dm_db_index_usage_stats)

    The sys.dm_db_index_usage_stats Dynamic Management View is used to return usage information about the various indexes on your SQL Server instance. Let’s have a look at this DMV against our AdventureWorks2012 database so we can examine the information returned. SELECT * FROM sys.dm_db_index_usage_stats WHERE database_id = ...
    Posted to Tamarick Hill (Weblog) by Tamarick Hill on July 23, 2013
  • July, the 31 Days of SQL Server DMO’s – Day 22 (sys.dm_db_index_physical_stats)

    The sys.dm_db_index_physical_stats Dynamic Management Function is used to return information about the fragmentation levels, page counts, depth, number of levels, record counts, etc. about the indexes on your database instance. One row is returned for each level in a given index, which we will discuss more later. The function takes a total of 5 ...
    Posted to Tamarick Hill (Weblog) by Tamarick Hill on July 22, 2013
  • T-SQL Tuesday: What kind of Bookmark are you using?

    I’m glad there is no minimum length requirement for T-SQL Tuesday blog posts, because this one will be short. I was in the classroom for almost 11 hours today, and I need to be back tomorrow morning at 7:30. Way long ago, back in SQL 2000 (or was it earlier?) when a query indicated that SQL Server was going to use a nonclustered index to get ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 10, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement