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,246 reads
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,246 reads
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
Ä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
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
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
quote: 1. I originally wrote it as a single select. Unfortunately, the view has nolocks so SQL Server would put together the view first and then get information from the audit table, which was changed at the same time the view was put together, and join the data, which was then out of sync. As […]
2003-07-31
Thanks again for replying. 1. I originally wrote it as a single select. Unfortunately, the view has nolocks so SQL Server would put together the view first and then get information from the audit table, which was changed at the same time the view was put together, and join the data, which was then out […]
2003-07-31
STAX68, Your reply led me down the right path. It turns out I was calling the sproc from two different triggers. When I renamed the sproc and fixed one trigger the other trigger was still hanging out there.
2003-07-28
1 reads
hi, taken directly from BOL, "For example, to bulk copy data from the Authors.txt data file to the authors2 table in the pubs database, specifying that the data file is in ascending order on the au_id column, execute from the command prompt: bcp pubs..authors2 in authors.txt -c -t, -Sservername -Usa -Ppassword -h "ORDER (au_id ASC)" […]
2003-07-08
1 reads
There is no SQL 7.5. I guess you are referring to 6.5. Here is a link to Converting Databases to Microsoft SQL Server 7.0 http://support.microsoft.com/default.aspx?scid=%2fsupport%2fsql%2fcontent%2f70papers%2fconvert.asp
2003-07-03
1 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...