Viewing 15 posts - 26,581 through 26,595 (of 49,552 total)
sturner (4/21/2011)
You may not close any topics, especially of yourself. It will be used for evidence.
??
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 21, 2011 at 7:39 am
Craig Farrell (4/21/2011)
GilaMonster (4/20/2011)
It's not. It's 1.6 seconds slower.
Check your PM, I don't want to start a tech conversation in the thread. However yes, I have reasonable acquaintance 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
April 21, 2011 at 5:59 am
What's the exact command you are using for the log backups?
I'm going to guess that you are doing this:
BACKUP LOG ... WITH NORECOVERY
That will back the log up, then take...
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 21, 2011 at 5:50 am
No, there isn't.
Who is qualified to say which answer in a thread is the best?
Not the person who asked, if he knew what the best answer was he...
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 21, 2011 at 2:42 am
There's no close option. Why do you need one? Just post and say the problem is fixed so that people reading it know that you're sorted out.
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 21, 2011 at 2:07 am
Craig Farrell (4/20/2011)
So, now I'm back to the drawing boards trying to figure out why reading 1.9 million times more is faster then the other query. 🙂
It's not. It's...
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 20, 2011 at 11:32 pm
Ok, one question first.
What are you going to do with 4 million rows?
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 20, 2011 at 2:02 pm
dajonx (4/20/2011)
Can someone please assist me if there is a "less" painful way to move the table onto the new FileGroup?
You could create a new table, insert the rows over...
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 20, 2011 at 12:29 pm
LutzM (4/20/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 20, 2011 at 12:27 pm
ALZDBA (4/20/2011)
"Blunt" has been redefined :hehe:
Sorry, will see if I can tone it down when I get home.
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 20, 2011 at 10:03 am
caffeine (4/20/2011)
Babylon 5 was the only TV show that made me weep. The episode when Sheridan died was ... heart breaking... 🙂
Z'ha'dum or Sleeping in Light?
Z'ha'dum is one...
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 20, 2011 at 10:00 am
Ok, I'm going to be blunt (and probably unpopular)
I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance promptly degraded dramatically.
The...
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 20, 2011 at 7:33 am
These should give you at least an overview
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 20, 2011 at 5:08 am
Digs (4/20/2011)
I also understand that there is NOT a lot between the 2005 and 2008 R2??
There's not a lot between 2008 and 2008 R2 (other than BI), but there are...
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 20, 2011 at 3:58 am
It needs a trace or a trigger, or if you're in full recovery model and have log backups, you could buy Apex SQL log (~$1000)
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 20, 2011 at 2:19 am
Viewing 15 posts - 26,581 through 26,595 (of 49,552 total)