Which book is that? Author?

I had a book for (I think 441) that was so packed with errors it was worse than useless. Can't remember the title right now. It's...

How many non-leaf pages are there in the index? I think one of the index DMVs will show you that

Not on SQL 2000. The exec plan in xml is a 2005 specific feature (specific to the 2005 server,...

Do you have replication running (transactional or merge?) Full backups never truncate the transaction logs. Only log backups truncate the inactive portion of the log.

What are you checking to see...

You have domain users granted login to the box? With what rights? If so, remove it and set up appropriate windows groups and set their permissions to just what the...

Is the SQL Service on that machine running?

Sure. Trace the events SP:stmt_Completed and T-SQL:Stmt_completed (if you want to see individual statements in a proc/batch) or SP:completed and T-SQL:Batch_Completed

You can then filter for duration >1000 (1000 ms) to...

Try Solid Quality Mentors. From what I've heard, they're very, very good.

The optimiser will pick a table/clustered index scan if it feels that its more efficient that multiple seeks (possibly with key lookups). It's not going to decide to scan just...

LIKE '%/%%' ESCAPE '/'

Means that the character after the / is treated as a literal, not as a wildcard.

Can you post the indexes that are on the table please? Also the execution plan would really help.

Run the query in management studio with the execution plan option switched...

CLR is good for things that T-SQL can't do. Accessing web services, file system. For normal data manipulation - T-SQL all the way.

Can you post the query please, the schema of the tables and any indexes on those tables?

Thanks

The other problem with the sp_ (don't know if it was mentioned, I didn't read the entire thread) is the possibility of overlap with a system proc (current or future)

If...

syed muhammad naveed (1/24/2008)

---

1> When i say Auto create statistics, what are the columns for which statistics are collected? Are these all columns part of the primary key or just...