Is irrelevant , you can only talk about faster / slower / good performing / bad performing once you have...

Well, yes you can roll them back just not in the proc that failed. You will have to check the @@Error status in the caller routine , as the...

More like , hit post , oops thats all nonsense 🙂 Hopefully i deleted before google cached it...

What plan do you get for

SELECT r_t_id--, a_value

FROM rank

INNER JOIN topic on rank.r_t_id = topic.t_id

--INNER JOIN topictag on t_id = tt_t_id

--INNER JOIN tag on tt_a_id...

According to the execution plan there is no join predicate on the rank table to the others.

If you fully qualify the columns in the joins you should be able to...

Maybe one already exists....??

Not sure what "higher authority" Paul set his info from (such as undocumented flags used in http://sqlblog.com/blogs/paul_white/archive/2010/07/31/inside-the-optimiser-constructing-a-plan-part-4.aspx) but it doesnt go beyond the realms of reason that...

Jack Corbett (9/13/2010)

---

Something I think is somewhat related, I'd love for MS to allow you to tell Developer Edition what mode to run in, i.e. Standard Edition/Workgroup/Enterprise, so I could...

---- EDIT bum steer

Hi Brandie,

I think you answered your own question in your initial post 🙂

Consider this code

Drop Procedure spMySillyProc

go

Create Procedure spMySillyProc

AS

BEGIN TRY

print 'running'

BEGIN TRANSACTION InsUpd; ...

It is worth pointing out that Brads blog does not test the raw performance comparison for each splitting method.

But it is more what sqlserver will then do ,...

How many page/faults per second are you seeing ?

Is sqlserver having memory swapped out to disk ?

Possibly ,

try this http://tinyurl.com/2acrnjh

master..sqlbackup is not a standard procedure so cant really comment to much on your exact problem.

It this the red gate SQLBackup ?

Error 510 is generally associated with networking errors. ...

Personally, i would like an "OPTIMIZE FOR (CONCURRENT) " option.

In an ideal world this would create a plan that executes more slowly , but touch fewer rows and therefore reduce...

Brad Schulz has done a nice round up

http://bradsruminations.blogspot.com/2010/08/integer-list-splitting-sql-fable.html