Stefan Krzywicki (11/22/2011)

---

Anyone have a good way to view and compare execution plans? The display in SSMS is small and I can't view them side by side. Is there a...

you probvably need to add more columns to the sample data;

then you could use something like rownumber;

here's a rough guess to get us started:

SELECT * FROM (

SELECT

row_number() over(PARTITION BY...

a CTE of the posted data:

WITH MySampleData(acd,R,drv,P,Led,LoadTime,RankingAndGrouping)

AS

(

SELECT 199,183,9,0,1,00:00:53.1540000,1 UNION ALL

SELECT 199,225,9,0,2,00:00:47.9960000,2 UNION ALL

SELECT 199,267,9,0,3,00:00:47.8770000,3 UNION ALL

SELECT 199,309,9,1,4,00:00:47.9990000,0 UNION ALL

SELECT 199,350,9,0,5,00:00:48.0960000,1 UNION ALL

SELECT 199,394,9,0,6,00:00:48.5890000,2 UNION ALL

SELECT 199,437,9,0,7,00:00:48.2370000,3 UNION ALL

SELECT 199,479,9,0,8,00:00:48.6120000,4 UNION...

best guess:

SELECT .id,

.firstname,

[EDUCATION].school

FROM

LEFT OUTER JOIN [EDUCATION]

...

how much...

removing insignificant digits in an export is normal (3.00 is exactly the same as 3), since the assumption is, if you import "3" into a money datatype, it will be...

of course; the math is the same...integer math or modulus;

something like

CINT(Field!Value /...

try connecting via the Dedicated Admin Connection:

http://msdn.microsoft.com/en-us/library/ms189595.aspx

I believe all objects are decrypted for you when connecting via the DAC

i'm sure there are other ways, but here's one way:

--3 hrs 55 min 12 secs

/*

----------- ----------- ----------- -------

3 ...

Amy keep us posted on this! getting...

for a quickie compare Amy, peek at the estimated planfor this, and also go ahead and run it;

what kind of performance differnece do you get?

i think it will be several...

Amy.G (11/21/2011)

---

OK, yes, you have a point that I should be paying much more attention to the indexes on a table and utilizing them. With that in mind, I want...

Amy.G (11/21/2011)

---

Lowell, If you want the actual execution plan, you'll have to wait quite a while. There are two indexes on the insert into table (PK clustereed and non-unique, non-clustered)...

ugg; to me, that sounds like "i don't want to use multiplication....

amy lets see the actual execution plan; that may tell us if an index would help, or statistics, or much more.

i'm not sure if that is real code or pseudocode;...