Bill

Try this - doesn't need any IFs and does it in one line:

SET @end_date = COALESCE(@end_date, @start_date)

John

Nic

Yes, Task Manager isn't a reliable indicator of AWE memory. Try using the counters in Perfmon, or you should also find the same information in one of the dynamic...

Nic

I think with AWE you can't use dynamic memory, therefore you have to fix it at 4BG, say, and you should see it using that as soon as you've restarted...

You answered the question yourself. Set the /PAE switch in boot.ini and configure SQL Server to use AWE.

John

You could write your own aggregate function to concatenate the values, and then it becomes a simple GROUP BY query. Other than that, I can't think of any way...

Or, if your table looks like your second example, and not your first, then just create the table with T_VEHICLES as a computed column. Again, no triggers, but everything...

I think I see what's going on. You need to make sure that NT AUTHORITY\SYSTEM has permissions on the remote server. Either that or make a different login...

Try using brackets ([]) instead of inverted commas ("") to enclose your server name.

John

I would advise you not to shrink your logs regularly. Let them grow to whatever size they need to be and then leave them. You can reduce the...

I don't think you want to do it globally if it's just for SELECT statements. Just use the NOLOCK hint in queries that you don't want to lock the...

ben.ashton (3/28/2008)

---

I am still slightly puzzled though as on our test database we were getting PAGE level locking, until we re-built the Unique Clustered Index on the CONTACT table. ...

Are your statistics up to date? If not, then the query optimiser might not be able to make the correct decision about what type of lock to take for...

Why is this a problem? If you want to select everything from a table, then you need a lock on the whole table. It doesn't matter whether that's...

Something like this:

INSERT INTO LOGLOG (destination, [content])

SELECT phonenumber, 'hello world'

FROM USERLIST

where OWNERNAME LIKE @name

John

Diann

Are you sure you need the join at all? From the data you've provided (which looks as if you've simplified it quite a lot), it appears that this will...