If you don't mind a little self promotion, I've written an article for people in your position here[/url].

It's an overview of the industry. Now, to answer your question about...

It's SARGable, the functions...

Brandie Tarvin (2/2/2011)

---

Craig Farrell (2/1/2011)

---

The +2 part at the...

sturner (2/3/2011)

---

This sounds like a homework problem.

I am not trying to be mean, really, but you are paid (I assume) to solve these kinds of basic query problems. Try to...

Jeff Moden (2/3/2011)

---

Thanks for the feedback, Craig. Yep... not that it matters but I agree with that justification. Please understand that, considering the source, I just had to...

tfifield (2/2/2011)

---

At some point as the number of rows increase within the partition the CROSS APPLY will start to pull away from either MAX or ROW_NUMBER() since it will seek...

sourav_1002001 (2/2/2011)

---

thanks for the post. Is that got currupt due to bad sector of HDD, because i have recovered this data file from a damaged HDD. So is there any...

Brandie Tarvin (2/2/2011)

---

Next question:

How did you half-management / half-DBA types deal with the overload of DBA tasks?

I.E., say there's too much workload for the DBA team to handle in...

TheSQLGuru (2/2/2011)

---

MAX DATE method has one downside though - you can get duplicate output if more than one record has the same MAX DATE. This should not happen with...

Auto, this usually isn't something you want to control at the trigger level unless you absolutely have to deal with dynamic SQL coming off a front end application. Are...

Use BOL and look up the available formats to the CONVERT function.

loki1049 (2/1/2011)

---

I have had constant issues with my boss on proper database design. He is constantly saying that everything belongs in one table. That way apparently he can just look...

Brandie Tarvin (2/1/2011)

---

I'm curious. Has anyone made the move from DBA / Developer up to management (team size doesn't matter)?

If so, what were your experiences and thoughts on the experience?...

The reason BI can be a better path to management is twofold. One, you learn more about the goals of the company by understanding what they research and their...

DTS and SSIS are the biggest problems that stand out that you'll need multiple environments to deal with. There's emulators you can run to get into DTS from 2k5,...