Unique Identifier as Clustered index
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,206 reads
Tuning
Optimizing a cursor based routine – Part 2
In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.
2011-06-28
5,191 reads
Optimizing a cursor based routine – Part 1
Learn how you can remove a cursor and optimize a routine that loops through a series of data and performs various calculations in this short article from Dave Ballantyne.
2011-06-27
7,669 reads
2015-02-12 (first published: 2010-03-12)
4,914 reads
Check status of HEAP tables
This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!
2010-04-09 (first published: 2010-03-09)
2,136 reads
RE: JOB EVENT
Nita,I would guess that the SQL Server Agent is attempting to log in to the SQL Server as sa.To verify, right-click on the SQL Server Agent in Enterprise Manager and select Properties.You will then see a Connection tab. You'll likely have this set for "Use SQL Server Authentication" with sa as the user. Just enter […]
2005-03-10
RE: when it grows beyond'''' and "amount of free space to remain after shrink
Is there any thumb rule which can be used to decide about this selection.Pls suggest
2005-03-10
RE: Hits and Misses
I agree with the others, very interesting article and something that I did not know about. However, I am not quite sure that everything is fully correct in the article, or at least I am not sure what conclusions to draw from it. First off, I could not trace any SP:CacheMiss events when only the […]
2005-03-10
RE: SQLServerCentral.com Celebrates our 200,000 Member Milestone
My XBox arrived this morning.Once again, thank you very much and keep up the good workMany thanksSteve
2005-01-21
RE: DTS VS Linked Server
Even if you choose the Linked Server option you could still wrap it all up in a DTS package for ease of manageability.Regards
2004-07-16
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