calvo (7/11/2011)

---

Ninja's_RGR'us (5/3/2011)

---

Thanks for the not posting... allowed me to steal the #5 spot in the last 30 days :-D.

Now I know this is going to cost me... but this...

Looks like you're good to go. Let us know if you need more help with the real thing!

You should turn this into an article.

For once you'd get your 25$ worth of work 😀

5M is a decent...

You should be fine. But it type of query can be better served by dynamic sql later down the road as you add lots of optional filters and /...

Just a PS. I work in the Montreal region if you need someone on site and I speak french too!

Hey grant I've surfed to http://www.scarydba.com/2008/07/02/code-from-dissecting-sql-server-execution-plans/ to download the code of the book and I just can't seem to find the download button.

Care to help a blind man?

In other words, please post the real query so we can help out!

BinaryDigit (7/11/2011)

---

I understand that no filter will be applied what I'm trying to find out is if the first part of and is true would the second part still run?

I...

Nope, here's the plan. There's absolutely no filter being applied.

SELECT * FROM msdb.dbo.sysjobhistory WHERE 1=1 OR step_name = 'Bob'

|--Clustered Index Scan(OBJECT:([msdb].[dbo].[sysjobhistory].[clust]))

Koen Verbeeck (7/11/2011)

---

LutzM (7/9/2011)

---

If I would have to stop on a highway (or Autobahn as we call it over here) other than because of a traffic jam, I'd immediately run...

Can't be both. This is where intimate knowledge of how the data is used is critical.

Do you have access to the reportserver database and are you logging the reports'...

I was merely confirming the information.

TheSQLGuru (7/8/2011)

---

How much your tlog will grow cannot be known ahead of time unless you are doing a rebuild, which builds a completely new index in total. If doing...

It was...