Thank you. Glad you liked it.

Chirag (10/31/2008)

---

Say there is a big data modification (update statement) going on and not all pages affected by the update stmt are in the buffer/memory. Will the pages not in...

At regular intervals depending on the number and frequency of data modifications.

Yup.

Yes. The command is CHECKPOINT. It's...

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic594505-17-1.aspx

If neither query does exactly what you want, post the table structure, some sample data and your expected result.

Please define 'that doesn't seem to work'. Did it throw an error? If so, what error. Does it give incorrect results? If so,...

The second portion of your where clause is effectively turning the join into an inner join

select count(new.PolicyID) as New, count(ren.PolicyID) as Ren

from Policies new left join Policies ren on new.PolicyID=ren.OldPolicyID

where...

Duplicate post.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic594447-391-1.aspx

There's nothing similar to audit logins for anything else. If you want to track DDL changes, you'll have to use a DDL trigger or a server-side trace that's permanently running....

Backup and restore's the safest. If you haven't made changes to model on SQL 2000, you can ignore that one. Unless you're moving all the jobs, etc, ignore msdb as...

Yes, you said so earlier. What's the initial size for tempDB? The size it gets created at on a restart? (Should...

What were the wait resources?

These two links should help

http://www.microsoft.com/learning/mcp/mcts/sql/

http://www.microsoft.com/learning/mcp/mcitp/dbdev/

As it should be. What's the initial size for tempDB?

You are correct, an order by in a view or subquery is ignored. Order by only applies if it's in the outer select statement, unless there is a row-limiting top...