Impossible to say without more information, but probably you're getting table scans.

To do this in TSQL, you would need to use ad hoc queries and build your query as a string. SP_EXECUTESQL would be the best use.

Generally, something like this might...

I'm not saying you're wrong, in...

Just open up the Server Properties in SSMS. On the Processors page you can see how many processors you have available and set them to a particular affinity. I'd suggest...

When you say reads, do you mean STATISTICS IO in SSMS? Or you are referring to execution times? There is a difference there since SSMS is still showing milliseconds and...

I'm on LinkedIn, Plaxo & Facebook, but I probably don't open them more than once a week at the most and then for only a few minutes. Twitter on the...

Excellent. I'll take full credit for...

Excellent. Congratulations and good luck.

Depending on how the data is distributed, what kind of data, etc., you might want to look into partitioning. This would allow most of the data to be online and...

If you don't have windows authentication enabled anywhere, then you might be in trouble. There's no way to hack past the password (even if there was, this is not the...

I don't quite get the question either. If you read the foreign key constraint, it's going to tell you which table is constraining. From there you can either simply select...

Whatever this job is, I hope it's not too intrusive to the system since it sounds like it's going to be running 24/7. If you're inserting or updating data all...

I don't know. That sounds... almost... on topic. :hehe:

Kendal Van Dyke (3/27/2009)

---

I think it's a bit harsh and perhaps even a bit academic to say never ever run profiler against a production server. Yes, it can create problems...

You can create clustered and nonclustered indexes on temp tables.

Syntax is like this:

CREATE INDEX myindexname ON schemaname.tablename(col1,col2)

INCLUDE (col3)

WITH FILLFACTOR=80

ON Primary

That creates an index consisting of two columns which includes...