I think I'd agree with Lynn. most people I talk to at conferences don't see problems with getting articles that are controversial, or might not apply in many cases. They...

Thanks for the note. We try to fix these when we find them.

You can also use the "Report" button to let us know there's a formatting issue.

Me too! I think I'm one of those "less than great" ones.

I shall let that one slide because it's Tolerance Thursday :hehe:

The point is that the row number is relative to how the data is returned. There is no absolute row number.

I'm not saying you don't know anything, but rather that...

Yep, code tags changed. formatting corrected.

That's Ok, thanks for the note.

You can write a script that will do a waitfor, or even run a command in between updates

update a

set x = y

where month = 1

-- check errors

go

waitfor ()

go

update...

You haven't really given enough information. What's the server for? How is it used? Load?

Or are you saying how to get SQL Server onto a server? It's a simple install.

Try the default trace, but I'm not sure if will be there.

No, it shouldn't delete this stuff. The reason is that you might drop a database (there is no DELETE) because of an issue and then restore it. The information in...

If you want to learn about ROW_NUMBER(), read the documentation in BOL. No sens in having someone explain it to you if you haven't tried.

ROW_NUMBER works for a result set....

Keep it simple.

Gather the spreadsheets up, build a database with the names of products and subproducts (2 tables). Ask someone to count the number of products and subproduct.

Time them. My...

By default the express edition of SQL Server, you have a named instance. I believe it's SQLEXPRESS, which means the name is [machine name]\SQLEXPRESS and you will need to use...

I'm not big on Wikis either, and I'm concerned about ending up settling battles between people that argue back and forth on a topic.

Wiki sounds good until people start to...