Easy solution: script your SELECT to be into variables. Now your 100M rows never have to leave the server and you don't pay the cost (in many ways)...

SQLRNNR (5/28/2014)

---

TheSQLGuru (5/28/2014)

---

Another vote for Red-Gate SQL Compare. There are a number of other options from third...

Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out...

Because you have seen it so much you just don't see it any more?!? :hehe:

You also have the dreaded IS NULL OR construct (Q.ContactID = 15 OR @Orgid is NULL). Go to Gail's site, http://sqlinthewild.co.za/, and click the top Popular Link, Catch-All Queries,...

sql-lover (5/26/2014)

---

TheSQLGuru (5/24/2014)

---

Like I said - I have no knowledge of their official stance or policies regarding SP/CU releases. But they have moved to MUCH more rapid releases now...

msimone (5/27/2014)

---

Hello.

Plan's set options and the set values in the connections (event audit logon) are the same.

Instalation: SQL 2012 SP1 Standart Edition version 11.0.3128.0 with pool connection.

In the procs we...

It is bad advice to recommend picking table variables with few numbers of rows. I can show you a one-row, one-column table variable that gets a bad plan when...

Please start a new...

I don't consider them at all the same, or even that similar, but that could be just me. The variable one is subject to parameter sniffing issues and has...

Like I said - I have no knowledge of their official stance or policies regarding SP/CU releases. But they have moved to MUCH more rapid releases now with WASD...

1) Any add-ins?

2) How many different databases have you connected to and do any have large numbers of objects? I wonder about Intellisense taking lots of memory.

What is posted isn't a catch-all query, at least not a typical one. I see no...

One more problem is that the 2 PCs have each 2 network adapters with 2 different IPs: if one network adapter fails and that was the path of choice for...

It is either a bug or "by design" (that happens to be a bad design). Check Connect for similar issues. Post one if don't find it.