Full backup does not truncate the tran log. Never has. Only a transaction log backup, an explicit truncate or a switch to simple recovery will truncate the tran log.

Don't bother with lock pages on a desktop. Since it prevents SQL from been swapped out, it could give you perf problems with other apps.

Lock pages is important on servers...

That's going to have to be a procedure, since you have dynamic SQL.

Remove the select ISDATE ('5/1/2008') from before the Create Proc

You're missing begins for two of those ifs

If ISDATE(@DateMin) = 0

BEGIN

Raiserror('Please enter valid date format...

Monitor that regularly and when the available space gets low, manually grow the file.

That's going to take a while.

What's the availability requirements? Can you get a weekend where the DB isn't in use? It may not take that long, but just for...

He told us (panel interview, myself, two other DBAs and a...

nate (12/2/2008)

---

Then, I moved on to a different table that had no clustered indexes. Once I removed 5 unused columns and rebuilt the non-clustered index, the 'Data Space' value...

Script all the objects (perhaps excluding the foreign keys) to files, bcp all of the data to file. Create a new database, run all of the script files, bcp all...

It's got nothing to do with space available. Grows are very intensive operations and will cause the entire system to slow down due to the IO impact.

As for monitoring, try...

There's no built-in function that does that. However...

Itzik, in his PASS precon, showed a cool trick for faking one using some highschool maths.

LOG_x(a * b * c) = LOG_x(a) +...

Paul Randal (12/2/2008)

---

Without backups, this is going to be hard to get rid of - repair cannot fix this so your only options without backups are to migrate all schema...

Jeff Moden (12/2/2008)

---

I had several folks say they were Ninja's in SQL Server and one even claimed to be a "9 out of 10" right on his resume......

Study for the SQL certifications.

Note, I did not say write and pass them. I said...

No way to ensure that with a float.

Change the data type to one that is precise and accurate.