New Nickname: Evil Steve. There's an E in my last name somewhere. 😉

[rant]

Anyway, having done a number of interviews lately (as a consultant, go figure...) I'm sick and bloody...

wta306 (6/7/2011)

---

I've really taken an interest in MS BI development over the past few years and have been considering making a move into consulting.

I have about 3 yrs...

wta306 (6/7/2011)

---

I should mention that I'm currently employed in a very secure job...but I'm BORED. The "right-way" is constantly tossed aside in favor of the "quick-way". I spend...

Hopefully that doesn't mean the same for your general employment? Either way, still less stressful.

davidsalazar01 (6/7/2011)

---

Craig or Phil,

Your suggestions are great. I wanted to know if either one had some time today or this morning and would be willing to connect to...

Do the count as a subquery and join to it to avoid the outer query caring about it.

Do what Jason recommended below, much cleaner.

m_cg (6/6/2011)

---

Craig, I was not attempting to quote anyone. i was just commenting on what my answer did not cover.

Someone else addressed the quote that it appears to remind you...

http://en.wikipedia.org/wiki/Douglas_Adams

Author to "The Hitchhiker's Guide to the Galaxy".

If 17k works and 20k doesn't, set the default max rows to 15000 and give it a try.

calvo (6/6/2011)

---

wow. I was about to question this when I looked it up, totally threw me for a loop.

How...

You can be pro-war and still want to see the people you know safe. Double bonus.

ROFL! I don't think I've ever heard my name used as a verb before...

... well, not for anything good. 😉

davidsalazar01 (6/6/2011)

---

So we would do something like this with the dates as shown below:

Day 1 (Monday):

Select getdate() and the last 2 months

Day 2 (Tuesday):

Select getdate() and the last 2 months

And...

Have you thought about storing the configuration in SQL Server instead of in an XML File? Then you can just update the configuration values via T-SQL procedure before kicking...

Sachin Nandanwar (6/6/2011)

---

Hi,

I am reading one book on SQL Server internals.When explaining the checkpoint process it states that

"....If the LSN of the dirty page is greater than the LSN...