Have you looked at the wait statistics to understand what is causing things to run slower? It may not be memory. It could be your disk. It could be your...

It's two different tools. One examines your structures & code to validate for upgrade. The other is used for testing how your queries behave. You can use both as part...

It will. It might take as long or longer to rollback.

Is anyone else experiencing this? When I type into a post, as I'm doing now, When I hit enter to put a new line
t moves my cursor so that...

Who is going to SQLSaturday NYC?

I'm doing the keynote.

Since we're talking formatting, I'd strongly recommend taking a look at SQL Prompt from Redgate Software (DISCLOSURE: my employer). Not only will it help you with formatting,...

Trace (Profiler is just the GUI for consuming Trace events) is going to capture all executions of queries (depending on how you set it up of course) while querying sys.dm_exec_query_stats...

Yeah. It can be very...

If I read the code correctly, you're calling a stored procedure? Have it insert the data at the same time it retrieves it.

Or, are you trying to store...

Following Microsoft's ELT, as opposed to ETL, approach to Data Warehouse, you sure should be able to make that work. I'd offer to test it for you, but I'm a...