It's Vegas, of course I'll have the Friday shirts there!

If you are there Tues, I'd agree Powershell would be a good one to attend. Lots of it being used in...

I believe the author was trying to point out confusion can result from negative logic tests. I have added a note to the explanation.

First, if this is going to support 100,000 people and it's worth a lot to your company, you ought to engage a consultant that works with systems like this. Someone...

Lynn, I get emails and PMs regularly asking for help. I just point them to the forum.

Don't worry, Barry, I'm frequently lost on this one as well.

I believe it can. There is a merge operation that can take results and put them together.

http://www.sql-server-performance.com/tips/composite_indexes_p1.aspx

You can use the maintenance plans and add a cleanup task to remove backups. Note that this uses a location to delete, so if people are making backups in random...

Most magazines that accept advertising don't do head to head comparisons because it's bad for business. We tried to do that years ago and it was a mess.

Consumer Reports, and...

Mel and his team have been busy on a couple things and we made some changes to other areas this week. I'll ask him to have another look at this...

Please start a new thread if you have a question. You might try running update statistics manually first to be sure it will run.

Matt Whitfield (9/15/2009)

---

I would put money on the fact that when you used SET ROWCOUNT one of the two following possibilities was true:

1) There was no where clause on the...

George, no problem and thanks for the clarification. They renamed the modes once, so you'll find some white papers and documentation referring to things differently.

You want synchronous mode, to be...

Don't stick multiple users in the same column. You're slowing down access.

Instead you'd typically have another table that links the user with the notification. As in

create table notification( noteID int...

Any more details? error? What is the alias? Where is it set?

The answer is yes, you can. Add a step to do this with a T-SQL command.

Note that if you find an answer, it's good etiquette to post it.