August 19, 2011 at 8:08 am
WayneS (8/19/2011)
Ninja's_RGR'us (8/19/2011)
For those who followed. Paul and I have each posted a connect item for a nasty issue with rollback (corrupts your db). It seems to take a rather weird series of dml + ddl to reproduce. But it certainly looks like any normal deployement script I've seen out there.Rollback / Corruption bug
Paul's version (errors out with object not found, but the object is actually there)
Cool - good going Remi on the perseverance in seeing this through. I bet when Paul files something, it gets plenty of immediate attention.
Good point.
Also I think something like Rollback fails on ALL supported versions should get pretty good attention too :-D.
August 19, 2011 at 8:14 am
Ninja's_RGR'us (8/19/2011)
WayneS (8/19/2011)
Ninja's_RGR'us (8/19/2011)
For those who followed. Paul and I have each posted a connect item for a nasty issue with rollback (corrupts your db). It seems to take a rather weird series of dml + ddl to reproduce. But it certainly looks like any normal deployement script I've seen out there.Rollback / Corruption bug
Paul's version (errors out with object not found, but the object is actually there)
Cool - good going Remi on the perseverance in seeing this through. I bet when Paul files something, it gets plenty of immediate attention.
Good point.
Also I think something like Rollback fails on ALL supported versions should get pretty good attention too :-D.
That's the main reason why I +1-ed on both items.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 19, 2011 at 8:17 am
WayneS (8/19/2011)
Ninja's_RGR'us (8/19/2011)
For those who followed. Paul and I have each posted a connect item for a nasty issue with rollback (corrupts your db). It seems to take a rather weird series of dml + ddl to reproduce. But it certainly looks like any normal deployement script I've seen out there.Rollback / Corruption bug
Paul's version (errors out with object not found, but the object is actually there)
Cool - good going Remi on the perseverance in seeing this through. I bet when Paul files something, it gets plenty of immediate attention.
Reminder!
TIA. It just takes 2 minutes... restore plus hit exec on 1 script.
August 19, 2011 at 8:34 am
ALZDBA (8/19/2011)
That's the main reason why I +1-ed on both items.
Thanks.
August 19, 2011 at 8:35 am
Sorry but I just had to do this :
This is a message I sent to Kimberly Tripp (Paul Randal's wife)
Subject : When Paul's not enough
You call in the best!
Seriously, I'm 99.99% sure I've hit a bug in rollback and even with Paul White, Gail Shaw and your own Paul Randal we're still scratching our heads.
Bug reproduced on 2k5 SP3, 2K8 R2 and Denali (didn't bother with 2k5 sp4 after seeing the same bug in denali)
http://www.sqlservercentral.com/Forums/FindPost1161964.aspx
Have fun (and yes you can quote me on this to tease your hubby :-P)
I just wish I was a fly on the wall right now (they're doing there immersion class.... I just hope she can read this DURING & in front of <the> class :-D)
August 19, 2011 at 9:27 am
Ninja's_RGR'us (8/19/2011)
(they're doing there immersion class.... I just hope she can read this DURING & in front of <the> class :-D)
Class finished yesterday. This is a 4-day one, not a 5 day... 😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2011 at 9:31 am
GilaMonster (8/19/2011)
Ninja's_RGR'us (8/19/2011)
(they're doing there immersion class.... I just hope she can read this DURING & in front of <the> class :-D)Class finished yesterday. This is a 4-day one, not a 5 day... 😀
Oh darn. I was already imagining his face on the funniest video programs we have over here.
next time I guess 😛
I was fooled by the out of office msg from KT. I guess they're not back yet!
August 19, 2011 at 9:54 am
Jeff Moden (8/18/2011)
I wonder if the new splitter from the "Tally OH!" article would have helped here. I've not done any heavy testing with it against VARCHAR(MAX) but some folks have stated that it works just fine. Personally, I find that any splitter that "joins" with VARCHAR(MAX) is instantly twice as slow.
I am betting it would have helped. I think the end result of using the TVP was the best solution though.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 19, 2011 at 9:55 am
ALZDBA (8/19/2011)
WayneS (8/18/2011)
Steve Jones - SSC Editor (8/18/2011)
Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal with PASS, but we'll likely sell tickets and have fun.Look for some details soon.
It looks like the stars are starting to align with respect to me being able to go to the PASS Summit. My company needs to confirm that they have the money in the training budget for the conference, plus two pre-con days. Then, when presenting at a UG last night, the UG leader might forward his free ticket to me if no-one contacts him about it shortly (he can't go due to work commitments). Come on stars, just a little more alignment is needed.
Tell your company I'll be there :w00t::w00t::hehe::hehe::smooooth::smooooth::smooooth:
btw: Yesterday I was in a meeting concerning our new SAN. On the training topic the inital course was 3 days and was worth $2300.
Do I need to point out you can pick the sessions you are interested in, related to the issues you have, MSSupport is on site and available for all your questions, a number of skilled peers will be on site and will be happy to reflect / help out on your concerns.
And of course there are a number of MVP on site. Always nice to have a chat with these guys/galls !;-)
Getting the confirmation you are doing fine with your systems is as valuable as fixing your issues - which I'm sure you'll be able to fix some, like I did over the years I've been granted the privilege to attend SQLPass.
Big selling point in my opinion for Summit.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 19, 2011 at 9:57 am
Roy Ernest (8/19/2011)
Thank You everyone for the input on TVP. It looks like something worth investing my time to do some performance testing.
indubitably :-D:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 19, 2011 at 10:00 am
ALZDBA (8/19/2011)
That's the main reason why I +1-ed on both items.
Ditto
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 19, 2011 at 11:02 am
Evil Kraig F (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.I see it as the first step needed for ORM and RDBMS to start liking each other again.
Would ORM be
(a) Object Role Model,
(b) Object Relational Model,
(c) Obect Relational Mapping,
(d) Operational Risk Management,
(e) Ogc Reference Model,
(f) Online Reputation Management,
(g) Organisational Research Methodology,
(h) Something else (eg a Norse Dragon) ?
i suspect you meant (c), in which case I have to say that I hope ORM and RDBMS never get to like each other. I'm quite happy to have objects (with their classes becoming types recognised by the database language, and with the ability to define new types using inheritance whether single or multiple, and and all that that implies) as values in a database, although I'm not at all convinced that is will very often be the best way to do anything. But I can't swallow Object Relational Mapping as it is touted by its advocates - as a means of misusing a relational database to hold components of obect values that fit in with the the primitive datatype capabilities of pre-1992 SQL without any neccessity to extend the relational type system to recognise the objects' types.
I don't think there's any use in my saying what is wrong with ORM (in sense (c)). Others have said it far better than I can. For example thisappeared at seldo.com early in July 2010, followed in June this year by this[.
Tom
August 19, 2011 at 11:13 am
SQLRNNR (8/19/2011)
ALZDBA (8/19/2011)
That's the main reason why I +1-ed on both items.Ditto
Ditto too
Tom
August 19, 2011 at 11:17 am
Tom.Thomson (8/19/2011)
SQLRNNR (8/19/2011)
ALZDBA (8/19/2011)
That's the main reason why I +1-ed on both items.Ditto
Ditto too
+1 x 2
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 29,161 through 29,175 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply