Viewing 15 posts - 10,666 through 10,680 (of 49,552 total)
Please note: 4 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 12:01 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2013 at 10:34 pm
With formatting
IF @Action = 'U'
BEGIN
UPDATE p
SET P.Employee_uno = e.Empl_uno ,
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2013 at 8:02 am
SQL doesn't track that automatically. You'll need custom auditing for that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2013 at 7:14 am
Have you considered bulk-logged recovery?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2013 at 6:11 am
OLDCHAPPY (12/10/2013)
am i missing something?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2013 at 3:12 am
Viewing 15 posts - 10,666 through 10,680 (of 49,552 total)