Viewing 15 posts - 11,866 through 11,880 (of 49,562 total)
LiveSqlHelp (8/31/2013)
I would avoid the loop, create a temp table named #temp and insert the values of the Years from 2000 to 2010.
And you would do that without a loop...
August 31, 2013 at 10:35 am
You've got IO subsystem problems on ServerA. Do some diagnostics, check storage logs and consider moving the DB to alternate storage.
Corruption can't be replicated (or mirrored), so bad pages...
August 31, 2013 at 10:31 am
Google: tally table (or dates table maybe)
August 31, 2013 at 5:28 am
SQLAli (8/31/2013)
Yes, we can rename the instance by using the below commands. I have also involved once in this activity.sp_dropserver 'old servername'
go
sp_addserver 'new servername'
go
That does not rename a named instance....
August 31, 2013 at 5:27 am
Partitioning is not simple and it's not primarily for performance.
Filtered indexes are nice, but they're not simple either and there are lots of scenarios where they can't be used by...
August 31, 2013 at 3:57 am
Just ....
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a Friday...
August 31, 2013 at 3:43 am
Jay Purvis (8/30/2013)
August 30, 2013 at 1:31 pm
You could, but why would you want to? Restoring a backup's going to be faster and less work.
August 30, 2013 at 9:24 am
You did not need to shrink, it would not have had any effect.
August 30, 2013 at 7:42 am
kevaburg (8/30/2013)
There is no benefit.
Then I really must wonder why the ability to do it is there.
Many reasons. Performance is not one of them though
What happens when, on...
August 30, 2013 at 6:42 am
You're getting errors because GO is not a T-SQL command. It's a batch-breaker, designates where the client tool breaks commands apart to send the batches to SQL Server.
Take the GOs...
August 30, 2013 at 6:36 am
kevaburg (8/30/2013)
If log files don't get proportional fill then what would be the benefit of distributing them among multiple spindles?
There is no benefit.
August 30, 2013 at 6:33 am
kevaburg (8/30/2013)
The backup with truncate would reduce its size but the proprtional...
August 30, 2013 at 6:28 am
Viewing 15 posts - 11,866 through 11,880 (of 49,562 total)