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].

If you mean how much it's using at the OS level, fair warning, that graph is likely to be very flat. SQL Server grabs as much memory as it can...

By and large it's about IOPS and contention. How many operations per second can your disk do and how much is it doing. When you think about the operating system...

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 hash table...

You can use the command line utility with SQL Data Compare to programmatically have it do that type of work for you. Here's the documentation on how that works. You...