Automated index defragmentation script

Technical Article

RE: Explicit Transaction behavior fun

  • Reply

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

Technical Article

RE: Explicit Transaction behavior fun

  • Reply

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

Technical Article

RE: trigger cache?

  • Reply

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

Technical Article

RE: Already sorted?

  • Reply

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

Technical Article

RE: SQL Server Upgradation

  • Reply

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

In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023

By

Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 

By

When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs

Forums

Database copies (cross environment) and sizing strategies for 2019

By MyDoggieJessie

I'm sure this has been asked many, many, many times and hoping several optimal...

TSQL to determine status of subscription reinitialization

By ratbak

How do I determine the initialization status of a subscription with T-SQL -- i.e,...

migration

By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers