Not my...

Thanks Jeff!

As to the quality of the questions and the problems presented, I've found that they represent...

Jack Corbett (10/21/2014)

---

I think there are fewer overall posts and most of the posts are by people who have very little understanding of or experience with SQL Server....

Thanks Sean

Thanks Ed, Koen and Jason.

It feels good to be back 🙂

Hi!

It's been a very long time since I last posted on THE thread...

Actually it's been a very long time since I posted regularly on the forums, but now I want...

The current Service Pack for SQL Server 2008 R2 is SP3:

http://www.microsoft.com/en-us/download/details.aspx?id=44271

Steps:

1) Download SP binaries

2) Apply in test environment

3) Test applications

4) Apply in production

If it is a clustered instance, apply on...

DELETE D

FROM Prescription_D AS D

INNER JOIN Prescription_H AS H

ON D.Presc_No = H.Presc_No

WHERE H.Modify_Dt >= CONVERT(DATETIME, '01-01-2012', 103)and H.Modify_Dt <= CONVERT(DATETIME, '01-01-2013', 103)

You can either point directly to the secondary server or point to the listener adding the connection string property applicationintent=readonly. In this case you have to use the Native Client...

Here's a good article on troubleshooting connectivity issues:

http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

Join the two tables to filter on the date:

INSERT INTO DB_Archive.dbo.Prescription_D

SELECT Prescription_D.*

FROM Prescription_D

INNER JOIN Prescription_H

ON Prescription_D.Presc_No = Prescription_H.Presc_No

WHERE Prescription_H.Modify_Dt >= CONVERT(DATETIME, '01-01-2010', 103)and Prescription_H.Modify_Dt...

+1000

Just subtract one day from the first day of the next month.

We need table definitions as CREATE TABLE statements, some sample data in the form of INSERT INTO statements and expected results.

See the first article linked in my signature line...

LInked servers are not particularly efficient at transfering data. They can be ok for small data sets or whenever performance is not an issue.

With big data sets, a better approach...