There are a number of great articles on

- cursor avoidance:

-- http://www.sqlservercentral.com/articles/T-SQL/66097/

- RBAR avoidance:

--http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

attached you'll find on one slide of the presentation I gave yesterday.

It was supported by the...

tsss, details ... details... :hehe:

First step to become asaint is to get beatified.

If guess that certainly will not be a problem :hehe:

Say 5 "hail...

your table is a heap, so rebuilding your indexes may not give you the result you aim for.

It isn't using the index [ixcustsalesman] your created for column [id_salesman].

Can you define...

Typical questions on migration:

- did you perform post migration actions like:

-- DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY;

---- kb http://support.microsoft.com/kb/923247

-- rebuild all indexes

-- update all statistics

-- dbcc updateusage

- were you...

No problem. 😉

In many cases production continuity is more important than going for the bug.

However, if this re-occurs, you may have to invest time to figure out why it stops...

How about some feedback, so others can your this thread as a ref.;-)

If that one is free on your server, that should be ok.

However, I must admit, I haven't found a list of "reserved ports" yet.

There must be some kind of convention,...

Also keep in mind there may be some firewall configuration stuff to perform on both sides !

(allow the port numbers)

Paul White NZ (12/13/2010)

---

OMG there's a guy called Dr Seward, who has a free eBook called:

"Gila Monster Propagation"

I have not yet summoned the courage to hit 'download'...

edit: ok so I...

SSB is something you need to prepare !

Make a checklist and tick the items you actually perform, as you do it !

Off course, Adam Machanics articles are wonderful, and I...

- So, do your apps still receive deadlock errormessages ?

- can you enable the traceflags to write the deadlock info into sqlservers errorlog ( 1222,.. ) ?

dbcc traceon(1222, -1)

btw todays...

Steve Jones - SSC Editor (12/12/2010)

---

Tom.Thomson (12/12/2010)

---

Steve Jones - SSC Editor (12/11/2010)

---

Excellent response from Lowell and Gus.

Tom,...

I would suspect some malfunctions in your SSB environment and start SSB debugging actions.

- did ERRORLOG indicate a queue shutdown or something you can link to event notifications ?

- have...

with 32-bit, it was restricted to 1,7GB by default. One could even use a /3GB parameter at OS level, to have it consume up to 3GB.

Now, with 64-bit, the OS...