ChrisM@Work (7/9/2014)

Bwahaaaa! I was so tempted to post "Haven't you...

Yeah, or sys.dm_exec_sql_text to see the queries currently in cache. You'll want to combine that with sys.dm_exec_query_stats just to make things a little easier to put together.

You parameterize the values passed to the query, not the tables and columns. Those have to be explicitly stated. As Gail said, you can build those statements dynamically, but you...

Maybe, but I wouldn't. Take a look at sys.dm_exec_requests. Backup processes will give you a ballpark completion percentage. That should help you know how long you might have to wait.

Try DBCC UPDATEUSAGE and see what things look like then.

Where does my data come from?

Well the mommy data and the daddy data loved each other very much so....

If I understand what you're asking, then I'd suggest either using extended events or a server-side trace[/url]. You can capture the queries and with the queries you can tell what...

I'll come right out and say it. No, it's impossible to just migrate your database over using any straight method.

I agree with the steps Hanshi laid out for a...

Keep an eye out for the SQL Skills Immersion courses. They have a lot of detailed internals knowledge. And it's in-person and travels. Not sure what the schedule is, but...

Where the heck did I see it was 8gb? Maybe time to up my coffee intake. Sorry for the misunderstanding there.

The rest of the processing bit is still correct. You're...

While I'm not a fan of GUIDs as clustered keys, I've seen it in a production system and it wasn't the end of the world. We did have to deal...

So you're going to an underpowered machine (8gb is half the memory my laptop has) and you're running a very large aggregation query and returning 1.7 million rows. The machine...

I agree with everything Sean said. I'll add to it by questioning the nonclustered indexes that you want to add. Why are you adding those. Do you know you need...

Depending on my mood and the attitude of...

For really tiny databases like this (and 7gb is tiny) I wouldn't bother with differentials. A full backup will run very fast and a full restore will run very fast....