Viewing 15 posts - 1,996 through 2,010 (of 5,843 total)
Eirikur Eiriksson (5/28/2014)
Luis Cazares (5/28/2014)
Maybe someone else...
May 28, 2014 at 10:39 pm
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)...
May 28, 2014 at 6:34 pm
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third...
May 28, 2014 at 12:41 pm
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out...
May 28, 2014 at 8:56 am
GilaMonster (5/27/2014)
TheSQLGuru (5/27/2014)
You also have the dreaded IS NULL OR constructHow did I miss that....
Because you have seen it so much you just don't see it any more?!? :hehe:
May 27, 2014 at 7:47 pm
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,...
May 27, 2014 at 9:53 am
sql-lover (5/26/2014)
TheSQLGuru (5/24/2014)
May 27, 2014 at 9:50 am
msimone (5/27/2014)
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...
May 27, 2014 at 9:36 am
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...
May 26, 2014 at 8:26 pm
ramana3327 (5/26/2014)
Hi,You mentioned stats here. How do we know how often we have to update stats. How to find the optimizer is using right stats or not?
Please start a new...
May 26, 2014 at 3:48 pm
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...
May 24, 2014 at 7:23 pm
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...
May 24, 2014 at 7:17 pm
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.
May 24, 2014 at 7:14 pm
Lowell (5/23/2014)
what you posted is a catch all query.here's an excellent place to start:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
What is posted isn't a catch-all query, at least not a typical one. I see no...
May 23, 2014 at 10:26 am
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...
May 23, 2014 at 9:41 am
Viewing 15 posts - 1,996 through 2,010 (of 5,843 total)