Hopefully this won't kick up too much mud.

I agree with some of what Steve Schmechel is advocating (if not necessarily his approach in advocating it). In working with our...

The thing to remember is that logically, they are different operations. They occur at different points in the query processing and will affect data in different ways. The JOIN criteria...

Nice article. You do a good job of outlining the issues that come up on the database side of things when doing Agile development.

The one thing I'd add is that...

shwetha004 (2/13/2008)

---

hi ppl!!

i tried using the select into statement.however, i cant see how i can actually merge two columns from two tables into one.

maybe i shud explain further.

Table1 has (userid,username,password,email,status)

Table2...

Yeah, 3 votes & one quasi-intelligent post aren't exactly encouraging. Still, you got a response. I posted on Services Center Operations Manager (SCOM) and got zip. Either no one is...

I've used both. In terms of messaging, there's no real difference between them. Blackberries are a bit more sophisticated in terms of actually chatting to other human beings, but when...

Jeff,

Doesn't the fact that floats are imprecise estimates represent a pretty major possible problem in using them in financial calculations? At least that's what I've always been told. I mean...

If you can't purchase tools, here's another option.

Definitely a backup and a restore is the much easier route. All the data, all the structure, all the statistics, just as they are in production. Done.

However, you can create...

There's this company, called Microsoft. Searching their web site can find all sorts of stuff.

I provided a link in the post above to MS's tool. Here it is exposed.

http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en

You really don't need to contact MS. The answer is 99. Matt Miller has not only documented it, he's tested it to confirm. 99 is as high as you can...

Check the logs. If you had six, you should have seven now. Cycling the error logs simply stops the logging in one log and starts it in the next, new...

Why on earth would you need more than 99 error logs? Actually, why would you need more than ten?

The thing I suggested would just show you if you had more...

Itzik Ben Gan from Solid Quality Mentors. He wrote the book, literally.