1) Sort of, and 2) Yes.

If you are using a linked server via MSSQL then it applies, if you're setting up an a linked server via an ODBC or a...

Remote Login Timeout: the time it takes to authenticate on a linked server before timing out. For example, if you are trying to log in to a remote server and...

I can't recall off hand if it's a bug within SQL or not, but it will work if you use the fully qualified domain name that the share is mapped...

This isn't pretty by any means, and you probably should just use a power shell script or something similar, however this will work - just tweak it as needed: SET...

@arnipetursson +1 - The logins/SIDS completely slipped my mind, but shouldn't pose much of an issue considering they would physically be available to the DR site, you'd just need to...

Nice article. However, I am having difficulty opening up the RDL file, many errors:

I assume this is...

Without knowing more details on your setup, transaction replication may be overkill...or not even possible.

For one table/one column I'd probably just set up a trigger to perform the delete/insert/update as...

TheSQLGuru (10/16/2008)

---

I think several things were missing from the article:

1) You should cover the need to handle foreign keys to the PK

2) You should cover a best practice of dropping...

Please refer to this great article (near the bottom)

http://blogs.msdn.com/b/sqlcat/archive/2013/10/30/reporting-services-performance-and-optimization.aspx

Through Google searching I've come up with a great way to automatically script out the procedures, but currently am having trouble getting the delete portion to work

Powershell script$rootDrive = "C:\Temp\"

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO")...

What are you using? TSQL? SSIS?

Where's your query that generated the data?

Thanks for the suggestion, much appreciated - I know I could do that but I'm looking for an automated way it can be done (something I can place in a...

MUCH SIMPLER 🙂

Mark-101232 (10/23/2013)

---

Yes, you just need to change the ORDER BY clause

;WITH Dups AS (

SELECT

[Patient_Count]

,[Read_code7]

,[Read_code]

,[Current_Caseload_Holder]

,[Staff_number]

,[Event_date]

,[Event_done_at],

ROW_NUMBER() OVER (PARTITION BY [Read_code7],[Read_code],[Staff_number] ORDER BY CASE WHEN [Current_Caseload_Holder] IS NOT NULL THEN 0...

Just add a condition Current_Caseload_Holder IS NOT NULL

Or you can just add to your CTE and fetch records for the ones that are/are not null, using a UNION ALL

An example that may work for you (as mark suggested in the link provided);WITH Dups AS (

SELECT

[Patient_Count]

,[Read_code7]

,[Read_code]

,[Current_Caseload_Holder]

,[Staff_number]

,[Event_date]

,[Event_done_at],

ROW_NUMBER() OVER (PARTITION BY [Read_code7],[Read_code],[Staff_number] ORDER BY [Read_code7]) AS Cnt

FROM MyTable

) SELECT * FROM...