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

I don't have an answer for you, but I contacted someone at Confio to see if they can help you out.

Do you mean validate the data structure of a SQL Server database?

Or do you mean validate the layout of a SQL Server installation?

Or do you mean evaluate SQL Server as...

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 of a database. Backup...

None that I'm aware of. The level of flexibility there is pretty limited. To do it right, you really have to make all the objects functional, otherwise the builds fail...