Need help resolving blocking problems

Question

Need help resolving blocking problems

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Sorin Petcu Hall of Fame Points: 3145 More actions · Answer 1

Yes, I am using also Idera's Diagnostic Manager since a couple of months and I could say that it is fantastic! I solved a lot of problems like blockings, deadlocks, and worst-performing queries and stored procedures. It is awesome! Now, I am a happy DBA! 🙂

In Theory, theory and practice are the same...In practice, they are not.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 2

EDIT: Actually, create a database on the new server with the same name as the database you're linking to on the old server. Create views which have the same name as the table objects on the old server. Define those views as having SELECT statements using the 4 part naming convention.

I must be getting old... Brian keeps beating me on these posts 😛

That would be a great way to do it... think of the views as "synonyms" for the tables.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

homebrew01 SSC Guru Points: 55454 More actions · Answer 3

SQL 2005 has synonyms that are for situations like this.

chava.sreekanth SSC Journeyman Points: 97 More actions · Answer 4

Can you help me with your procedure, I too ran into the same issue.

your code might help me to an extent.

Thank you

Sreekanth