Viewing 15 posts - 331 through 345 (of 992 total)
SQL Server doesn't have DATE columns, it only has DATETIME columns. The resolution of times in SQL Server is 3 milliseconds, thus you could do something like
AND (dbo.ISSUE_MAIN.REQUEST_DATE_TIME >=...
January 30, 2007 at 9:09 am
You can also use this syntax (works with updates as well).
delete from A
from tableA A
inner join tableB B
on A.pkey = B.Akey
this lets you delete...
January 30, 2007 at 9:04 am
These should help - describes how to move master, tempdb and msdb.
http://www.databasejournal.com/features/mssql/article.php/3379901
http://support.microsoft.com/kb/224071
Cheers
January 30, 2007 at 9:00 am
For starters, the syntax would be
select top 1 @trackingcode = trackingCode
FROM tblSerial ( READPAST, ROWLOCK)
ORDER BY cTime
--
UPDATE tblSerial
SET ctime=GETDATE()
WHERE trackingCode = @trackingCode
However, I believe that you want to...
January 30, 2007 at 8:54 am
January 30, 2007 at 8:46 am
Microsoft have a length yet friendly article on the topic as well as a FAQ.
See
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx
Neither of the above are the article that I remember reading back...
January 30, 2007 at 8:45 am
Thanks for the article - I had read it on CodeProject a couple of weeks ago (http://www.codeproject.com/cs/database/blob_compress.asp). Wanted to make sure each site had the same author,...
January 30, 2007 at 8:34 am
A brute force way could be to create a new table, move the data you wish to keep into it, drop the old table and then rename the new table...
January 24, 2007 at 7:32 am
Replication is one of those things I've read a LOT about but haven't had to put in to practice (yet).
However, I do know...
January 24, 2007 at 7:28 am
Hmmm... This will be slow on a lot of data and very clumsy to code.
Have you investigated Full Text Search?
It's a bit late here so I don't have time...
January 24, 2007 at 7:23 am
Gila's given you the correct approach. If you are doing a LOT of rows you may wish to break the transaction into several smaller batches. Something like
1. insert...
January 24, 2007 at 7:18 am
Perhaps you could run a profiler trace for a day and then reexecute chunks of it several times it in a quiet time - might indicate which statements cause the...
January 24, 2007 at 7:10 am
Hmmm... Is it anything like the other 30?
What if you put it into read only mode? Does it still lock then?
What are you using to view the tables,...
January 24, 2007 at 7:07 am
Cheers - thank you very much!! This is probably the nicest community that I visit on the net.
January 24, 2007 at 7:05 am
Viewing 15 posts - 331 through 345 (of 992 total)