October 20, 2010 at 1:03 am
CirquedeSQLeil (10/19/2010)
I just had my rear windshield shot out as I was pulling into my driveway. Called the police to report it. They won't come out and investigate unless i have the casings. They want me to file the report online. How absolutely moronic is that?
Are you sure it wasn't a blackbird that missed your windshield ? :hehe:
Or a concrete pigeon that did a little dropping ? :Whistling:
Any students that didn't get approval because of a slow db / timeout ? :w00t:
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
October 20, 2010 at 6:37 am
ALZDBA (10/20/2010)
CirquedeSQLeil (10/19/2010)
I just had my rear windshield shot out as I was pulling into my driveway. Called the police to report it. They won't come out and investigate unless i have the casings. They want me to file the report online. How absolutely moronic is that?Are you sure it wasn't a blackbird that missed your windshield ? :hehe:
Or a concrete pigeon that did a little dropping ? :Whistling:
Any students that didn't get approval because of a slow db / timeout ? :w00t:
How fast was he backing into the drive? 😛
Pretty sad state this world is in when you have something like this happen.
Maybe you can find the the bullet. That should be as good as the casing.
Greg E
October 20, 2010 at 6:41 am
Alvin Ramard (10/19/2010)
jcrawf02 (10/19/2010)
I can see how you'd miss that, as it's in the third sentence, and that's WAY too much to read....:w00t::-P:-DMy input buffer filled up before I hit the end of the query. I aborted at that point.
Sounds like a security risk.
You should check and see if they've released a KB for that.
Greg E
October 20, 2010 at 7:57 am
ALZDBA (10/20/2010)
CirquedeSQLeil (10/19/2010)
I just had my rear windshield shot out as I was pulling into my driveway. Called the police to report it. They won't come out and investigate unless i have the casings. They want me to file the report online. How absolutely moronic is that?Are you sure it wasn't a blackbird that missed your windshield ? :hehe:
Or a concrete pigeon that did a little dropping ? :Whistling:
Any students that didn't get approval because of a slow db / timeout ? :w00t:
No feathers
No overpasses or structures above for the concrete pigeon
Students is a possibility.
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
October 20, 2010 at 8:36 am
Jeff Moden (10/19/2010)
Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
...The current SQL development model is to address a small number of main product features in each new major release. The downside to that is that the shiny new features introduced last time are unlikely to get much love in the following release (bug fixes and small impact enhancements only).
I'd agree. The improvements to features are slow to come. The engine stability, and speed seems to improve, but other features barely move at times. It took a number of evolutions for log shipping to improve, maintenance plans have hardly moved and still have bugs. MS doesn't seem to want to look back. I still see SSRS issues that have been around, even though the product gets lots more shiny new controls all the time.
I'd rather see improvements to Pivot and Unpivot. MS Access version of Pivot is the bee's-knees compared to SQL Server's Pivot.
That notwithstanding, how many of you use the "wonderful" new HierarchyID datatype?
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a "worst of both worlds" scenario.
- 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
October 20, 2010 at 8:40 am
Stefan Krzywicki (10/19/2010)
jcrawf02 (10/19/2010)
CirquedeSQLeil (10/19/2010)
jcrawf02 (10/19/2010)
...and, because I'm a complete and utter dork, it's almost 5, and I think it's funny, I'll repeat a poll I did at work today, assuming you guys will get it much faster.If I said something was "For the greater good", would you get the literary reference, and what do you think it was from?
Wrong answers I got were hilarious:
•Nine inch nails
•Utilitarianism
•A Greater Good (History 1998–2008), an album by Neuroticfish
•The Greater Good, the unifying philosophy of the Tau in the table-top wargame Warhammer 40,000
•STEVE Murray (supposed to be Bill Murray)
•Animal Farm
Xena Warrior Princess?
Damn, I defy anyone to top that.
The 1970s Buck Rodgers.
Harry Potter, actually, which is why it was so damn funny, people guessing real literature like Animal Farm. Surprised that I'm the biggest dork in the group.... :hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 20, 2010 at 9:04 am
GSquared (10/20/2010)
Jeff Moden (10/19/2010)
Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
...The current SQL development model is to address a small number of main product features in each new major release. The downside to that is that the shiny new features introduced last time are unlikely to get much love in the following release (bug fixes and small impact enhancements only).
I'd agree. The improvements to features are slow to come. The engine stability, and speed seems to improve, but other features barely move at times. It took a number of evolutions for log shipping to improve, maintenance plans have hardly moved and still have bugs. MS doesn't seem to want to look back. I still see SSRS issues that have been around, even though the product gets lots more shiny new controls all the time.
I'd rather see improvements to Pivot and Unpivot. MS Access version of Pivot is the bee's-knees compared to SQL Server's Pivot.
That notwithstanding, how many of you use the "wonderful" new HierarchyID datatype?
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a "worst of both worlds" scenario.
Dito.
And it only serves a single purpose. i.e. strict hierarchy.
Ever tried building a family tree ?
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
October 20, 2010 at 9:08 am
ALZDBA (10/20/2010)
GSquared (10/20/2010)
Jeff Moden (10/19/2010)
Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
...The current SQL development model is to address a small number of main product features in each new major release. The downside to that is that the shiny new features introduced last time are unlikely to get much love in the following release (bug fixes and small impact enhancements only).
I'd agree. The improvements to features are slow to come. The engine stability, and speed seems to improve, but other features barely move at times. It took a number of evolutions for log shipping to improve, maintenance plans have hardly moved and still have bugs. MS doesn't seem to want to look back. I still see SSRS issues that have been around, even though the product gets lots more shiny new controls all the time.
I'd rather see improvements to Pivot and Unpivot. MS Access version of Pivot is the bee's-knees compared to SQL Server's Pivot.
That notwithstanding, how many of you use the "wonderful" new HierarchyID datatype?
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a "worst of both worlds" scenario.
Dito.
And it only serves a single purpose. i.e. strict hierarchy.
Ever tried building a family tree ?
Actually, with a little fiddling, you should be able to do multiple roots and many to many parents, but it isn't easy and I haven't tested it yet as I don't see any benefits over the old way.
--------------------------------------
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
October 20, 2010 at 9:18 am
GSquared (10/20/2010)
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a "worst of both worlds" scenario.
HierarchyID certainly doesn't solve all problems, but it's hardly the 'worst of both worlds'. For graph problems that benefit from a materialized path representation, hierarchyid provides a robust and extremely compact implementation that reduces the need for custom coding. There is also a decent level of support within the query optimizer for it, which can produce exceptionally efficient plans for problems it is well-suited to. Itzik Ben-Gan covers it quite well in his 2008 T-SQL Querying book (pages 706 - 730). He covers Nested Sets in some detail straight afterward.
edit: The other nice thing about hierarchyid is that it is a CLR type - so .NET code can use it directly, either inside SQL Server or outside. Also, there are likely to be some important improvements to hierarchyid in Denali.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
October 20, 2010 at 9:27 am
Ugh, I'm always telling people the importance of documentation and I've just been bitten by it myself! I'd put together a fairly complex query to remove duplicates from a large table and today I needed to go back and check to work on finding an anomalie in the data and I didn't document the stored procedure! I have to go through the whole thing and figure out what it is doing at each step.
Fortunately, since I wrote it and it is well written 😉 I just have to read it and I remember what I was doing. It isn't taking too long, but what a good reminder that I should practice what I preach.
I'm taking this opportunity to document it!
--------------------------------------
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
October 20, 2010 at 9:38 am
Stefan Krzywicki (10/20/2010)
Ugh, I'm always telling people the importance of documentation and I've just been bitten by it myself! I'd put together a fairly complex query to remove duplicates from a large table and today I needed to go back and check to work on finding an anomalie in the data and I didn't document the stored procedure! I have to go through the whole thing and figure out what it is doing at each step.Fortunately, since I wrote it and it is well written 😉 I just have to read it and I remember what I was doing. It isn't taking too long, but what a good reminder that I should practice what I preach.
I'm taking this opportunity to document it!
Unbelievable 😉
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
October 20, 2010 at 10:00 am
Paul White NZ (10/20/2010)
GSquared (10/20/2010)
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a "worst of both worlds" scenario.HierarchyID certainly doesn't solve all problems, but it's hardly the 'worst of both worlds'. For graph problems that benefit from a materialized path representation, hierarchyid provides a robust and extremely compact implementation that reduces the need for custom coding. There is also a decent level of support within the query optimizer for it, which can produce exceptionally efficient plans for problems it is well-suited to. Itzik Ben-Gan covers it quite well in his 2008 T-SQL Querying book (pages 706 - 730). He covers Nested Sets in some detail straight afterward.
edit: The other nice thing about hierarchyid is that it is a CLR type - so .NET code can use it directly, either inside SQL Server or outside. Also, there are likely to be some important improvements to hierarchyid in Denali.
For very specialized purposes, it may have its place. That's true. But in every application I've tested it in thus far, for all the real-world scenarios I've had to handle, it's been worse than every other standard hierarchy implementation that I know of. I probably just haven't run into the specialized situations where it does a better job.
- 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
October 20, 2010 at 2:17 pm
Is it just because I'm in a bad mood today or why do I have the feeling that todays questions are more demanding with even less effort than on other days? Are we approaching any finals, so students are getting nervous?
http://www.sqlservercentral.com/Forums/FindPost1007977.aspx
http://www.sqlservercentral.com/Forums/FindPost1007434.aspx
Side note: did you find my reply on the first one being too harsh?
October 20, 2010 at 2:30 pm
LutzM (10/20/2010)
Is it just because I'm in a bad mood today or why do I have the feeling that todays questions are more demanding with even less effort than on other days? Are we approaching any finals, so students are getting nervous?http://www.sqlservercentral.com/Forums/FindPost1007977.aspx
http://www.sqlservercentral.com/Forums/FindPost1007434.aspx
Side note: did you find my reply on the first one being too harsh?
Actually, yeah, it was probably a little harsh, but hey, we're all human & I've dropped a bomb post or too in the past. You don't even want to see what it's like when our local Saint starts blasting people. All I can say is where full body armor & a cup...
"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 20, 2010 at 2:30 pm
For the second one, check out the thread over at SQLTeam with the same question.
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
Viewing 15 posts - 20,671 through 20,685 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply