Yet another way to defrag indexes
A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.
2016-07-28 (first published: 2014-06-06)
2,323 reads
defragmentation
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.
2011-12-13
5,779 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
2012-10-18 (first published: 2009-11-18)
12,182 reads
2004-04-16
RE: Documentation of system SPs, UDFs, Tables and columns
Hey biker,your avatar is also kinda cool! Although I prefer a Fireblade Now, for the pseudo topic relation:I think Andy Warren mentioned some time ago, he has some SQL Server table maps to share.
2004-01-07
1 reads
RE: Multi-statement table-valued UDF problem
Äh, now I'm really confused! I still believe my post was not targeted to the original question. Did we find a solution or not? Frank http://www.insidesql.de http://www.familienzirkus.de
2004-01-03
1 reads
RE: SP Problem With VB6
You could have coded your SP as follows CREATE PROCEDURE usp_check_login @username varchar(20), @password varchar(20) AS SET NOCOUNT ON SELECT user_id, user_active as login_active, user_loginattempts as login_attempts, user_type FROM tbl_user WHERE user_username = @username AND user_password = @password RETURN @@ROWCOUNT GO That way you could use your RETURN_VALUE to determine whether or not your user […]
2003-12-23
3 reads
RE: How to format DateTime?
just get rid of the time part on the input and sample dates. Method1 casting as int Cast(@inputDate1 as int) Method2 remove time part @newinputdate = Cast(Convert(varchar(10),@inputDate, 101) as datetime) Method3 you could use acombination of DateDiff using 'd' as the difference HTH
2003-11-13
1 reads
RE: Invalid characters
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
RE: DeadLock
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-08-29
Blogs
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...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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