There's about 1 coffee shop per block in this city, plus a couple in the convention center.

coming to the SSC party tonight?

There's no easy calculation for an 'optimal' fill factor. Depends on the clustered index key, depends on how fast the clustered index fragments, how much you want to reduce fragmentation,...

You can try RESTORE VERIFYONLY. If the backup was done with the CheckSum option and all the database pages had checksums, then if this returns successful the backup will very...

You are correct. To do file/filegroup restores you have to have the log backups because, to bring the DB online, all the files/filegroups have to be rolled forward to the...

stephenmbell (11/1/2009)

---

So I figured I would write 1 stored procedure to take the place of all of these other stored procs and based on the parameters I send in, it...

Likewise.

15 min late leaving JHB because of bad weather (hail, rain, lightning and thunder), 30 min late into Paris (and turbulence entire flight).

2 hours late out...

Databases can never be downgraded. The internal database version and changes to design of the system tables prevent that

Do you just want to check if there is any row that satisfies that condition and do the stuff in the if once, or do you want to do the...

http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/

Not quite what I meant

http://scarydba.wordpress.com/2008/08/13/view-vs-table-valued-function-vs-multi-statement-table-valued-function/

http://sqlinthewild.co.za/index.php/2008/08/12/views-or-functions/

Though table value functions (well, multistatement ones) do have some performance issues.

Enterprise edition is not supported on non-server OS's.

Why Enterprise? Those licences aren't cheap and it can't be because of required enterprise-only features if you're upgrading from Express. Consider Standard edition...

Would someone be willing to keep an eye on this thread?

http://www.sqlservercentral.com/Forums/Topic811359-266-1.aspx

I'm not sure at this point how big a problem it is, but I'm leaving for the airport in 3...

Because 1 level is not nested and two is?

Do the procs always get...

Please run the following and post the full output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Take a look at this article. http://www.sqlservercentral.com/articles/65804/

Do you have a clean backup of this database? (a...