If the database isn't going to remain tiny throughout it's lifespan, I generally start it at 1 Gig and set the growth to 1 Gig. Sure, that sometimes means...

Silverfox, if you notice my second-to-last paragraph, I pretty much cover what most companies are looking for, and that's what you're describing.

My contention is that generalization produces less efficiency than...

Standard Edition does many things that Workgroup doesn't. Microsoft has a side-by-side feature comparison here for 2008: http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

and here for 2005: http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx

Delete doesn't reset identity values. If you need to do that, you need to use temp tables and use truncate instead of delete.

I prefer server-side traces over Profiler, but it's the same concept.

That's the kind of thing I meant in my examples when I mentioned using the logs as an audit method. If you check my articles on audit trails and...

Ian Scarlett (10/20/2009)

---

GSquared (10/20/2009)

---

If all they're going to do is administer, not performance tune or write code, I'd focus on questions about backup chains and types, I/O performance, that kind...

I prefer using the Output clause these days. SO much more useful, and I don't have to worry about using one method for single-row CRUD and another for multi-row....

If all they're going to do is administer, not performance tune or write code, I'd focus on questions about backup chains and types, I/O performance, that kind of thing. ...

Declare an @ID variable and use "select @ID = scope_identity()", then use as normal.

You're welcome.

The msdb database has a history of backups and restores. The system tables in there are pretty easy to work with.

If I'm reading your request correctly, you might want to use something like this:

declare @Variable sql_variant;

select @Variable =

case

when datepart(weekday, getdate()) = 6 then FridayValue

else...

steveb. (10/20/2009)

---

Seriously? I find this a bit worrying, ...

Change from using an In statement to a Left Join.

SELECT

origin_latitude,

origin_longitude,

COUNT(*) AS Structures

FROM

towergrid_reference_natowers AS towers

LEFT...