Honestly, I think the #1 takeaway from this thread is:

Name functions with accuracy and specificity!

Microsoft's "IsNumeric" is neither specific, nor accurate (it does _not_ test for strings that must match...

Kwisatz78 (11/24/2010)

---

Ok I have got myself in a tiz about device CALs now!!

How does a web front end not qualify for a device CAL when all external users will be...

Simple recovery simply means the tempdb...

+1; most...

A) Yes, get a professional in. You'll learn a lot, and have a better setup.

B) For a simplified system, build yourself a table with rather less factors: Change the...

I agreed with you.......

Shared disk may be cheaper, and is absolutely simpler on the SAN side.

Shared disk with non-SQL apps, however, means that you cannot guarantee SLA's on query performance; if some other...

When it doubt about a system level change, make a drive image first. I've done this many times, and every once in awhile it's a major lifesaver (we applied...

Time it (and use SQL Server Profiler SQL:BatchCompleted statistics on Reads, Writes, CPU, Duration if you can) several ways:

1) The way it is now

2) Dropping/recreating indexes (watch out for ones...

I regularly restore 100-1000GB SQL Server 2000 database backups to SQL Server 2008 R2 servers without issues; whether the stored procedures all still work, I don't know, however the data...

I would note that even for developers with a Computer Science degree, while relational theory may be covered (often optionally), actually working with real data is usually not. In...

Speeding transfer across network by transferring the compressed version:

Use any compression tool in its fastest mode that:

A) writes the initial compressed file directly to the target directory

and

...

And a Bulk Export to match Bulk Import from straight SQL, using a format file.

More flexible format files would be nice, too.

Temporal support for periods and for explicit intervals, with sufficient index capability so as to be able to include periods (start date, end date) in a table, put an index...

For Gila's and everyone else's bag of tricks:

To add space to a drive that's out, there are a variety of options.

Temporary:

A) ENTIRELY SAFE: Clear out IE's and any other browser...