*nearly sprays his tea all over the monitor upon opening the execution plan*

Yikes. Wow. :w00t:

Now, THAT'S a Table Spool. Just the estimate, I know, but a 101million...

BWAHAHAHAH. That drawing must be from the Palin camp. Note how Alaska looks to be about the same size as the...

YIKES! Sorry Tom. Note to self: When up for...

Grant Fritchey (1/10/2011)

---

This results in a merge join on just a few records. From what I can see, I'd try an index on the PastExperience table on the column IdAuthor...

Hey Cagan,

Welcome to SSC. It would be easier to help you if you check out the first link in my sig, which will walk you through proving some sample...

If you don't mind an article I wrote, perhaps this will help you:

Getting Started in SQL Server[/url].

That should at least give you an idea of the keywords and general basic...

GilaMonster (1/9/2011)

---

Very bad joke (with bad physics)...

Tom.Thomson (1/9/2011)

---

bitbucket-25253 (1/8/2011)

---

On a more joyous note, I ran across this link on MSDN's Channel 9

http://whathappenedinmybirthyear.com/

Go ahead, go to it, input your year of birth, now it is not video,...

You do this at the windows level, talk to your network administrators.

The write penalty for RAID 5 is painful, there is little argument there. However, unless you're dealing with incredibly high transactions, the write-cache built into most sans these days...

touchmeknot (1/4/2011)

---

Hello everyone,

I agree with Craig and disagree with Phil.

I succeeded in loading the file. Yes, it seems impossible but I succeeded in loading the file dynamically without using any...

Ghanta (1/7/2011)

---

Thanks Elliott and Craig for the response. Craig it is positional association only... each line will have different schema based on three characters at position 9, 10, 11 and...

shifty1981 (1/7/2011)

---

thanks for the comment. I would appreciate us discussing this however. Only because this server is rare in that the DB is on a SAN. most of our environments...

Madhu....

Answer to what? There is no question here.

Ghanta, one of the key items in dealing with a mainframe output file like this is if the records can be re-associated by anything except positionally. IE If...