Also, if you are looking for a more detailed and long term activity monitor, it is something you can actually setup yourself. Microsoft provided us with SQL traces and the...

Hi,

Creating SQL traces and importing the data into a table is the based way to track performance over time. This is all the monitoring software does and you can create...

Hi,

We like to setup SQL trace files to run all the time and dump the results into a table. This allows us to do a couple things:

1. Have an easy...

I find the following script to be very helpful when making changes to a database I am unfamiliar with. Let's say you have a table or procedure that needs to...

On a lot of our servers, we like to keep performance traces running throughout the year. This allows us to look at a few reports to check on long running...

If you are looking for optimization techniques and steps, you can visit the site in my signature. Something you might want to try with those empty tables is to load...

You can visit this site and it will take you through a lot of the introductory steps. There is also a troubleshooting tool that can help to identify some of...

You can try stopping and closing the trace. Then try again. I am not sure what your whole trace setup looks like, but you need to add events, columns, filters,...

This tool can help you get started with figuring out the basics:

Performance Troubleshooting Tool

Hi,

We had some comments on the page I posted above in relation to cursor speed and whatnot. In the end, I went to the Microsoft SQL updates/service packs and tried...

Try to do what you can to minimize the data volume as well. Ask yourself these kinds of questions:

- How long you need to keep the data for? Purge Old...

Were these the type of results that you were needing?

SELECT *

FROM Table_Name

WHERE Code IN (

SELECT Code

FROM Table_Name

GROUP BY Code

HAVING COUNT(*) >= 2

)

Isn't the MAXDOP option reliant on the number of processors that the server has? Does your test server have only 1 processor?

If you do find yourself stuck in a situation where you need to cycle through every record in a table, here is a good example of how to code a...

The site in my signature also has some good material for learning the basics of optimizations.