Nice article, thanks Jeff.

Thanks Jeff, can you please give me an example of "Accidental" cross join?...

Thanks for the response RP, but no such thing in our case.

I used following queries to check the row count for each object in tempdb and the open trans, but...

Thank you so much for following up Jeff, and sorry for not providing the feedback. Actually i needed it for a one time import so i used Lowell's solution and...

Thanks Lynn, you are the best 🙂

Thanks Lynn.

I took following code from BOL and its using StopAt with full backup, how come?

RESTORE DATABASE MyAdvWorks

FROM MyAdvWorks_1, MyAdvWorks_2

WITH NORECOVERY, STOPAT =...

@lowell:

Thank you so much for your solution it works but only if there is one reference number in the notes. If you look at my original post there...

Thanks guys, "ROW_NUMBER/PARTITION BY" worked for me.

Thanks for your help, reading BOL now.

Ed-86789 (10/28/2009)

---

I would suggest the "Fuzzy Match" feature in SSIS. I have used it a couple of times to cross reference data between different systems and it has been...

Lowell, thanks for your help.

We removed the access permissions from the shared folder and its working fine now with the 'Local System'.

You said it should not work with 'Local system'...

Thanks guys.

I know using Local Service Account is not a good idea but for now it was working fine and was able to connect to the remote location untill we...

I have a company table containing all the information about different companies (name, contact, address etc).

I want to identify the closely matching companies based on company name.

e.g i want to...

Thanks guys, appreciate your help.

Thanks guys, i was thinking along the same line but was wondering if there is another way to do it.

Actually i want to monitor the performance of the server by...