Viewing 15 posts - 1,636 through 1,650 (of 3,232 total)
Ah, I never finished one of my thoughts in my previous post. Instead of having 10 sets of columns, your table should only have one Status, Time, and Comment...
July 10, 2008 at 12:49 pm
OK, I think I've got where you are going with this and Barry is absolutely correct. What you are trying to do can, and should, be done in one...
July 10, 2008 at 12:47 pm
Are you getting an error? What do you mean by ' can not seem to restore the DB to the new server'?
July 10, 2008 at 12:34 pm
SQL Server creates a checkpoint in order to keep the recovery time to a minimum (as you've already read if you're getting into changing the recover interval). When a...
July 10, 2008 at 12:33 pm
I'm going to have to agree with Grant here. I think that the ANSI joins are not only a better place to start, but they are easier to read....
July 10, 2008 at 12:27 pm
Well, if you know for sure that table B only holds the first 8 (plus the period, so 9) of the ID, just change the JOIN predicate to reflect that....
SELECT...
July 10, 2008 at 12:03 pm
Another comment here. If you are seeing the physical size of your data file decrease without running a shrink file, check your DB settings and make sure auto shrink...
July 10, 2008 at 11:44 am
As your indexes are being rebuilt, it may appear that your database is 'shrinking' in logical size but what is really happening behind the scenes is that SQL Server is...
July 10, 2008 at 11:42 am
David is right here. Your explanation of what is happening doesn't help us give you a place to start.
Can anybody let me know that a store procedure...
July 10, 2008 at 11:31 am
SELECT a.*
FROM TableA a
LEFT JOIN TableB b
ON a.keyid = b.keyid
WHERE b.keyid IS NULL
July 10, 2008 at 11:23 am
So you are loading this data into a table and you want to create a column on the table that holds this incremental value and you want to be able...
July 10, 2008 at 11:22 am
Is there a specific memory problem that you are having?
July 10, 2008 at 11:13 am
I suppose more background on why the OP wanted this would have been helpful. I agree that scanning the table to get the row count on very large tables...
July 9, 2008 at 3:56 pm
The query optimizer is 'smart' enough to create the execution plan for a query based off of the actual data within a parameter. It can use the value of...
July 9, 2008 at 3:15 pm
Yes, I'll agree 100%. Not performing periodic restores of your backups is not being diligent. If you don't test the restores, you can't rely on the quality of...
July 9, 2008 at 3:07 pm
Viewing 15 posts - 1,636 through 1,650 (of 3,232 total)