Jean, please don't reply to 3 year old threads.

1) Things you don't want to failover together should be in different AGs.

2) Note also that you need to be on a certain build of .NET to be able to...

+1000000 for Ola's stuff. NEVER EVER use maintenance plans, ESPECIALLY for index maintenance!!!!!

They rewrote the memory management system for SQL 2012 and there were definitely bugs. I would check the post SP1 CUs and/or SP2 for additional issues that may not...

There is no such rule. And even as a guideline, it sucks. Whoever said that should be banned from the SQL Server world for the next nine official matches and...

This is a 4 year old thread. Please start a new one with your specific questions. Thanks!

Lynn Pettis (6/27/2014)

---

Here is a quick rewrite of the query:

SELECT

[Customer No_],

SUM(CASE YEAR(cle.[Posting Date])

-- ...

cbrammer1219 (6/27/2014)

---

So let me ask what is the best approach for setting up a Data mart as it looks like I am going to be the one to do this,...

1) Don't name stored procedures "sp_..."

2) consider updating the data in a single pass (possibly during load since this is part of a staging process?!?) so you can greatly simply...

1) Try to find out the EXACT spot/query/process where the DTS package is hanging and see if you can fix the root cause. If you have source code maybe...

Sorry, but what you propose doing is, in my experience, DISASTROUSLY BAD!!!

1) No where did I see mention of things like "duplicate", "overlapping", etc. The missing indexes...

Once you hand-craft the data and get it the way you want you can:

a) just save off the insert scripts you created to build said data

or

b) use util_generate_inserts to...

Why do you need a wizard? Just review Books Online for the Syntax and create it yourself. It isn't that difficult.

Also, I am not even sure there IS a...

SQLSteve (6/25/2014)

---

I understand SQL locking ,the different types and when they are used.

But, If a user was to open a table in management studio for editing, does this place a...

Extended events or profiler is only way I know. You cannot use queries into the DMVs because I think they can have data removed due to memory management needs...