cfradenburg (6/28/2010)

---

Right. However, I just read through 7 pages of mostly repeated posts about what the correct answer is seeing if a mod had already addressed anything. At...

As per your suggestion, Lowell, I'm posting the final solution in a manner that can be cut and pasted into SSMS. While your solution solved the majority of the...

Thanks for your help, Lowell. I was concerned about putting in too much information that was not relevant to the issue, so I attempted to narrow it down a...

I have numerous interests including reading, hiking and camping, and working with wood. Unfortunately, as was previously mentioned, I rarely get the opportunity or time to enjoy them. ...

Unfortunately, that's all too true!:hehe:

Steve, I couldn't agree with you more! Like you, I hate reviews. Not necessarily because it will be bad (I'm typically over average) but I believe it to...

I've spent the past 25 years working in a number of environments both large...

GSquared (3/23/2010)

---

When my dad was in high school, they had a class that had the specific purpose of preparing the students for their standard tests (I think it was the...

blandry (3/23/2010)

---

If certifications were worth anything - #1, they would be free. #2, They would be based on ACTUAL experience NOT exams (like in most industries). And worst...

I have always struggled with the decision. I guess I still have a bad taste in my mouth from when an MSCE was way too easy to obtain and...

We have a similar situation using SS2005, however we use synonyms. When I worked on SS2000, I used linked databases to provide a layer of abstraction.

While intuitively I expected a result set of (0,1), I must echo what everyone else has said, I also achieved the results set of (1,1) when I tested it for...

I should not have made the assumption that the question was solely about the differences between char and varchar! I was assuming (see, that was my problem!) that the...

I agree that both the SQL OS and the T-SQL enhancements should be done. In fact, it seems logical to me that by paring down the OS side, much...

Michael Ross (8/26/2009)

---

As painful as it is, it's hard to dispute throwing hardware at the problem as a viable solution. I participated in discussions where a memory leak in...