Also - you might care to look at whether you need to force certain heavily used SP's to recompile - the new statistics might dictate another plan is more appropriate....

Not sure this has been brought up yet - but you need to enable Trace Flag 1807 before tying in to network DB files (usually a very bad idea anyway,...

I'm not following you - he mentioned tagging those that MATCH, not the other way around. That is something that would lend itself to partitioning

If you only ever look...

This might be somewhat cheating - but is your own list (not the DNC - your client list) regional in nature? If it were - that'd be one way...

Just for grins - what happens when you DO set up an odbc DSN to the server using those settings?

Through the control panel, admin tasks, ODBC data sources? does...

What I said earlier does apply to your scenario. SQL doesn't have parameterized views. What does allow for "parameterizing" would be a SQL function or a stored procedure...

I can't say I know of any industry standard on that. I can just tell you what seems to work for me.

I'm not a big fan of jobs...

there's two sides to the IIS: the "user to IIS" side and the "IIS to SQL" side. The article is talking about mapping the IIS App pool service...

That's a wide open question - what are you trying to schedule? ARe you trying to create appointments? Jobs?

The question is hard to answer right now. Post...

meaning- if your SQL Server happen to be paired up with a busy Exchange server for sending, and Exchange goes off and starts "plowing" because of large emails/too many emails,...

Also - let's not confuse multiple tempDB databases with adding multiple files to tempDB. Each instance of SQL Server gets one tempDB only, but you can add multiple filegroups...

SQLSERVER while installed into a cluster cannot "see" local drives. That's because when there's a failure forcing a failover to another node, that drive wouldn't be visible. And...

Sounds to me that you're having issues with ODBC/ADO access more than anything. depending on what user you're using to run this as - you might not have access...

I haven't had the pleasure of dealing with SOX yet, but it sounds like it's afflicted with the same issues as HIPAA is - its lack of specificity leaves pretty...

In the case you're talking about - you should also consider continuing to use an OPENQUERY syntax, and/or make sure that the collation compatible setting is ON in your linked...