No standard way of doing this. If you have Enterprise edition, I'd look at table partitioning and moving those older partitions to separate file groups.

You can make a view instead...

If you are in simple mode then your logs will be truncated at each checkpoint, and space used by committed transactions marked as free.

However, you cannot recover work beyond your...

Rinu's explanation is the best.

The advice is to run with full mode, unless you need to run a bulk operation, in which case, you can switch (online) to bulk...

I would guess that most people would be using only one of these, so I'm not sure you will get a comparison.

I don't know about the CBTs, but the books...

I know that GIS is heavily used, but I'm definitely not aware of how extensively it's implemented. The "finding directions" and mapping is stuff I've seen, but the shortest paths,...

SQL Server 2005 is a single instance. It is self contained. If you install multiple instances, they are all installed on Windows as separate pieces of software.

I'm not sure if...

It is interesting, but I don't see anywhere that they require for the certification. The prerequisites make some sense, but it needs to have some way to verify those items...

Please post newsletter issues in the Suggestions forum rather than here. It's mostly a client issue (mail client), not OS.

Nothing is free. That's a given, and I don't want to...

I spent some time quizzing the developer on this at TechEd. They didn't go for the best compression, but rather they wanted good compression at high performance.

There are all sorts...

Jim,

thanks and we've considered it, but part of what we want to do is build the site up. We could include the next post, but that's more bandwidth (we burn...

SQL Server should prompt for name and password with SQL Auth unless you have them saved. That's the way it goes. You can pass them in with the connection string...

You'll have to make an attempt and give us a little more direction.

CREATE PROCEDURE myProc

@param1 int = 1

as

is the starting point to create a procedure with a parameter....

I'm curious as to why you're interested and we certainly don't want people to have a goal of boosting their counts without adding to the site. We want good answers...

There was a guy in the UK (Andrew I think), that pinged me and actually moved over to Denver a few years back. I'm not sure I have his contact...

Well I'd have liked to see the Eagle a couple years ago, but > $100 a ticket at an outdoor football stadium wasn't what I had in mind.

We've seen three...