Viewing 15 posts - 10,666 through 10,680 (of 49,566 total)
Keith Tate (12/10/2013)
Kareem Abdul-Jabbar is the all-time leading scorer for the NBA (Basketball) and his career total is 38387. Going with the sports theme of the member levels.
The problem with...
December 10, 2013 at 10:34 pm
With formatting
IF @Action = 'U'
BEGIN
UPDATE p
SET P.Employee_uno = e.Empl_uno ,
...
December 10, 2013 at 2:27 pm
Keith Tate (12/10/2013)
Gail first ever SSC - Forever! We should start a pool on when she will reach SSC -Guru.
Currently at 350 posts a month. If that is sustained, 10000...
December 10, 2013 at 2:20 pm
No. You could probably write something complex that iterates through all the pages in the DB, runs DBCC page and parses the results, but it'll be complex. Might be something...
December 10, 2013 at 8:10 am
You can't restore down-version. A SQL 2012 backup can only be restored to SQL 2012 or newer.
December 10, 2013 at 8:02 am
SQL doesn't track that automatically. You'll need custom auditing for that.
December 10, 2013 at 7:47 am
If you do go that route then you don't need a full backup after the process, just a log backup after switching back to full recovery.
December 10, 2013 at 7:14 am
Have you considered bulk-logged recovery?
December 10, 2013 at 6:39 am
OLDCHAPPY (12/10/2013)
you go to the last good backup. in this case, before the shrink process. c'nest pas?
Correct, you go to the last good backup before the shrink, and because...
December 10, 2013 at 6:15 am
rajemessage 14195 (12/10/2013)
but my question is still not answered.
I answered your question
If you're trying to get queries running faster, don't waste your time looking at partitioning
December 10, 2013 at 6:11 am
OLDCHAPPY (12/10/2013)
am i missing something?...
December 10, 2013 at 5:55 am
OLDCHAPPY (12/10/2013)
GilaMonster (12/10/2013)
OLDCHAPPY (12/10/2013)
planning to leave about 10% free space so will check that it covers the space for index rebuilds. thanks to note that!
Free space in the data file...
December 10, 2013 at 4:31 am
Just be careful which pages/sec type counter from which object. Many have to do with reads from the page file, which is not what you're looking for.
I'd monitor the free...
December 10, 2013 at 4:29 am
OLDCHAPPY (12/10/2013)
planning to leave about 10% free space so will check that it covers the space for index rebuilds. thanks to note that!
Free space in the data file should be...
December 10, 2013 at 3:12 am
Viewing 15 posts - 10,666 through 10,680 (of 49,566 total)