Viewing 15 posts - 26,776 through 26,790 (of 49,552 total)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining 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
April 11, 2011 at 1:27 pm
Stefan Krzywicki (4/11/2011)
EDIT: Never Mind, Can't do FAST_FORWARD and STATIC on the same Cursor.
However LOCAL STATIC FORWARD_ONLY READ_ONLY works.
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
April 11, 2011 at 1:23 pm
Obviously I wasn't clear enough.
A restore of a diff/log MUST immediately follow the restore of the full backup. (Restore, not attach) and that restore MUST leave the database in recovering...
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
April 11, 2011 at 1:22 pm
Executions of the query after the first are faster because the pages are in memory and the plan is in cache. I generally just run queries more than once and...
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
April 11, 2011 at 12:31 pm
Stefan Krzywicki (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.People complained about the lizard?
Yes, I have a bunch of PMs on the topic. Not...
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
April 11, 2011 at 12:23 pm
Stefan Krzywicki (4/11/2011)
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
April 11, 2011 at 12:22 pm
You cannot restore anything (differential or transaction log) to a DB that's online. To restore a diff backup the DB has to be either Restoring or Standby, left in 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
April 11, 2011 at 12:14 pm
Ok, had enough complaints about the lizard. Let's see if this is better.
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
April 11, 2011 at 12:02 pm
Stefan Krzywicki (4/11/2011)
I just don't want to wipe all statistics on the machine because other queries use them to improve performance.
Errr, what statistics are you talking about and why do...
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
April 11, 2011 at 12:02 pm
Stefan Krzywicki (4/11/2011)
Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing it to set based code...
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
April 11, 2011 at 11:36 am
Politely suggest to your vendor that they switch to bulk-logged recovery. It'll minimally log then index rebuilds, but won't break the log chain.
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
April 11, 2011 at 11:25 am
The same as would happen if you change it anywhere. The log chain is broken and you will need to take another full backup before you can take further transaction...
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
April 11, 2011 at 10:15 am
Please post new questions in a new thread. Thank you.
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
April 11, 2011 at 9:59 am
Read the question as 'when is it first computed', since there's mention of changing the page verify. Basically, when is the checksum added to a page. It won't be checked...
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
April 11, 2011 at 9:09 am
Simon_L (4/11/2011)
but yes I did run a trace with those events selected and it causes a cachemiss so guessing the whitepaper is slighlty out 🙂
What it probably is, is a...
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
April 11, 2011 at 8:59 am
Viewing 15 posts - 26,776 through 26,790 (of 49,552 total)