I think SqlVogel has primarily nailed the technical part of the answer. I'd add one more reason for using a primary key over just using unique constraints. Clarity. By defining...

And backup is an operation that lets you see what percentage complete it is if you look at the running process in sys.dm_exec_requests.

SQLSACT (1/31/2013)

---

Thanks

I understand the workspace memory area (Well, I hope I do). A query will request required memory and once the query has been granted that, if it needs to,...

If you have a query that is taking a long time, the first thing I'd suggest is taking a look at the execution plan to understand what it's doing on...

Welcome to the Thread! And SQL Server Central.

By and large, we try to keep this place as a water cooler, a place to discuss things other than technology, although technical...

Well what's the major issue. You're asking about very low level behavior. It's not immediately applicable to most tuning situations. I mean, there is a specific area called workspace memory...

Great catch Lynn. Good point. But, once again, back to clarity.

Get a copy of SQL Server 2008 Internals by Kalen Delaney. Then read it 100 times. You'll still be confused (as I am) but less so.

The second example you're passing a string to an integer value. You can't do that. 2 does not equal 'rsv'.

On a side note, naming variables @1, @2 or @a,...

george sibbald (1/31/2013)

---

Grant Fritchey (1/31/2013)

---

Or, look to a third party tool like Red SQL Data Compare & SQL Compare. But you can't use the backup process to only move pieces...

SQLSACT (1/31/2013)

---

Thanks

Basically correct. Although, it really only matters to the internals engine. For your purposes, both are dealt with the same way. According the to the Internals book, a...

Ah, well then, you need to have the business requirements that the database is supposed to meet in order to evaluate if it's going to meet them. Then you need...

I don't know any training institutes in Bangalore, but what about just signing up to Azure and start doing it. You can get a sample account for free. As long...

If you really don't know the structure, then you need to hope that all the tables have foreign keys. You can look at the dependencies of one of the tables,...

I also like Michele Ufford's scripts[/url].