blakmk (10/8/2012)

---

thanks opc.three. yes when you kill it definatly invokes the rollback mechanism. What im talking about is does the client receiving ALL of the data, depend on the commit...

My gut says no, the transaction would not be committed until the OUTPUT clause completed being consumed by the caller. It is easy enough to test...

-- setup the environment

USE AdventureWorks2008R2

CREATE...

Exact data relative to what? Are you just looking for a total number? How do you expect to use these numbers?

CPU and I/O stats for queries [currently in the cache]...

dnonyane (10/8/2012)

---

we are using x86 and the reason we wanted to link the servers was to create stored procedures and create jobs that will run at night to update sql...

x86 or x64?

Is using SSIS an option?

Yes.

2. How many databases...

Just for the record an RPC event does not necessarily mean it was generated by a call via a Linked Server. All data clients have the option to generate RPC...

SQL Server does not support UTF-8.

SQL Server does support aspects of UTF-16.

SQL Server natively supports UCS-2 which is a subset...

What do these say?

SELECT cntr_value / 1048576.0 AS [Lock Memory (GB)]

FROM sys.dm_os_performance_counters

WHERE counter_name = 'Lock Memory (KB)';

SELECT SUM(CAST(single_pages_kb AS DECIMAL(18, 2))) / 1048576.0...

Duplicate post. Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1368189-1550-1.aspx

Here is a good way to stay on top of new releases:

For your specific version and patch level: The SQL Server 2008 R2 builds that were released after SQL Server...

Wow, you waited a whole 17 minutes before bumping your own thread 🙂 We're volunteers here. If you're under a serious deadline and need immediate assistance consider hiring someone with...

The options you're weighing are not as relevant for performance as they are for data integrity.

Three isolation levels were mentioned:

1. READ UNCOMMITTED (same as using targetted NOLOCK hints on all...

Are you running into issues or just doing research?

This says it should be the same and while I haven't tried clustering with Developer Edition everything else I've tried works the...

Can't do better than free!

If GSquared doesn't have the goods this site seems to have it:

http://www.viosoftware.com/SQL+Server+2005/SQL+Server+2005+Developer+Edition+DVD+%252526+Key.html