You need 2 exams. The Technical specialist for SQL 2005 (70-431) and then the MCDBA upgrade exam 70-447. Those 2 will get you your ITP (Database Admin)

There's no upgrade path...

Is the DB in full or bulk-logged recovery mode?

If so, do you have log backups runnng? If you're in full recovery mode and have no log backups, the log will...

No. With any fill factor. Of course, the lower the fill factor the more out of order inserts you can have without...

Oh no! The one table to rule them all design. If I were you, I'd start running now. This database 'design' tends to crop up again and again in tales...

Move the subquery into the from clause, so you can reference it as if it was another table. You'll likely get better performance too.

SELECT ... FROM Table1 INNER JOIN (SELECT...

I may be wrong, but I think it only comes with the non-free versions of SQL server.

What you may like to do, if you're serious about SQL is buy...

Edit: Never mind, I'm talking garbage

Since you have AWE enabled, that's not the issue.

You need to patch SQL to SP2 or later for it to run on Vista

Download SQL Express. You should be able to fid it pre-patched. That's enough to play around...

If your clustered index is on a column that doesn't increment (identity, date inserted) then inserts cause page splits. Page splits cause increased IOs and index fragmentation. Fragmentation causes slower...

Yup. That's pretty much the same query expressed a different way. The IS NULL check needs to be left out, or you'll get no records as you've reversed the logic...

In my opinion, 100% correct. My...

Right, lots of querying, searching and reading later...

The Practical Troubleshooting Guide (edited by Ken Henderson) pointed me at the cache counters and cache entries DMVs. The top 3 cache stores,...

Thanks. Looking into the output of the DBCC.

Interesting thing checking perfmon. The private bytes for the SQL process is climbing constantly, as is the working set. However, target and...

Change it to VARCHAR(max) . That's the 2005 replacement to TEXT

Apoogies for the delay.

Give this a try

SELECT * FROM StockCount LEFT OUTER JOIN

( SELECT CountID FROM FunctionStock

WHERE @FunctionStartDate BETWEEN StartDate AND EndDate OR @FunctionEndDate BETWEEN StartDate AND EndDate...