November 14, 2011 at 12:17 pm
SQL Kiwi (11/14/2011)
No, not that one so much; the search I gave should bring up MERGE bugs on Connect like these:
Just seeing 353 hits is quite scary. I guess now I'll go through them all and see if they are real unfixed problems.
Tom
November 14, 2011 at 12:19 pm
Evil Kraig F (11/14/2011)
Sean Lange (11/14/2011)
And a good reminder that we can all use a refresher on from time to time.As others have said, let me know if I cross that line. As "threadizens" we should all let each other know when we cross that line so we can do our best to straighten it out.
Agreed, I've needed it on occasion when I'm not even trying to be that *** just getting frustrated that my point is either being ignored not not even heard. It happens.
Btw, hey, I'm back, I got ran over by the Flu Truck and there's still tread marks. Hopefully your father's doing better Remi, Normal Form will always be an odd duck discussion, I'm just glad people are even teaching it, and my favorite Myth: Jupiter wrote the first database in clay tablets. He didn't, it was Hermes. (Yes, I'm mixing them, 😛 )
The oldest form of data compression there is. Still works too.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 14, 2011 at 12:21 pm
L' Eomot Inversé (11/14/2011)
SQL Kiwi (11/14/2011)
No, not that one so much; the search I gave should bring up MERGE bugs on Connect like these:Just seeing 353 hits is quite scary. I guess now I'll go through them all and see if they are real unfixed problems.
Some are. Some aren't. Some are rare edge cases. A few are only on table variables, so haven't bit me yet (since I generally avoid those).
I've been using Merge, albeit not heavily, for quite a while without running into any of these yet.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 14, 2011 at 12:26 pm
SQLRNNR (11/14/2011)
Steve Jones - SSC Editor (11/14/2011)
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!+1, congrats
Danke
Herzlichen Glückwunsch! 😛
When did they start to allow solutions other than a single query?
(It's been a while since I decided to no longer participate in those challenges...)
November 14, 2011 at 1:06 pm
LutzM (11/14/2011)
SQLRNNR (11/14/2011)
Steve Jones - SSC Editor (11/14/2011)
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!+1, congrats
Danke
Herzlichen Glückwunsch! 😛
When did they start to allow solutions other than a single query?
(It's been a while since I decided to no longer participate in those challenges...)
They allowed it for this particular contest due to the nature. 😉
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
November 14, 2011 at 1:52 pm
Evil Kraig F (11/14/2011)
Sean Lange (11/14/2011)
And a good reminder that we can all use a refresher on from time to time.As others have said, let me know if I cross that line. As "threadizens" we should all let each other know when we cross that line so we can do our best to straighten it out.
Agreed, I've needed it on occasion when I'm not even trying to be that *** just getting frustrated that my point is either being ignored not not even heard. It happens.
Btw, hey, I'm back, I got ran over by the Flu Truck and there's still tread marks. Hopefully your father's doing better Remi, Normal Form will always be an odd duck discussion, I'm just glad people are even teaching it, and my favorite Myth: Jupiter wrote the first database in clay tablets. He didn't, it was Hermes. (Yes, I'm mixing them, 😛 )
Still waiting on a O.R. and date. It was supposed to be last friday but it got delayed.
November 14, 2011 at 1:54 pm
Hi, I'd like to upgrade from Coach.
Sir, that's insane.
I know!
20 000, 20K!
November 14, 2011 at 1:58 pm
Anyone knows this? Permissions to read sql log files?
http://www.sqlservercentral.com/Forums/Topic1205472-1550-1.aspx
November 14, 2011 at 2:33 pm
Ninja's_RGR'us (11/14/2011)
Anyone knows this? Permissions to read sql log files?http://www.sqlservercentral.com/Forums/Topic1205472-1550-1.aspx
Well they're text files on the drive, so regardless of SQL permissions, anyone with access to that folder can read them that way.
As for via T-SQL, seems to be securityadmin or sysadmin
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
November 14, 2011 at 4:04 pm
Hey folks, calling in backup on this one, I don't know what else to ask him to try to nail down the cause. It's a text file where the last row will not read into the target table.
http://www.sqlservercentral.com/Forums/Topic1205525-364-1.aspx?Update=1
Never 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
November 15, 2011 at 5:11 am
Guy missing 60 cpus! Don't know how to help.
http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx
November 15, 2011 at 5:27 am
Ninja's_RGR'us (11/15/2011)
Guy missing 60 cpus! Don't know how to help.http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx
Did he feed them after midnight or get water on them?
SET Snark = OFF;
November 15, 2011 at 5:31 am
Brandie Tarvin (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Guy missing 60 cpus! Don't know how to help.http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx
Did he feed them after midnight or get water on them?
SET Snark = OFF;
Don't know, there seem to be a slight language barrier and that doesn't help!
November 15, 2011 at 5:43 am
Brandie Tarvin (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Guy missing 60 cpus! Don't know how to help.http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx
Did he feed them after midnight or get water on them?
SET Snark = OFF;
SET SNARK = ON; -- might be better; or maybe you meant
SET BOOJUM = OFF; --? 😛
Remi can't count: with one machine showing 20 CPUs and another showing 40 when both should show 80 that's 100 that have softly and silently vanished away, not just 40.
And I can't help - apart from your licensing suggestion I haven't a clue what could be causing it.
Tom
November 15, 2011 at 5:46 am
L' Eomot Inversé (11/15/2011)
Brandie Tarvin (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Guy missing 60 cpus! Don't know how to help.http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx
Did he feed them after midnight or get water on them?
SET Snark = OFF;
SET SNARK = ON; -- might be better; or maybe you meant
SET BOOJUM = OFF; --? 😛
Remi can't count: with one machine showing 20 CPUs and another showing 40 when both should show 80 that's 100 that have softly and silently vanished away, not just 40.
And I can't help - apart from your licensing suggestion I haven't a clue what could be causing it.
Good point. My understanding is that he had issues with only 1 of the servers.:w00t:
Viewing 15 posts - 31,726 through 31,740 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply