Jeff Moden (11/10/2010)

---

I guess the next question to ask is, has anyone written a "spackle" article (think "Requested Article") on how to return the top 2 items from each group,...

Adam Gardner (11/10/2010)

---

Steve - Ever try to ride your bike to work via Bus/Train in Denver? I have many times. It's a nightmare. Arrive at work sweaty - no place...

Sorry, in 2008 mode. No default trace in SQL 2000.

Look for user objects or data in model. There shouldn't be anything.

never seen this. Creating logins should just touch some system tables in master (principals tables), nothing else. If you were creating lots, possibly you could block some connections checking against...

That's a good question. It's not that you update less pages, but that the pages are smaller when written to disk. I think that the log is still the same...

Partitioning is important, but also if these are LOB type columns in here, think about vertically partitioning because of some of the issues around index rebuilds with LOB columns (no...

You can also start in single user mode, connect with the DAC with a windows admin if you are stuck.

In Denver, and in Europe, lots of the light rails/trains allow bikes on them. We even have some racks on buses/trains here.

You will have to look up the format for a calendar entry. This isn't a SQL issue, but rather a mail construction issue. Once you have that, you can construct...

This would not be easy, and I'm not sure you can do it in T-SQL. You can use OPENQUERY or OPENROWSET and grab data from Excel, but I'm not sure...

If you're not sure, check the default trace for activity.

Hey, snow is good for us out here. At least for us telecommuters.

I agree light rail has issues. The biggest one being those fixed routes. As long as you have dense destinations, it works. In Denver, they have vastly exceed ridership, and...

Please show an example. It is not clear what you mean.

I think the biggest thing is that it requires CPU, so if you are CPU bound, this might not be good for you. BOL has other issues to consider.