tafountain (4/4/2013)

---

I'd also suggest following best practice and using different domain accounts for each sql server instance at a minimum. I use different accounts for each service (sql server,...

So to clarify, you guys use a separate Service Account for each Service on each Server? So as an example if you have ten SQL Instances each with four Services...

That is correct. We have one service account for each service type (SSIS, SQL etc) but the same account is used for multiple production servers.

No excuse but legacy and small...

I don't want to take a prod DB offline unless I really have to so option two it is.

thank you for the reply.

thanks, and as far as you know the backup compression on R2 STD and 2012 STD compresses log files created from a standard log backup regime or via a log...

Thanks for the replies.

So if a DB server totally dies and it is not recommended that the Master is restored on another machine then what would be the normal recovery...

I have read the article and played with your test scripts and it makes sense. We do not do diffs so it will not affect us now but good to...

When I check my backups I normally choose one from 2 or 3 days ago and apply every log since then.

Quite a few logs to restore but it doubles as...

Thanks for the reply.

For some reason SP_HELPINDEX2 was showing me the index had included fields when in fact the index did not, hence the reason I could not see the...

thanks for the info. I grew a database on the prod server by 4096MB and it took a couple of seconds and looking at the "Performance Volume Maintenance Task" it...

thank you I will have a look at the article.

Would READ_COMMITTED_SNAPSHOT be row versioning in SQL?

I see their are a few articles about the possible overheads associated with this but...

thanks, I see the conversion but what I do not get at this point is if a conversion is made then why wouldn't a SEEK happen like if there was...

Sorry, just found this info that may help.

http://connect.microsoft.com/SQLServer/feedback/details/430745/sql-server-2008-unexpected-behavior-when-inserting-datetime-value-in-smalldatetime-column-on-a-linked-server

Posted by Microsoft on 1/07/2009 at 5:48 a.m.

Dear Customer,

Thanks again for your feedback regarding the "smalldatetime" column on a linked...

Thanks for the reply.

The query was on three tables in a DW and in only the one database.

It was running for over 5 hours before the crash so I can...

I did try that and it still failed with the same error.

So individually running updates stats on explicitly declared indexes worked fine but update stats on the entire table or...