I thought I would mention again never use reorganize unless it's a tiny index and you don't have other things that need to be done.  I was dumb enough to...

• This reply was modified 1 month, 2 weeks ago by  Vernon Jimmerson-306463.

Vern! You're obviously a moron!  In fact, at this point I can confirm it!  Hard to argue with yourself! Guess I get the last word as you'll never respond!

I'm still wondering what bad advice I gave from my 26 years of hands-on DBA and development experience. I know I didn't talk about page splits, or leaf level, tries...

First thank you for the conversation.  I haven't even been a DBA FOR 5+ years at this point and I ways try to review what I might discount.  Sometimes I...

I thought this must be from years ago but only a few months. Maybe just the reply.  I've had the same discussions, or more like yelling matches with DBA groups...

Never do reorganize.  On large tables it will take forever and on small tables why reorganize when you can just rebuild.  Treat all your server maintenance like a man made...

Log shipping is automated copy of transaction logs being applied to a database on the same or another server....

It doesn't sound like anyone has done this otherwise there would be references to the following

1. Run sysprep before cloning. I haven't done this but have read this is...

You might want to use your own Join function that will work with muti-value and single value parameters.

Public Shared Function MyJoin(ByVal parameter as Parameter, ByVal Delimiter as String) as...

You might guess I've been working on an SSIS package recently. I might have mentioned I am not a fan of them.

(using a friendly positive tone with a little smart *** worked in!)

Or if they've had to deal with it for 15 years! There a thing called T-SQL...

SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is if you...

To clear things up a bit more! The data files and log files are not the same as the database size.

http://www.sql-server-helper.com/sql-server-2005/maximum-capacity-specifications.aspx

...

I have the same issue with using master.dbo.xp_fileexist on a remote server.

Another method would be great as long as it doesn't indicate a file exists when the target is...

Did you ever resolve this issue with 2005? I've got the same thing going on.

If I drop and recreated the subscription it seems to work for a while but...