Look at the times of the posts. I was editing mine...

It very likely will.

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...

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...

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...

No, but your log backups will be no smaller. The transaction log won't grow as much but the...

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...

And the vague question of the week award goes to

....

...

<drum roll>

...

....

http://www.sqlservercentral.com/Forums/Topic878772-1292-1.aspx

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"...

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...

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...

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...

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...

There are downsides. I've just spent 3 weeks writing documentation and reports (til midnight...

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...