GilaMonster (4/22/2012)

---

A query's cost is not the number of seconds that SQL thinks it will take to run. Yes, the documentation says it is, the documentation here is wrong. Costs...

i had to do something similar and this post http://www.sqlservercentral.com/Forums/Topic310849-291-1.aspx helped me. You can just copy the changes without re-setting entire replication.

SQL_DBA_3 (4/21/2012)

---

On my db server with 20 instances , CPU usage is 100%.In task manager i could see Litespeed is using all the cpu. There are two litespeed processes in...

opc.three (4/16/2012)

---

Yeah, I was just making sure you were comparing apples to apples and not looking at something like SQL:StmtCompleted vs SQL:BatchCompleted or RPC:Completed. Now that we have that cleared...

RML51 (4/16/2012)

---

Building a two node cluster on one physical server does not make any sense. The only reason to have a two node cluster is to protect against failiure on...

Issue seems to be the same but there...

Eric M Russell (4/12/2012)

---

sqldba_newbie (4/11/2012)

---

Eric M Russell (4/10/2012)

---

Consider implementing a pass-through style query using EXEC(<sql>) AT <servername> syntax. If this query must be implemented a View, then consider replicating or...

Eric M Russell (4/10/2012)

---

Consider implementing a pass-through style query using EXEC(<sql>) AT <servername> syntax. If this query must be implemented a View, then consider replicating or grabbing a copy of...

opc.three (4/9/2012)

---

Using your sample code from earlier the bold string-literal is the 'query' argument:

SELECT ...

opc.three (4/9/2012)

---

sqldba_newbie (4/9/2012)

---

opc.three (4/9/2012)

---

An alternative to using OPENQUERY is to use the EXECUTE...AT syntax to also force the query to execute on the remote server. OPENQUERY is a bit more...

opc.three (4/9/2012)

---

An alternative to using OPENQUERY is to use the EXECUTE...AT syntax to also force the query to execute on the remote server. OPENQUERY is a bit more flexible in...

this really worked. I replaced the entire query and...

Grant Fritchey (4/8/2012)

---

That's going to bring all of the remote server's data back and then perform filtering on it. Horribly inefficient. Instead, look to OPENQUERY where you can pass some...

Lynn Pettis (4/7/2012)

---

Sounds like you are using a linked server. If you provide the query you are currently using we may be able to show you how to improve...

Matt Miller (#4) (4/5/2012)

---

Depending on which type of connection you're setting up, you've got conflicting instructions.

integrated security=sspi

means "use the current windows credentials over Kerberos", so then passing the user...