October 3, 2016 at 2:02 am
BLOB_EATER (10/3/2016)
ChrisM@Work (10/3/2016)
BLOB_EATER (9/30/2016)
Thanks to those that have given me advice! this is a great forum.So you and Mrs Blobby are talking to each other again? π
HAHA. that is actually her nick-name you know!
Either your mrs has a fantastic sense of humour or she's profoundly deaf!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 3, 2016 at 3:17 am
ChrisM@Work (10/3/2016)
BLOB_EATER (10/3/2016)
ChrisM@Work (10/3/2016)
BLOB_EATER (9/30/2016)
Thanks to those that have given me advice! this is a great forum.So you and Mrs Blobby are talking to each other again? π
HAHA. that is actually her nick-name you know!
Either your mrs has a fantastic sense of humour or she's profoundly deaf!
She's used to me. Last night she asked me why I was talking about CHECK DB in the shower.:hehe:
October 3, 2016 at 4:14 am
Hugo Kornelis (10/2/2016)
Eirikur Eiriksson (10/2/2016)
BLOB_EATER (10/2/2016)
Into my 19th hour for the weekend shift decided to google (Gone off bing) well know SQL Server people and found this (attached).... Im scared.Don't be scared of him, he's quite harmless:-D
π
In my experience that mostly depends on how you have set up your backup routines
Exactly!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 3, 2016 at 5:17 am
Grant Fritchey (10/3/2016)
Hugo Kornelis (10/2/2016)
Eirikur Eiriksson (10/2/2016)
BLOB_EATER (10/2/2016)
Into my 19th hour for the weekend shift decided to google (Gone off bing) well know SQL Server people and found this (attached).... Im scared.Don't be scared of him, he's quite harmless:-D
π
In my experience that mostly depends on how you have set up your backup routines
Exactly!
"Backups? We ain't got no Backups. We don't need no Backups. I don't have to show you any stinkin' Backups!"
π
Far away is close at hand in the images of elsewhere.
Anon.
October 3, 2016 at 6:24 am
WayneS (9/30/2016)
SQLRNNR (9/30/2016)
WayneS (9/30/2016)
GilaMonster (9/30/2016)
WayneS (9/30/2016)
Oh, what a fun day this is turning out to be. (Check out the attachment)Whaaaaaa???
How many sessions involved there?
666 sessions
This appears to be related to an auto-update stats kicking off.
had to fix the typo
ROFL
That is, without a doubt, the busiest deadlock graph I've ever seen. I guess it provides some perspective the next time I look at one in my environment.
October 3, 2016 at 7:50 am
Ed Wagner (10/3/2016)
WayneS (9/30/2016)
SQLRNNR (9/30/2016)
WayneS (9/30/2016)
GilaMonster (9/30/2016)
WayneS (9/30/2016)
Oh, what a fun day this is turning out to be. (Check out the attachment)Whaaaaaa???
How many sessions involved there?
666 sessions
This appears to be related to an auto-update stats kicking off.
had to fix the typo
ROFL
That is, without a doubt, the busiest deadlock graph I've ever seen. I guess it provides some perspective the next time I look at one in my environment.
666, what an appropriate number for something that is so evil...
October 3, 2016 at 8:27 am
Everyone's an expert. π http://www.sqlservercentral.com/Forums/Topic1822300-263-1.aspx
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
October 3, 2016 at 9:08 am
I don't know which is scarier: that the OP never considered simply adding the columns or that the OP needs to test to determine whether it would work?
Drew
http://www.sqlservercentral.com/Forums/Topic1821068-3740-2.aspx
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 3, 2016 at 9:44 am
Jeff Moden, great to finally meet you in Pittsburgh this past weekend! π
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
October 3, 2016 at 10:40 am
Ugh...
Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia that was trying to lure kids into the woods...
Well, someone is apparently playing the same "game" in my neck of the woods, one of the local news is reporting (and showing a picture) of one quite literally less than a mile from my house...
Now, it could be it's just someone "copy-catting" the harmless prank (the "let's dress up as a clown, stand somewhere at night so we look creepy and freak people out") rather than the "let's try to lure kids into the woods with us" bad person or the "let's dress up as a creepy clown and scope out the area before doing a little breaking and entering so we can claim if the cops show up we're just playing a prank on people)...
But still, it's not a reassuring thing to have on my mind...
October 3, 2016 at 11:00 am
jasona.work (10/3/2016)
Ugh...Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia that was trying to lure kids into the woods...
Well, someone is apparently playing the same "game" in my neck of the woods, one of the local news is reporting (and showing a picture) of one quite literally less than a mile from my house...
Now, it could be it's just someone "copy-catting" the harmless prank (the "let's dress up as a clown, stand somewhere at night so we look creepy and freak people out") rather than the "let's try to lure kids into the woods with us" bad person or the "let's dress up as a creepy clown and scope out the area before doing a little breaking and entering so we can claim if the cops show up we're just playing a prank on people)...
But still, it's not a reassuring thing to have on my mind...
Hopefully it's part of a big promotional campaign for Stephen King's It remake. I also hope that the moon is made out of cheese and there's a pot of gold at the end of the rainbow.
October 3, 2016 at 11:11 am
Luis Cazares (10/3/2016)
jasona.work (10/3/2016)
Ugh...Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia that was trying to lure kids into the woods...
Well, someone is apparently playing the same "game" in my neck of the woods, one of the local news is reporting (and showing a picture) of one quite literally less than a mile from my house...
Now, it could be it's just someone "copy-catting" the harmless prank (the "let's dress up as a clown, stand somewhere at night so we look creepy and freak people out") rather than the "let's try to lure kids into the woods with us" bad person or the "let's dress up as a creepy clown and scope out the area before doing a little breaking and entering so we can claim if the cops show up we're just playing a prank on people)...
But still, it's not a reassuring thing to have on my mind...
Hopefully it's part of a big promotional campaign for Stephen King's It remake. I also hope that the moon is made out of cheese and there's a pot of gold at the end of the rainbow.
I'll be happy with a unicorn that farts money, you can have the moon and the rainbow (just saw Deadpool on cable last night...)
As for the clown stuff, someone is, best case, going to have a very uncomfortable discussion with the police, worst case end up in the hospital...
October 3, 2016 at 11:15 am
jasona.work (10/3/2016)
Luis Cazares (10/3/2016)
jasona.work (10/3/2016)
Ugh...Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia that was trying to lure kids into the woods...
Well, someone is apparently playing the same "game" in my neck of the woods, one of the local news is reporting (and showing a picture) of one quite literally less than a mile from my house...
Now, it could be it's just someone "copy-catting" the harmless prank (the "let's dress up as a clown, stand somewhere at night so we look creepy and freak people out") rather than the "let's try to lure kids into the woods with us" bad person or the "let's dress up as a creepy clown and scope out the area before doing a little breaking and entering so we can claim if the cops show up we're just playing a prank on people)...
But still, it's not a reassuring thing to have on my mind...
Hopefully it's part of a big promotional campaign for Stephen King's It remake. I also hope that the moon is made out of cheese and there's a pot of gold at the end of the rainbow.
I'll be happy with a unicorn that farts money, you can have the moon and the rainbow (just saw Deadpool on cable last night...)
As for the clown stuff, someone is, best case, going to have a very uncomfortable discussion with the police, worst case end up in the hospital...
Or worse.
October 3, 2016 at 11:20 am
Luis Cazares (10/3/2016)
jasona.work (10/3/2016)
Ugh...Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia that was trying to lure kids into the woods...
Well, someone is apparently playing the same "game" in my neck of the woods, one of the local news is reporting (and showing a picture) of one quite literally less than a mile from my house...
Now, it could be it's just someone "copy-catting" the harmless prank (the "let's dress up as a clown, stand somewhere at night so we look creepy and freak people out") rather than the "let's try to lure kids into the woods with us" bad person or the "let's dress up as a creepy clown and scope out the area before doing a little breaking and entering so we can claim if the cops show up we're just playing a prank on people)...
But still, it's not a reassuring thing to have on my mind...
Hopefully it's part of a big promotional campaign for Stephen King's It remake. I also hope that the moon is made out of cheese and there's a pot of gold at the end of the rainbow.
Apparently 'New Line' has gone on the record to state that it's not them promoting the movie.
October 3, 2016 at 12:24 pm
Lynn Pettis (10/3/2016)
jasona.work (10/3/2016)
Luis Cazares (10/3/2016)
jasona.work (10/3/2016)
Ugh...Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia that was trying to lure kids into the woods...
Well, someone is apparently playing the same "game" in my neck of the woods, one of the local news is reporting (and showing a picture) of one quite literally less than a mile from my house...
Now, it could be it's just someone "copy-catting" the harmless prank (the "let's dress up as a clown, stand somewhere at night so we look creepy and freak people out") rather than the "let's try to lure kids into the woods with us" bad person or the "let's dress up as a creepy clown and scope out the area before doing a little breaking and entering so we can claim if the cops show up we're just playing a prank on people)...
But still, it's not a reassuring thing to have on my mind...
Hopefully it's part of a big promotional campaign for Stephen King's It remake. I also hope that the moon is made out of cheese and there's a pot of gold at the end of the rainbow.
I'll be happy with a unicorn that farts money, you can have the moon and the rainbow (just saw Deadpool on cable last night...)
As for the clown stuff, someone is, best case, going to have a very uncomfortable discussion with the police, worst case end up in the hospital...
Or worse.
Agreed - depending on who they try to lure, it could be significantly worse than the hospital.
Viewing 15 posts - 56,026 through 56,040 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply