mmcginty (9/6/2011)

---

...

And for IT staff to become vocal about what developers are doing wrong, will lead everyone to wonder if IT has enough to do that they *are* responsible...

Roy, I'll take $20 from you at the door, or Mon night. The amount changes mostly for planning purposes so I need to account for a xx number of people...

I'm not sure I agree that DBAs couldn't be part of a union. I wouldn't be surprised if we find a developer's or IT union at some point, though not...

I think Denali will be good to go for the core engine when it's released. Some of the new stuff might need to shake out in a CU/SP, but most...

Having played rugby and football, I have to say that I cannot fathom how anyone finds more action in hockey or soccer than American football. The strategy, the speed of...

Look at PIVOT, or search for crosstab queries. That is what you are attempting here. If you know the number of rows it's easy. If not, it becomes a little...

Lucky Orange. Enjoy that one, not sure how many more they'll get.

Note if you set this behavior then you have to make sure all your code includes commits. Otherwise you will have severe locking/blocking issues.

Most SQL Server code does not expect...

No.

Short answer is that you don't want to shrink data files (MDF/NDF) unless some unusual event caused them to grow and the data space isn't needed.

You've listed two things that...

James and Paul have noted the correct response. You cannot estimate log file size, any rule of thumb is a wild guess based on experience, but could be completely inappropriate....

if (select myval from Mytable) is null

insert into ...

else

insert into

...

will work, but you have two tag_names in the different code. What do you mean...

As we were getting the kids ready this am, a family of deer (buck, doe, 2 kids) walked through the front yard. The girls were fawning over them at the...

mtillman-921105 (9/1/2011)

---

That's funny because horses and I do...

mattech06 (9/1/2011)

---

Thanks again, I've traced the duplication back to where more than one patient does have only one phone number ..makes sense when the extra patients could be the children.

Is...

We've negotiated to rent a room from PASS and will have a casino party/Exceptional DBA awards.

We are subsidizing some of it, and we'll sell $20 tickets in advance. Announcement will...