Are the posted questions getting worse?
-
So, out Fri and Sat to help my kid work on his Eagle Scout project (finally). We went from this Fri:
to this by Sat afternoon:
Proud of his efforts, including managing people and making calls to get volunteers when some didn't show. A bit more work to finish, and a touch more fundraising needed, but I think he'll close out work on Wed or Thu evening. Depending on volunteers.
Now to try and motivate him to finish the last couple merit badges.
And let me body rest. Two days of physical labor was hard.
-
jasona.work (7/12/2016)
Maybe I should get off my butt and start a blog for commenting on things like this: SIEUFERDYet another wonder tool (so far only an academic project) to "simplify" querying a database. The article itself can't seem to make up its mind as to whether this is just an end-user front-end or a database itself (at least it read that way to me.) Certainly no mention of how "good" the queries it constructs behind the scenes are.
It uses the SQL-92 language for the queries, so no "optimized" or specialized operators in the various vendor-specific variants. Which likely means that while it can be used against almost any back-end RDBMS as-is, I'd bet the performance of the queries will be horrible, plus you'll end up with queries that murder the back-end RDBMs itself...
I love how casual the article is about bringing multiple data sources together. I guess they've never had to deal with legacy systems and having no easy way to relate data sources.
And their example of pulling back customer names is so cute!
-
Steve Jones - SSC Editor (7/12/2016)
So, out Fri and Sat to help my kid work on his Eagle Scout project (finally). We went from this Fri:
to this by Sat afternoon:
Proud of his efforts, including managing people and making calls to get volunteers when some didn't show. A bit more work to finish, and a touch more fundraising needed, but I think he'll close out work on Wed or Thu evening. Depending on volunteers.
Now to try and motivate him to finish the last couple merit badges.
And let me body rest. Two days of physical labor was hard.
Call me a city boy, well a suburban boy, what is it?
-
Steve Jones - SSC Editor (7/12/2016)
Now to try and motivate him to finish the last couple merit badges.Another challenge is getting them motivated to do the presentation to the council. It is such a simple thing to do yet I have seen so many boys struggle with this step.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
I was going to ask about the box to the side, but it looks like a livestock loading ramp.
-
Sean Lange (7/12/2016)
Jeff Moden (7/12/2016)
Brandie Tarvin (7/12/2016)
GAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHH!Last week before upgrade and the stupid IP addresses for my AGs and one of my sql instances aren't responding to pings.
Who has the porkchop launcher? Does it have enough velocity to send me into orbit around the sun? I could use the head clearing.
The new explosive-ram trebuchet model might do it for you. Be warned, though... I normal reserve it for hardcore ANSI/ISO-must-always-be-portable-code users so no guarantees that you'll come back in an unflattened state. 😛
Can I borrow that when you get it back?
/begin venting
I need it for our guy in marketing who has a new title "web application specialist", whatever that means. Yesterday at a meeting we were discussing the requirements for a new project they have cooked up. I told them the best way to implement this is an SSIS package and would take me 2-3 days. I said I would be happy to work on it as soon as we can get it on the schedule. I also let them know I don't set my schedule but with the current work load it would likely be 6-9 months at the earliest. This guy then asked what is SSIS. A reasonable question but it was followed up with "guess I need to start reading up on that so I can do it myself next week". Sure, no problem, go ahead and create an SSIS package with no oversight from anybody with any actual sql knowledge. This guy even said he can just use the production database to build it. Thankfully the IT manager and I are on the same page. He asked for access to sql to build the package. I applaud his zeal and desire to learn but just going cowboy developer style in production is not going to work out too well.
/end venting
Sean, I feel for you. I have a similar yet different issue. The person I am working with on a special character removal issue thinks he knows SQL but introduced several inconsistencies into the code I wrote as well as adding code that sort of worked to see if there was an index on a key (not primary key) column for the processing of data but it would find any index where this column was in whether indexed or just included.
-
It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The left ramp allows a wheelchair to get up and then a person to get onto a horse.
There are a few in Colorado, but none in Douglas County. We have two therapy/disabled riding facilities nearby, but this is access to the Hidden Mesa open space.
-
Steve Jones - SSC Editor (7/12/2016)
It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The left ramp allows a wheelchair to get up and then a person to get onto a horse.There are a few in Colorado, but none in Douglas County. We have two therapy/disabled riding facilities nearby, but this is access to the Hidden Mesa open space.
That is cool.
-
jasona.work (7/12/2016)
Maybe I should get off my butt and start a blog for commenting on things like this: SIEUFERDYet another wonder tool (so far only an academic project) to "simplify" querying a database. The article itself can't seem to make up its mind as to whether this is just an end-user front-end or a database itself (at least it read that way to me.) Certainly no mention of how "good" the queries it constructs behind the scenes are.
It uses the SQL-92 language for the queries, so no "optimized" or specialized operators in the various vendor-specific variants. Which likely means that while it can be used against almost any back-end RDBMS as-is, I'd bet the performance of the queries will be horrible, plus you'll end up with queries that murder the back-end RDBMs itself...
Read the article, sounds great in theory, but when they start putting that in front of gigabytes or terabytes of data, I don't see it being very performant.
-
Jeff Moden (7/12/2016)
Brandie Tarvin (7/12/2016)
GAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHH!Last week before upgrade and the stupid IP addresses for my AGs and one of my sql instances aren't responding to pings.
Who has the porkchop launcher? Does it have enough velocity to send me into orbit around the sun? I could use the head clearing.
The new explosive-ram trebuchet model might do it for you. Be warned, though... I normal reserve it for hardcore ANSI/ISO-must-always-be-portable-code users so no guarantees that you'll come back in an unflattened state. 😛
As long as I still have quantum tangibility, I'll be fine.
Send me the specs. I'll take a look. @=)
-
Steve Jones - SSC Editor (7/12/2016)
It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The left ramp allows a wheelchair to get up and then a person to get onto a horse.There are a few in Colorado, but none in Douglas County. We have two therapy/disabled riding facilities nearby, but this is access to the Hidden Mesa open space.
Very nice.
Thought it was a little fancy for a livestock ramp, not to mention why would that be a eagle scout project. :ermm:
Hope it serves well for many years, and the scout can obtain the goal.
-
Steve Jones - SSC Editor (7/12/2016)
It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The left ramp allows a wheelchair to get up and then a person to get onto a horse.There are a few in Colorado, but none in Douglas County. We have two therapy/disabled riding facilities nearby, but this is access to the Hidden Mesa open space.
Now that is a neat Eagle Scout project.
Are there plans to make the ramp concrete (seems that would be easier for wheelchairs), or will it stay as packed dirt?
Good luck on him finishing up, and let us know when he does. Then we can all make plans for the party @ Steve's ranch...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
WayneS (7/12/2016)
Steve Jones - SSC Editor (7/12/2016)
It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The left ramp allows a wheelchair to get up and then a person to get onto a horse.There are a few in Colorado, but none in Douglas County. We have two therapy/disabled riding facilities nearby, but this is access to the Hidden Mesa open space.
Now that is a neat Eagle Scout project.
Are there plans to make the ramp concrete (seems that would be easier for wheelchairs), or will it stay as packed dirt?
Good luck on him finishing up, and let us know when he does. Then we can all make plans for the party @ Steve's ranch...
Packed grade 6 roadbase for now. There's a couple others we modeled on, like this one, that are the same materials
Wheelchairs don't really go up in mud, but we don't get much here.
We'll turn this over to the county in a week or two (some minor finishing touches) and then let them manage it. They might give improvements to another scout in a few years if they need improvements.
-
Today's GAAAAAH.
That moment when you're checking off all your server upgrade list items and suddenly realize that SSRS is not cluster aware, nor is it installed on your failover servers.
DUH. :ermm:
-
ChrisM@Work (6/24/2016)
jasona.work (6/24/2016)
ChrisM@Work (6/24/2016)
Eirikur Eiriksson (6/24/2016)
Luis Cazares (6/24/2016)
I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news and I'm getting grumpy and sarcastic (more than usual).Nothing but happy news from Iceland these days 😀
😎
HEY YOU GUYS! ^^
I FOUND AN ISLAND!!
Yeah, but Iceland?
I mean, I'm sure it's a nice place and all, if you can deal with the occasional volcano, but I was thinking someplace where you could loaf around all day in a Speedo, year-round...
:hehe:
Yuk! 🙂
I've heard that the EU now has 1GB of free space.
hahahahaha
yuk yuk yuk
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
Viewing 15 posts - 54,931 through 54,945 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply