Viewing 15 posts - 15,406 through 15,420 (of 49,552 total)
If you think that partitioning = magic performance improvement, you'll be sorely disappointed. While it can give performance improvements, the queries may have to be rewritten to take advantage of...
November 30, 2012 at 1:11 pm
Not sure I follow what you're trying to do. What do you mean by 'materialized view log'?
November 30, 2012 at 12:56 pm
First question...
Why are you partitioning? What's the reason, what's the goal?
November 30, 2012 at 12:55 pm
sdpages (11/30/2012)
November 30, 2012 at 12:50 pm
ScottPletcher (11/30/2012)
Grant Fritchey (11/30/2012)
For lots more...
November 30, 2012 at 12:49 pm
Seek when there's a SARGable predicate (<column> <comparison operator> <expression>) on the index key columns. Scan if there isn't. Very, very simplified, but that's the basics.
November 30, 2012 at 8:12 am
The question then becomes, what's the reason for taking a copy-only log backup.
November 30, 2012 at 6:00 am
There is no guest login. If you don't have either a username and password or a windows login granted access to the DB, you cannot log in to SQL.
There are...
November 30, 2012 at 3:59 am
Highly unlikely to work. SQL can only recreate the log file if the DB was cleanly shut down prior to the log being damaged/lost.
November 30, 2012 at 12:09 am
NTesla (11/29/2012)
Solved.RAID array had one black sheep.
Ah-ha!
Too bad that the card is so cheap it doesn't give any warning...
Well there's your motivation for better hardware...
November 29, 2012 at 1:38 pm
Something's taking full backups of the DB other than your SQL agent backup jobs. I've seen that with BackupExec, can probably happen with other VDI backups. Whatever they're using to...
November 29, 2012 at 12:08 pm
Viewing 15 posts - 15,406 through 15,420 (of 49,552 total)