If you expand out the server in enterprise manager, can you see the system databases? Can you see the user databases? If you can see the user database, is there...

You can use SQL Profiler. Trace the event T-SQL Batch completed and take the start time, end time and duration columns. Duration is in microseconds.

Are you trying to find deadlocks or blocking? They're fairly different things.

To find blocking, you can use the sys.dm_exec_requests or sys.dm_os_waiting_tasks DMVs. Both have a column that will show if...

Please don't type in full caps. It's the online equivalent of shouting.

Suspect in system tray? Not quite sure I understand.

If you open enterprise manager and connect to the server in...

Rather don't shrink your dataabses, especially straight after an index rebuild. Index rebuilds put the index pages in order, shrink will move them completely out of order. You may as...

Can you post the table structure and index defs please? Also, if possible, the execution plan (without the index hints in place) (run SET SHOWPLAN_ALL ON before the queries) in...

Full and diff backups don't truncate the log. Log backups do.

If you have an full backup at midnight and hourly transaction log backups, the the log backups only contain...

To do that, you'll need the previous day's full...

I believe it has to do with the order of the columns in the group by, not the select. I don't have a SQL instance around right now to test...

Make very sure that you have viable backups somewhere other than on the server itself. See here[/url] for why.

There no point in doing a diff straight after a full DB...

They can be. Imagine an update that affects 2 GB of data on a server where...

Oh, and also. 20 million rows is not a trivial amount of data. Index seek or no index seek, it will take time to fetch that data from disk (if...

Looking at just that scenario, and ignoring any possibility of other queries, I'd do the following.

Drop the NC index on Col1. As Grant said, it's not necessary. Make the PK...

Restart the SQL instance.

I asked the same question of PSS a couple years back. There's no command, documented or other to clear out memory in MemtoLeave

Is the server you're writing to running? Are the permissions of the account running profiler sufficient?

It's generally recommended to run server-side traces to file, not to table, and import the...