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
Fragmentation
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: TRANSFORMING DATE USING DTS
I would suggest maintaining the date-time column, and creating a set of computed columns which return the values using the DATEPART function. This will allow you to do date arithmetic in the future, as well as view the attributes you need now.
2003-07-30
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: Primary keys missed
No, the only transfer that is made daily is performed by bcp against several tables, which doesn´t have any relation with the tables with missing keys
2003-07-08
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
RE: Transaction log Backup Fail
The select into/bulk copy option is mainly to make bulk inserts/updates go smoothly. When doing a huge insert, the transaction log needs to continuously grow and it might not be able to grow fast enough. Imagine inserting a million rows, but only allowing your transaction log to grow by 100 MB. It probably won't grow […]
2003-07-03
RE: Locking problem
In a previous reply I did indicate that there was a BEGIN TRAN on the first connection before the first Insert. And I believe you are right that just closing the recordset might be enough to prevent the second connection from being created. I observered the second connection in Query Analyzer while the app is […]
2003-07-02
Blogs
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
European Microsoft Fabric Community Conference announcements
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
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