How efficient is your covered index?
Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.
2015-10-09 (first published: 2013-08-12)
14,329 reads
covering index
Finding all Columns of an Index
This script helps to find all columns of an index on a table. Include columns covered (include)
2011-06-17 (first published: 2011-05-31)
1,352 reads
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,698 reads
RE: Removing IDENTITY Constraint
Please avoid double postings. Let's continue here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=101113
2004-02-19
RE: Help Needed - Need to load 6.5 database to 2000
quote: I needed to load one SQL Server 6.5 database into SQL Server 2000. You have to perform upgrade from SQL Server 6.5 to 2000. quote: Also can we have SQL Server 6.5, 7.0 and SQL Server 2000 on the same machine?! If you have SQL Server version 6.5 installed, you can keep the SQL […]
2003-08-06
RE: Storing arrays in SQL.
My guesstimates are that this database, including indexes, will already amount to 1/2 terrabyte in size. Now if I included that schema for coping with arrays, god knows what size it will reach. With some tables with an estimated 500,000 records, that will then need 1,000,000 records in an array table at least. Database sizes […]
2003-07-31
2 reads
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
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
Daily Coping 6 Dec 2022
By Steve Jones
Today’s coping tip is to find a new way to tell someone you appreciate...
What’s next: Job search burnout
I was given 4.5 months notice this past June and was fortunate to find...
Forums
Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns
Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...
The Availability Group Secondary Connection
Comments posted to this topic are about the item The Availability Group Secondary Connection
SSRS Expression Error
I am getting the following error when I try to use the Expression below....
Ask SSC