I do a lot of query optimisation at the moment.

I love the feeling that accompanies getting a 5 minute query run in 5 seconds

The odd occation when a user...

Understanding locking is essential if you find yourself administering a heavily-used database (or one with very bad queries and indexes)

Understanding the basics will take you a long way.

the main...

The best choice for a clustered index is a column that is narrow, evver increasing and unique. The closer you get to that, the better. The PK is not always...

The questions you'll get in the exam are selected at random from a large pool. Hence you may or may not get any questions on locks.

What's the problem you have...

It did mention the version

Question - Worth 2 Point(s)

Category : SQL Server 2005 - TSQL

You did try it on sql 2005?

Only if the two tables have the same number of fields with compatable datatypes.

It doesn't compile because of this:

LEFT OUTER JOIN

  (SELECT COUNT(ID) AS NumberDue

   FROM tblMEMResellerOrders ResOrds

   WHERE (resords.Expiration <= '12/30/2005 23:59:59')

    AND (resords.Expiration >= '12/1/2005 00:00:00')

    AND (resords.PurchaseOption <>...

Impossible to test without table schemas and example data, but this should give you somewhere to start.

I moved the subqueries into the from clause so that the values returned...

Firstly, I would suggest a table redesign, if that's possble.

EmployeeSkills would be much, much better as below.

CREATE TABLE EmployeeSkillset (

 EmpID CHAR(8) NOT NULL,

 SkillID INT NOT NULL,

 IsPrimarySkill BIT NOT NULL...

JV: check the account that SQL Agent runs as. Make sure it has permission to access the file. Make sure you use full paths, not relative paths

Regarding permissions for...

Just bear a few security issues in mind. A fairly high priviledged account is required to use xp_cmdshell. Check Books online for the exact details

Commands run from xp_cmdshell run as...

Um, her test, actually

I didn't think of the subquery, thanks for that idea.

I was...

Won't work. I had a similar issue the other day. Once you've created a column alias with the same name as a column in the table there's no way (that...

why would you want to call a DTS package in a trigger? Trigger code should be as short as possible and do as little as possible.

What are you trying to...