I might be misreading something, but why are you using DTS 2000 on an SQL 2005 database?

The main usual consequence of turning off auto-shrink is that your whole database speeds up.

Secondarily to that, your database might grow a little bit now and again.

The way to handle...

Totally understand what you're running into on it. To optimize it any further, I'd need to actually see it in operation, look at the tables it's running on, check...

Mark Shvarts (6/5/2008)

---

I tried to reproduce your code, but it complains about (@stmt), apparently you did not test this code prior to posting.

But my point anyway is that Catch...

Another thing I thought of on this subject is that just storing the numbers makes certain types of pattern-matching much easier.

What if, for example, you want to look up all...

As mentioned, there is no guarantee that two instances of SQL Server, even running on the exact same server, will return the same execution plan for the same query. ...

Michael Earl (6/9/2008)

---

Nope, there is no GUI for Service Broker (unless you count the template scripts). That was my point.

I tried to type as sarcastically as possible, but apparently...

Bit fields take 1 byte for up to 8 fields. So, if you have 1 bit field in a table, it takes 1 byte. If you have 8,...

Mike, I would actually classify what you're describing as a form of active auditing. You created a log other than the SQL server transaction log.

Yeah, in any sort of...

There's a default template. Start with that.

There's a setting in...

The place where I've found functions useful is where you have to join to them. It's not so easy joining to a proc.

Also, multi-select functions use a table variable,...

It looks to me like you could Group By student number and test date, and just use max() for getting the grades. Aggregates eliminate nulls.

Maybe it's just a slow connection somewhere along the way.

My boss had a 1-Gig card in his computer, and a 1-Gig connection at the switches, but was getting horrible download...

This appears to be a duplicate question. I replied to the other copy (same forum).