Are the posted questions getting worse?
-
Just so you all know, you can't, at least not without nolock, query a table for row you just deleted within the same transaction. Not saying you should even try, but...
I hate when I space out on the 101's.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Jack Corbett (8/5/2011)
Stefan Krzywicki (8/5/2011)
GSquared (8/5/2011)
Stefan Krzywicki (8/5/2011)
GSquared (8/5/2011)
Stefan Krzywicki (8/5/2011)
I posted a question here as I don't want to immediately presume upon my participation in this thread to get answers. However, no-one has responded and as it is late on a Friday I'm hoping someone here will take pity on me and take a look.Basically what I need to know is, can non-pimary filegroups be toggled back and forth between read_write and read_only without consequence?
PANIC! DISASTER! (Insert Celkoesque disdainful comment here.) NO! TERRIBLE!
It violates something, somewhere, that's certain to result in the destruction of civilization as we know it. (Wait, that might be a good thing .... hold on a minute while I think that through ....)
Or you can look at my actual answer in the thread with the question. Either way. 😛
Awesome, thanks! I'm working on the algorithm for what will replace "civilization as we know it" and will make the change as soon as that's done.
Of course, all of this assumes we actually have some personal familiarity with civilization, which is dubious on this planet.
That's where the "as we know it" comes in. We're getting there, but it is a slow process.
What is this "civilization" thing you speak of? Is it a new type of sandwich?
Among other things, yes!
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
Jack Corbett (8/5/2011)
Just so you all know, you can't, at least not without nolock, query a table for row you just deleted within the same transaction. Not saying you should even try, but...I hate when I space out on the 101's.
Well, it IS Friday... : -)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
Gianluca Sartori (8/5/2011)
I'm officially out.I'll never, ever be an employee again.
I'll punch my timecard for the last time in 1 minute.
Congratulations. I hope consulting works out well for you.
I have to say that I NEVER use absolutes like Never or Last:-D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Jack Corbett (8/5/2011)
Just so you all know, you can't, at least not without nolock, query a table for row you just deleted within the same transaction. Not saying you should even try, but...And you can't with nolock either. Within the transaction you can see the table as it is after the delete, operations in one session never block other operations in the same session.
To see the row after it was deleted you'd need another session in snapshot isolation with a transaction that began before the delete began.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Stefan Krzywicki (8/5/2011)
That's where the "as we know it" comes in. We're getting there, but it is a slow process.Maybe in your neck of the woods. Down here I think people are trying very hard to bring back the dark ages.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
GilaMonster (8/5/2011)
Stefan Krzywicki (8/5/2011)
That's where the "as we know it" comes in. We're getting there, but it is a slow process.Maybe in your neck of the woods. Down here I think people are trying very hard to bring back the dark ages.
Oh, there are plenty of people here <I>trying</I> very hard to bring back the dark ages. Progress is made in spite of them. I find it remarkable, but it does keep happening.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
GilaMonster (8/5/2011)
Jack Corbett (8/5/2011)
Just so you all know, you can't, at least not without nolock, query a table for row you just deleted within the same transaction. Not saying you should even try, but...And you can't with nolock either. Within the transaction you can see the table as it is after the delete, operations in one session never block other operations in the same session.
To see the row after it was deleted you'd need another session in snapshot isolation with a transaction that began before the delete began.
Yes, you are right and I my ignorance is officially out there!:-P
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Stefan Krzywicki (8/5/2011)
GSquared (8/5/2011)
Stefan Krzywicki (8/5/2011)
GSquared (8/5/2011)
Stefan Krzywicki (8/5/2011)
I posted a question here as I don't want to immediately presume upon my participation in this thread to get answers. However, no-one has responded and as it is late on a Friday I'm hoping someone here will take pity on me and take a look.Basically what I need to know is, can non-pimary filegroups be toggled back and forth between read_write and read_only without consequence?
PANIC! DISASTER! (Insert Celkoesque disdainful comment here.) NO! TERRIBLE!
It violates something, somewhere, that's certain to result in the destruction of civilization as we know it. (Wait, that might be a good thing .... hold on a minute while I think that through ....)
Or you can look at my actual answer in the thread with the question. Either way. 😛
Awesome, thanks! I'm working on the algorithm for what will replace "civilization as we know it" and will make the change as soon as that's done.
Of course, all of this assumes we actually have some personal familiarity with civilization, which is dubious on this planet.
That's where the "as we know it" comes in. We're getting there, but it is a slow process.
Are you sure? I though recent progress was all in the opposite direction - bothe Britain (and rest or EU) and USA appear to be becoming more and more close to statist/fascistcommuniist (totalitarian, anyway, in whichever form) in their attitudes to the relationship between the citizen and the state.
I guess it depends on what you mean by civilisation - if it means having cities, as some would claim, why should we care about it at all - what's so great about cities?
L. Neil Smith's "Forge of the Elders" is an amusing piece of fiction, with its A[merican]SSR. Is that the way the USA is heading?
Tom
-
Jack Corbett (8/5/2011)
Just so you all know, you can't, at least not without nolock, query a table for row you just deleted within the same transaction. Not saying you should even try, but...I hate when I space out on the 101's.
So even the inside of a transaction can be not remotely declarative, but totally procedural, without including any nasty things like variables or non-deterministic functions.
I hate in when (T-)SQL fails elementary sanity tests. Doesn't worry me much when people expect it not to - in fact it rather encourages me.
Tom
-
A moment of Friday Humor...
Time to optimize, perhaps?
- Craig FarrellNever stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA -
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
What the heck is this supposed to to? :w00t:
-
Jack Corbett (8/5/2011)
What is this "civilization" thing you speak of? Is it a new type of sandwich?
I believe it's a video game...
-Ki
-
Gianluca Sartori (8/5/2011)
I'm officially out.I'll never, ever be an employee again.
I'll punch my timecard for the last time in 1 minute.
Good luck!!!!!
-Ki
-
That's got to be a new record!
Viewing 15 posts - 28,756 through 28,770 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply