Totally different topic: how big was the biggest SQL statement you had to deal with?

This is a statement generated by our BI front-end.

Surprisingly enough, after 4 minutes of parsing, it...

CirquedeSQLeil (9/28/2010)

---

Gianluca Sartori (9/28/2010)

---

Well, I wouldn't say "much experience", but I've had to deal with it in the past.

Is there anything particular you're...

Well, I wouldn't say "much experience", but I've had to deal with it in the past.

Is there anything particular you're looking for? Probably...

I'll suggest that when performance degrades.

I'm sure at least one of my co-workers would say "Why not?" :w00t:

Paul White NZ (9/20/2010)

---

Steve Jones - Editor (9/20/2010)

---

BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote connect items.

http://www.sqlmag.com/blogs/puzzled-by-t-sql/tabid/1023/entryid/13085/Window-Functions-OVER-Clause-Help-Make-a-Difference.aspx

I...

Congrats, Gail!

If you really want to answer that corruption question you could take a snapshot: 🙂

hallidayd (9/17/2010)

---

Lowell (9/17/2010)

---

So if there are no joins to other tables, then the clustered index provides SQL with the fastest way to get the data...and thus would determine be...

They only documented way to get rows in a particular order is using ORDER BY.

Any other method is prone to failure.

Adding an IDENTITY CLUSTERED PK won't change this behaviour and...

I had to stop it after 2 minutes. :sick:

100% agreed.

It's also true that if this is one of the first tasks you have been assigned on your new job, you'd better first of all do as required, then...

This is a great script I got from Jeff Moden that should do the trick for you.

Hope this helps

Gianluca

--===== "Space Used on Steroids"

-- If "UnusedKB" is negative, it's likely you...

It depends. You're not describing your problem with enough detail to get a sensible answer.

Can you give us a more detailed description of your requirement?

SMO should do the trick.

Every database object has a SMO counterpart that can create a script.

Tables apart, database objects that have a text definition (procedures, views, triggers etc.) can be...

......

Alvin Ramard (9/14/2010)

---

Nope....