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
Automated index defragmentation script
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: 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
RE: Explicit Transaction behavior fun
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
RE: Explicit Transaction behavior fun
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
RE: trigger cache?
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
RE: Already sorted?
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
RE: SQL Server Upgradation
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
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
Database copies (cross environment) and sizing strategies for 2019
I'm sure this has been asked many, many, many times and hoping several optimal...
TSQL to determine status of subscription reinitialization
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
migration
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC