This might be helpful reading.

https://dotnettutorials.net/lesson/over-clause-sql-server/

• This reply was modified 4 years ago by homebrew01.

What is the type of Source file ? Direct export from query results ?

Is the data the same ? Maybe different results, cause different CR-LF ? Something like an embedded...

• This reply was modified 4 years, 1 month ago by homebrew01.

sp_who2 ?

This may give you what you want, or get you close.

SELECT 
MAX(QS.last_execution_time) LastExecution,   
COUNT(*) ExecutionCount, 
DB_NAME(ST.dbid) DatabaseName, 
OBJECT_SCHEMA_NAME(ST.objectid, dbid) as [Schema_Name], 
  ...

The goal is to look at all SPs across databases with a specific reference in the code, so I can't make changes to all the SPs affected.

Logging might be a...

Agree that some documentation is better than none. My pet peeve is code with few or no comments. It takes just a few seconds to add comment lines here and...

Looks like you have to do separate install for each instance, which I would expect.

That also includes people that copy exactly what...

• This reply was modified 4 years, 1 month ago by homebrew01.

Another thought....TEST !

Practice restoring your backups to a test server, under various scenarios.  Is a test server available ? If you need to restore production to a test area to...

We use SAP Data Services. We have multiple platforms, SQL, IMBi and a couple of Oracle links. It's similar in some ways to SSIS.

One tiny feature I recently found that...

When we had a credit card payment auditor wanting SQL information, he sat with me, while I ran the queries, and he could see the results.

If one of you is...

• This reply was modified 4 years, 1 month ago by homebrew01.

I agree with Frank, that the column names for dates should be generic, not including hardcoded dates.

Then load into a temporary table, and use UNPIVOT to load into your permanent...

Have you  confirmed there are no other processes causing blocking ?

I think some 3rd party backup tools have Object level restore options. Otherwise, several good options already mentioned above.

You probably need to add "COLLATE" to JOINs and WHERE statements

SELECT  A.FLD1, B.FLD6

FROM TABLE_A A

JOIN TABLE_B B on A.FLD1 COLLATE Latin1_General_CI_AS   = B.FLD2

WHERE  A.FLD3   COLLATE Latin1_General_CI_AS  = B.FLD6

• This reply was modified 4 years, 2 months ago by homebrew01.
• This reply was modified 4 years, 2 months ago by homebrew01.