Viewing 15 posts - 41,041 through 41,055 (of 49,552 total)
Before you try shrinking, you need to work out why it grew in the first place. Otherwise it may well grow again and cause bigger problems.
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
February 14, 2009 at 5:12 am
Mirroring is autofailover only. When the server that was the principal comes back online, it will become the mirror. If you want it to become the principal again, you'll have...
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
February 14, 2009 at 5:01 am
Simple recovery has no effect on what's written to a DB's log. Just how long it's retained after it's written.
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
February 14, 2009 at 4:37 am
Please don't cross post.
No replies to this thread please. Replies to:http://www.sqlservercentral.com/Forums/Topic657055-360-1.aspx
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
February 14, 2009 at 4:36 am
Please post the exact error that you're getting and the query that generates it.
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
February 14, 2009 at 4:35 am
DBADave (2/13/2009)
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
February 14, 2009 at 4:07 am
jeff_wiegand (2/13/2009)
While I understand there are design issues often at the root of SQL apps when they don't scale, Read Committed Snapshot Isolation seems like a slam dunk.
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
February 14, 2009 at 4:00 am
Ninja's_RGR'us (2/13/2009)
exec sp_update_resumeexec sp_distribute_resume
:hehe:
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
February 14, 2009 at 3:50 am
Ken, one other thing that came to mind yesterday.
When a query can get either a good plan or a bad depending where and when it's called, it can be due...
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
February 14, 2009 at 3:49 am
Lots of parallelism skew. Lower MaxDop
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
February 13, 2009 at 8:51 am
Brandie Tarvin (2/13/2009)
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
February 13, 2009 at 8:49 am
Bob Hovious (2/13/2009)
The gurus here might have better insight into what the next frontier should be than his professors.
Agreed. I chatted with lots of people before picking my master's thesis,...
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
February 13, 2009 at 8:47 am
Grant Fritchey (2/13/2009)
There's a blog post. Do you get it or do I?
Why not both? (Like we did with the table-valued functions)?
I'll write one over the weekend. Title's written,...
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
February 13, 2009 at 8:41 am
llokshin (2/13/2009)
Thank you for your reply, actually I am looking for a tool that will use both, logs and trace.
Why? Logs, while they can be used for some autiting, 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
February 13, 2009 at 8:40 am
Sorry, shouldn't have used the term 'estimated'. I seem to have confused everyone. I'll explain better.
The terms estimated and actual for plans are actually a bit of a misnomer. 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
February 13, 2009 at 8:21 am
Viewing 15 posts - 41,041 through 41,055 (of 49,552 total)