Viewing 15 posts - 33,616 through 33,630 (of 49,552 total)
ChrisM@home (3/8/2010)
You have an echo, Gail. I nearly wasted a mouthful of beer reading the OP's reply to your post.
Look at the times of the posts. I was editing mine...
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
March 8, 2010 at 1:05 pm
It very likely will.
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
March 8, 2010 at 12:59 pm
Could you post table definitions and some sample data (not much) I just want to see how it runs.
In the meantime...
Scalar User-defined functions, especially data-accessing user defined functions, are in...
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
March 8, 2010 at 12:26 pm
pshaship (3/8/2010)
I have modified the script to reorganize/rebuild indexes having page count>1000. But still the log backup size is 15 GB. If Ido selective reorganize or just run rebuild maintenance...
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
March 8, 2010 at 12:19 pm
There are 14 total replies to the other thread, most by people who know a lot (and I mean a lot) about T-SQL development. If there's no solution yet 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
March 8, 2010 at 12:16 pm
pshaship (3/8/2010)
Is log shipping breaks when we switch the recovery model to bulk-logged?
No, but your log backups will be no smaller. The transaction log won't grow as much but 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
March 8, 2010 at 11:14 am
I stared at that for a while before realising what he wanted.
Only time I ever change fonts is when I'm doing presentations. Other than that I only typically change...
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
March 8, 2010 at 11:02 am
And the vague question of the week award goes to
....
...
<drum roll>
...
....
http://www.sqlservercentral.com/Forums/Topic878772-1292-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
March 8, 2010 at 10:52 am
What comments, where, in what application?
If you're talking about Management Studio, go to the tools menu, select options. In the resulting dialog expand out environment and select "Fonts and Colours"...
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
March 8, 2010 at 10:50 am
Please don't start a new thread when there's still an active discussion in the previous one you started.
No replies to this thread please. Direct replies to the existing active 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
March 8, 2010 at 10:48 am
No. All data modification operations in SQL Server are logged. If they were not, then rollback would not be possible and a cancellation/failure of the operation would result in 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
March 8, 2010 at 10:46 am
A stats update invalidates all plans that use those statistics. An index rebuild does much the same. That means the plans will be recompiled on the next execution.
It does sound...
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
March 8, 2010 at 9:44 am
CirquedeSQLeil (3/8/2010)
Anybody here have an idea on this one?
Someone being stupid. I'd say set it back to 90 immediately.
It can be done, just ran this on my SQL 2008 instance
ALTER...
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
March 8, 2010 at 9:34 am
CirquedeSQLeil (3/8/2010)
And it is also a reason why I would love to get into a consulting gig.
There are downsides. I've just spent 3 weeks writing documentation and reports (til midnight...
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
March 8, 2010 at 9:31 am
I kinda enjoy fixing bad databases. It's very satisfying to take something that's working badly and get tremendous gains in performance from it or to re-engineer a process so 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
March 8, 2010 at 8:53 am
Viewing 15 posts - 33,616 through 33,630 (of 49,552 total)