As you have it above, @CardName is not a parameter, it's a local variable.

How *exactly* are you calling that? Are you calling the entire piece as you've written there? Are you calling just the query? If so, have you defined the parameters?

And exactly how are you calling that piece of code?

What error?

Set max server memory, unless you like SQL being able to starve the OS and sitting in a near-constant grow memory, release memory cycle.

At 5 GB of memory total, you...

Nope.

That will break the log chain, prevent further log backups, essentially put you in simple recovery model (which means you cannot meet your SLAs), then shrink the log to a...

There's actually no difference in this case because of the inequality

http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

Ah, no, different terms.

Cleanly shut down means that SQL had time to commit or roll back all active transaction and time to write all dirty pages to disk before either...

It's a seek because you have a SARGable predicate (Col1 > 60 ) on a column that is the leading column of the index.

Scan is when you have nothing to...

Recovery model has no effect at all on recovery times.

Recovery time is a factor of how much needs to be undone or redone at startup. If it's taking forever, you...

Simple recovery model doesn't support that. Have another read through that article, specifically the sections...

Yes.

Yes I do, and no it...

ben.brugman (1/8/2013)

---

This made me wonder about Segments, do they come into the 'picture' at all with the discussed aspects. Does the optimizer 'know' about segments?

Or are segment only a way...

That's attaching without the log file....