Column Store vs Row Store Indexes
How does a column store index compare to a (traditional)row store index with regards to performance
2016-12-30 (first published: 2015-05-14)
13,690 reads
Covering Indexes
Ways to minimize sort operations
In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.
2010-09-15
10,904 reads
CASE With a Calculated Value
I'm trying to calculate a value and use that calculated value in a CASE statement without repeating it for each WHEN statement because of it's size and not wanting to cause processing to bog down. I've attemted the T-SQL below but get an error and the first inequality statement. Any help would be appreciated.SUM(CAST(ISNULL(o.Qty, 0) […]
2004-07-14
21 reads
RE: DTS date stamp
Try these steps..1. Map the file location as a drive (like F:\folder) to the server where the sql server is running. Specifying direct server path does not work.2. Run 'dcomcnfg' exe and add in the account that SQL Server agent is running under. If it is running unde SA account, then choose 'Everyone'.Hope this helps!!!-sundar
2004-07-14
sp_indexes_rowset
I have a stored procedure that is being executed constantly on the server , but is not being called from any of the asp code. I looked up this proc and found it is and undocumentated sp that will return detail information on the indexes of a table.Trace information: ( the trace shows hundreds of […]
2004-07-07
174 reads
RE: Clustered Indexes
Hi acudlip, quote: 1) drop the non-clustered indexes (takes seconds) - to avoid their rebuild when the clustered index is dropped. 2) drop the clustered index - takes 6 hours!! This is approx equal to the time it takes to build the clustered index - its a big table. how do you drop the indexes? […]
2003-07-15
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers