Viewing 15 posts - 24,301 through 24,315 (of 26,484 total)
Not sure if MERGE is needed here. The question only indicted that a record needed to be inserted if it did not already exist in the database. Nothing...
September 4, 2008 at 10:19 am
Could just be me, but answer 2 just seemed to be the logically correct answer to the question.
😎
September 4, 2008 at 9:57 am
Not sure about the Alter (it may require a restart of SQL Server), but if your app can afford some down time another way to accomplish the move is to...
September 4, 2008 at 9:13 am
Preston (9/4/2008)
Lynn Pettis (9/3/2008)
Preston (9/3/2008)
What does FILE = 1, NOUNLOAD, & STATS = 10 mean in a Restore statement? Thanks.
Lookup RESTORE in BOL. If you still don't understand,...
September 4, 2008 at 8:25 am
Preston (9/3/2008)
What does FILE = 1, NOUNLOAD, & STATS = 10 mean in a Restore statement? Thanks.
Lookup RESTORE in BOL. If you still don't understand, let us know...
September 3, 2008 at 10:49 pm
Symantics. If you restore DB2 using a just created DB1 backup, you have the same thing.
😎
September 3, 2008 at 10:12 pm
I'd have to agree with DavidB. I worked in an environment where I was trying backups directly to tape. I found the disk to disk backups were faster...
September 3, 2008 at 3:22 pm
Another option is HyperBac. We are using it, and it works quite well for us, and we still use standard SQL Server backup/restore commands.
Compression is about 80% and backup/restore...
September 3, 2008 at 3:16 pm
sg2000 (9/3/2008)
Thanks very much for the suggestions. I chose to use the one suggested by Leo (using Restore Wizard) since it is the easiest.
Grant Fritchey: Yes, you did...
September 3, 2008 at 2:51 pm
Go to redgate.com. If memory serves, they have a free tool that will read a SQL Server 2000 transaction log file (if your database is using the full or...
September 3, 2008 at 12:55 pm
GilaMonster (9/3/2008)
September 3, 2008 at 12:41 pm
What this does (colOne = @num1 or @num1 = 0) does is create a conditional where clause statement. If the value of @num1 = 0, you get all rows...
September 3, 2008 at 12:33 pm
rbarryyoung (9/3/2008)
You want the DENSE_RANK() function:
Select Id, DENSE_RANK() OVER(order by Id) as [Seq_Num]
From MyTable
Geez, get side tracked by work for a couple of minutes and someone beats me to...
September 3, 2008 at 12:14 pm
It really has nothing to do with SQL itself, it is simple logic.
Let's look at the first part of the WHERE clause:
(colOne = @num1 or @num1 = 0)
This part is...
September 3, 2008 at 12:07 pm
Also, is it possible that data may be deleted that may result in sequence numbers changing? Such as id 221777 in your sample data being deleted. Would 221778...
September 3, 2008 at 11:57 am
Viewing 15 posts - 24,301 through 24,315 (of 26,484 total)