Good article, but I'd have included using derived tables to replace cursors and other use cases just as or more useful

You can integrate VSS, SQL Server, and Visual Studio with only one minor hitch. The named user that SQL Server is running as is what accesses VSS. You...

Sure you could create a work (reporting) database. This is a common solution that works well in many cases.

You still need to think about how you are...

VB Psuedo code

Add a reference to the "Windows Script Host Object Model"

Dim objShell As IWshRuntimeLibrary.IWshShell_Class

Dim hdlShell As IWshRuntimeLibrary.WshExec

Dim...

I've had a similar issue but it turned out that the problem was the application generating the load.

If the reporting tool is generating queries one at a time sequentially and...

ok, but the point is that data that is ending up in these transaction logs are calculations that are used in (essentially) a report. This "noise" increases the size...

quote:

---

Why don't you take the Transaction log back up periodically.

When ever you run the sp,Chk the trans log size before and after...

quote:

---

Business Rule driven month end reports are often such an example. I've seen some that take hours to run - not...

Two Words: Virtual Tables

It is popular to say "avoid temp tables and cursors if at all possible", but this is difficult to do when you need a result that requires...

Kay:

'truncate log on checkpoint'??? Jeez, I guess you don't ever care about having to restore the database with the differential since you don't have them after you truncate...

I would think about how and why you are using the permenant temp table (insert "Military Intelligence" or other Oxymoron joke here). I have found that this is most...

I do not have the reference book with me today, but I'd put money that SQL Server 7 will also reorder the arguments of a where clause during the compile...

I would suggest that you use newid() to get a uniqueidentifier type and use that instead of an identity column. It makes life so much easier - especially if...

Sorry jpipes, but I have to disagree with you about case and Underscores in names.

Capitals and underscores look consistant in multiple IDEs; mixed cases are harder to read.

I format...

Since everyone else is giving their $0.02...

I wrote a database standards guide and here is a part ot it dealing with columns names

I REALLY disagree with naming the PK column...