TheSQLGuru (5/1/2015)

---

sql-lover (5/1/2015)

---

TheSQLGuru (5/1/2015)

---

I didn't read deeply (TL;DR) :), but the first thing I would do is put the query into a sproc on the remote side and call that...

I've started to think that is because MyTable is a "hot spot". Hundreds of clients hitting the same table, to get a different set and return that back to Server2,...

Lynn Pettis (5/1/2015)

---

sql-lover (5/1/2015)

---

Lynn Pettis (5/1/2015)

---

Give the following a try:

INSERT INTO #t

SELECT DOB, col2, col3 FROM OPENQUERY([Server1],'

SELECT top 1 @DOB, col2, col3

FROM MyDatabase.dbo.MyTable

WHERE col4 = @ZipCode

AND col1 = @DOB

ORDER...

TheSQLGuru (5/1/2015)

---

I didn't read deeply (TL;DR) :), but the first thing I would do is put the query into a sproc on the remote side and call that from local...

Lynn Pettis (5/1/2015)

---

Give the following a try:

INSERT INTO #t

SELECT DOB, col2, col3 FROM OPENQUERY([Server1],'

SELECT top 1 @DOB, col2, col3

FROM MyDatabase.dbo.MyTable

WHERE col4 = @ZipCode

AND col1 = @DOB

ORDER BY MetricDate DESC')dt(DOB,...

Jack Corbett (5/1/2015)

---

What is the security context the linked server is using? Unless that user has pretty elevated permissions it can't access the statistics in order to...

I used DBMirroring (SQL2005 and SQL2008), and it works nice! Migrated 500+ GB databases that way in seconds (assuming you have decent network and both are in the same LAN)

You...

Old post, but I will answer myself.

It was Index Tuning Wizard , indeed! But so many years ago that people did not remember or did not ring a bell...

Just curious. Is your system fully patched? MSSQL and Windows? ...

nick.latocha (4/17/2015)

---

Half my team are stuck on windows XP so it's not an option. I'm on Windows 7 so will be planning on installing SSMS 2014.

Ideally we are looking to...

+1

Jeff Moden (4/16/2015)

---

sql-lover (4/16/2015)

---

Zeal-DBA (4/14/2015)

---

my update query updating approx 50 million record which is causing transaction log to grow, and filling disk space and finally transaction is failing, please suggestany...

My standard...

marc.heidemann (4/16/2015)

---

Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are currently investigating this issue including possible...

jackimo (4/16/2015)

---

So interesting fact ....

All along I've never considered that the statistics would be out of date, because we have a job that updates stats that runs daily. ...