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...

It's on!

Starting a new thread in this forum for Fantasy Football 2011.

If you could check the option, you're forcing a password change, however that's a security risk. Imagine the password is compromised. You check the box, the hacker logs in first,...

I have seen a concert at Red Rocks (John Mayer/Maroon 5) and also been there a few times with family to walk, but haven't fun the steps. Not sure my...