Performance Myths : Clustered vs. Non-Clustered Indexes
Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
2017-04-17
5,314 reads
non-clusterd index
Covering Index using Included Columns
This article from Josef Richberg details the benefits of included columns for use in creating a covering index to improve performance.
2010-02-11
12,658 reads
Default Database and Transaction log locations
I am looking to set the default database locations on our sql servers to make it easier to roll out new databases through scripts.Do you need to stop and start the SQLSERVERSERVICE for this change to take effect?Thanks in advance Carl
2005-01-17
RE: need help -Stored Procedure -Incorrect syntax
OK i workig 100% thnks a little question how can i add more filed to update like ---------------- @Fname [nvarchar](50),@fld1 [smalldatetime], @fld2 [int], ----------------------- i wont to learn the method --------------------------- declare @na varchar(500), @sisi int, @mmh char(10) set @sisi='2' set @mmh='uuu' select @na = @na + cast([na] as varchar) + ',' FROM [vsisi] UPDATE […]
2003-07-05
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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