Sorry, but at first blush I think parameter sniffing (without some other query addition) could totally screw you here. Maybe an OPTION (RECOMPILE) could help, depending on what version...

>> The developers, now they really should have a complete understanding of what they just did and they are the people who should be responsible for production of the ERDs

It...

tajrin (10/25/2013)

---

tnx for the reply, some more questions please:

1...Is it possible to get 3 as a final result....ie the total number of different combinations?

2...why did you comment out the pipe...

Yeah - AG is Availability Group. Stuff with the Always On sphere.

That you asked that question has me a bit concerned. Implementing ANY form of HA/DR...

first thing is to get sp_whoisactive (v11.11 I think is latest version. see sqlblog.com for it and also a 30 day blog post series by Adam Machanic on it's awesomeness).

look...

Griffster (10/22/2013)

---

Yes, we will be buying the Enterprise Edition. Looks like it would be worthwhile then so long as it's not too long a wait. If the release will be...

Griffster (10/22/2013)

---

We're at an embryonic stage with a big BI project really, and are planning on re-working all our internally developed web applications utilising SharePoint (especially SharePoint workflow designer for...

please start a new thread instead of commenting on a 3 year old one

Minaz (10/13/2013)

---

Thanks Kevin , If I consider only HA solution , is fasttrack databases support all the features of MS SQL Server 2012 ( Always ON) ?

If yes, do the...

Grant Fritchey (10/13/2013)

---

Another vote for Embarcadero ER Studio. It's a very solid tool.

You might also want to look at SQL Dependency Tracker from Red Gate. It's not a modeling tool,...

Snargables (10/11/2013)

---

i have a table that has 600 mill recs. i have an update to it that modifies 79 k records a day. Up to last saturday at 8am this...

ekant_alone (10/10/2013)

---

Hello,

I am looking for a cheap and highly efficient data modeling tool for my SQL server 2008 r2 and 2012 environment. my employer's infr contains postgres, oracle and SQL...

Minaz (10/11/2013)

---

Hi Experts,

In my environment we are hosting a new projects which is DW and also a very bulky DBs in TBs.

> what type of HADR solution is available for...

Look up DATEADD in Books Online. You can also CONVERT the date to a string and concatenate a string representation of the time and then CAST all that back...

Best of luck in your endeavor.