Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.
2003-11-04
1,286 reads
This sp is used to update index in a database. This sp has got three optional varchar parameters. First parameter will take the tablename. Second parameter will take the indexname. Third parameter will take the fillfactor. The following option we can execute the sp in a user database.1. exec StabilizeIndexIt will update all index in […]
2003-10-29
276 reads
This function lists the column name and column id for primary key columns for a given table.
2003-10-24
1,513 reads
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.
2003-10-08
8,552 reads
This script will generate a set of DBCC DBREINDEX commandsthat can be executed to rebuild the indexes. Additional information is provided to assist with sizing of the fillfactors.
2003-10-03
604 reads
This article by Jon Winer offers some tips to help you get the most of SQL Full Text Search.
2003-09-25
12,540 reads
Hi, Thanks for reading my article and offering questions and comments and pointing out my mistakes. I am in China on vacation now. I'll be able to better respond to your questions/comments when I come back, if they are not answered at that time. Cheers and thanks again. Haidong
2003-09-14
1 reads
That is correct - I ran into that problem also a while back (no sp_executesql inside a function). Kind of an obstacle. Perhaps you can build the SQL like 'SELECT ' + @theField + ': + CONVERT( VARCHAR(50), ' + @theField + ' ) FROM ' + @theTable + ' WHERE ' + @theCondition Good […]
2003-09-02
Thanks for all your help! Upon research, I realize that this table was designed poorly. Multiple apps supply the need for multiple data types on this field on the table. It is quite a mess. However, I fixed the problem by creating a view of the table and changing the field to integer in the […]
2003-09-02
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-09-01
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers