It always annoys me when I see a newsgroup thread somewhere about a problem I am having, and the conversation stops before the problem is found or the resolution is posted. I will say that I recieved much better support and ideas from this forum than the MSDN Managed discussion groups. Thanks for trying everyone!
2004-08-20
If you want to remove all the data from a table, use TRUNCATE TABLE because its damn fast. The transaction log will just contain the TRUNCATE TABLE command.If you use DELETE FROM then the transaction log contains a record for EVERY ROW in the table, a slower process.
2004-08-20
SQL Profiler has a template for long running queries. You could run profiler and have it log to a table on the server. Then have a SQL Agent that emails you rows whenever there are some. Not exactly neat, or easy, but a way. It stops of course as soon as Profiler is stopped.
2004-08-18
I'm running into an issue with merge replication that has just started to crop up. I wrote a nice process for checking data in/out of a tablet for field work and something was missed in my documenting HOW I set it up.When I go to run a pull merge subscription from the subscriber I am […]
2004-07-21
70 reads
I'd convert the 3 dates to YYYYMM format: SELECT * FROM table_name WHERE CONVERT(char(6), some_field,112) BETWEEN CONVERT(char(6), lower_date_field,112) AND CONVERT(char(6), upper_date_field,112)
2004-06-23
Hi Chami, You can restore from another server by using the UNC path like:RESTORE DATABASE TestDB FROM DISK = '\\OldServer\backups\TestDB.bak' Derrik already pointed out the WITH MOVE option for placing the files in another location. Now you did say the MASTER database, which is another story. In order to restore the MASTER database, you need […]
2004-06-14
It looks like TIMESTAMP is really a VARCHAR column (since it has parenthesis in it), so try:DELETE FROM mytable WHERE CAST((SUBSTRING(TIMESTAMP,1,10)) AS DATETIME) < GETDATE()-90The SUBSTRING will get just the date portion. Then the CAST will change it to DATETIME (adding default time of 00:00:00.000).-SQLBill
2004-06-09
Thanks for replying Jeet, a) there's nothing in the event viewerb) It fails on the "EXEC @RC = sp_OAMethod @lFolder, 'Size', @lFolderSize OUT" line.c) The path is valid. It is checking (and copying/moving/deleting) thousands of folders and after a while there is this single error repeatedly (other OLE calls are still OK). (can't wait to user […]
2004-06-08
Hello to all. I have a DTS job that creates a flat text file including an amout field (money) when the column is written into the text file it has to be maked as follows:1. Amonut 25.23 or 485.562. Mask should be: 0000002523 (ten characters with leading zeros and no decimal point) or 0000048556I did masked […]
2004-06-08
1 reads
This has added logic to validate after a friday holiday to move to monday.create function fn_NextTrDate(@TrDate datetime) returns datetime as begin -- knock off the time part. SET @TrDate = dateadd(d,datediff(d,0,@TrDate),0) -- advance to next date (not using datepart because of @@datefirst concerns) set @TrDate = dateadd(dd, case datename(dw, @TrDate) when 'Sunday' then […]
2004-05-17
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers