June 14, 2016 at 7:08 am
Sometimes I just want to post RTFA(rticle).
People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the function or they don't know how to use it.
I'm not sure if it's frustration or lack of coffee, I'll be back.
June 14, 2016 at 7:26 am
Luis Cazares (6/14/2016)
Sometimes I just want to post RTFA(rticle).People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the function or they don't know how to use it.
I'm not sure if it's frustration or lack of coffee, I'll be back.
I pretty much did just that.
_______________________________________________________________
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/
June 14, 2016 at 7:26 am
insidesql - everyone have fun today.
Would like to be there...
SQL sat Manchester. Steve ( of the Hall not of the Jones π ) can't see me making that either!
This is turning into a bad year for events for me.
At this rate I may not make a SQL sat at all!
Cheers,
Rodders...
June 14, 2016 at 7:29 am
Sean Lange (6/14/2016)
Luis Cazares (6/14/2016)
Sometimes I just want to post RTFA(rticle).People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the function or they don't know how to use it.
I'm not sure if it's frustration or lack of coffee, I'll be back.
I pretty much did just that.
(S)He's asking you to do the work, Sean. Simple - quote your rate π
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
June 14, 2016 at 7:38 am
ChrisM@Work (6/14/2016)
Sean Lange (6/14/2016)
Luis Cazares (6/14/2016)
Sometimes I just want to post RTFA(rticle).People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the function or they don't know how to use it.
I'm not sure if it's frustration or lack of coffee, I'll be back.
I pretty much did just that.
(S)He's asking you to do the work, Sean. Simple - quote your rate π
Kingston earned that contract. I will let him have it. π
_______________________________________________________________
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/
June 14, 2016 at 7:41 am
Sean Lange (6/14/2016)
Luis Cazares (6/14/2016)
Sometimes I just want to post RTFA(rticle).People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the function or they don't know how to use it.
I'm not sure if it's frustration or lack of coffee, I'll be back.
I pretty much did just that.
No, you were too polite.
That thread was the one that wanted me to just put the acronym or the full words in all caps.
June 14, 2016 at 7:42 am
Sean Lange (6/14/2016)
Luis Cazares (6/14/2016)
Sometimes I just want to post RTFA(rticle).People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the function or they don't know how to use it.
I'm not sure if it's frustration or lack of coffee, I'll be back.
I pretty much did just that.
Well played.
I expect they'll be back, demanding to know why it's not working...
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 14, 2016 at 10:37 am
So, just got done converting some views and table-value functions over to stored procedures that I can use instead.
The TVFs and views are for security auditing, they're really just pre-written queries to pull who has what permissions / belongs to what role(s) and how sort of thing. The problem I had with them is, to satisfy the requirements I would have had to have created these views and TVFs in every database on the server.
Well, neither I nor the team I'm on "own" the databases, we just host them on the SQL we run. I wasn't going to willy-nilly add things to customer DBs. Now, I can stick the stored procedures in *MY* tools DB and run them from there to satisfy the various checks.
And dang all if I didn't have *fun* re-working these things...
π
June 14, 2016 at 10:43 am
jasona.work (6/14/2016)
So, just got done converting some views and table-value functions over to stored procedures that I can use instead.The TVFs and views are for security auditing, they're really just pre-written queries to pull who has what permissions / belongs to what role(s) and how sort of thing. The problem I had with them is, to satisfy the requirements I would have had to have created these views and TVFs in every database on the server.
Well, neither I nor the team I'm on "own" the databases, we just host them on the SQL we run. I wasn't going to willy-nilly add things to customer DBs. Now, I can stick the stored procedures in *MY* tools DB and run them from there to satisfy the various checks.
And dang all if I didn't have *fun* re-working these things...
π
There are reasons I love this job. Doing stuff like that is one of them.
June 14, 2016 at 6:01 pm
Brandie Tarvin (6/14/2016)
Now here's a case to watch[/url] for the U.S. vs European privacy issues.It'll be interesting to see what comes out of it.
Yes, that's definitely one to watch. But I don't think the us-government intervention will have much effect, unless the US government gives up it's quarrel with Mcrosoft as to whether it can require Microsoft in Ireland to break Irish laws and refuse to conform to Irish court judgements - an Irish court is perhaps unlikely to give any weight to the arguments of a body which is demanding that Irish law be breached by someone in Ireland who doesn't want to breach it.
Tom
June 15, 2016 at 2:19 pm
/me jiggles door handle...
/me knocks softly, tries to open door...
/me pokes head into room, quietly calls out "hello? Anybody here?"
/me leaves when no one answers...
Well, I guess the Brazilian and Swedish Beach Volleyball teams showed up and challenged everyone to a game...
June 15, 2016 at 3:46 pm
Sean Lange (6/14/2016)
Brandie Tarvin (6/14/2016)
Ed Wagner (6/14/2016)
BrainDonor (6/14/2016)
Brandie Tarvin (6/14/2016)
I am seriously considering removing my LinkedIn profile all of a sudden. I did not join to be marketed to. According to this article:Microsoft wants to use LinkedIn as a database of professional information and distribution channel for its software systems. LinkedIn gains additional financing and access to millions of people who could potentially join its network.
Let's face it, so many LinkedIn users tend to inundate all of their contacts with Facebook-type drivel, quizzes, life-enhancing documents and suchlike on a regular basis anyway, so will Microsoft's sales bumph really add much to it?
We don't know yet, but I guess we'll find out soon. I heard about the announcement on the news during yesterday's drive home and wasn't quite sure what to make of it. I know MS feels like it "missed the internet" and wants to be a big player in everything, but I don't know if this move makes sense to me. Then again, I'm not a CEO for a huge company.
I kind of feel like they're going to turn this into a huge data-mining operation and ignore what LinkedIn was originally set up for. I guess I can wait and see, but still... Not really sure about this one.
It really has just become a huge data mining operation for recruiters anyway. The only real difference I see is that MS will start pushing more and more. Such a cool idea for a community that just totally failed. Yet another example of a great idea that fell short as soon as people got involved. π
I do admire the sentiment, but let's be honest - this was ALWAYS the intent. The money is in charging the recruiters to find product that justifies their commissions, not in whatever paltry services they might offer to the individuals logging in who may or may not be actively looking for a job. We don't want to pay, so of course they are going to take advantage of the data we've given them. LinkedIn is just a bit more upfront about it recently, ever since Facebook went and threw the gauntlet down, declaring that we ultimately have no right to privacy.
We need to stop kidding ourselves that someone is going to give away stuff for free.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
June 15, 2016 at 4:10 pm
Brandie Tarvin (6/10/2016)
Steve Thompson-454462 (6/10/2016)
Brandie Tarvin (6/9/2016)
Y.B. (6/9/2016)
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
That is a good question. Where does one even start to look into NoSQL?
Again, seriously. Because I've pretty much ignored all the NoSQL stuff on account of not currently using it at work.
One way to explore this is to look at data sets that aren't necessarily relational. For example, event logs can be injected into Mongo pretty easily. Any data where you don't necessarily have a fixed schema on write is a good candidate; so maybe external data sources that you need to on-board.
Need to persisting payloads from API calls but parsing them on write to map them to your relational model is difficult/expensive? Again, Mongo is perfect for this.
If you're using a SQL Server column to store XML or (especially) JSON you may want to look into a non-relational document store (though it looks like 2016 has some nice JSON functionality).
Another example, might be using ElasticSearch for fuzzy/full-text searching (ES is really a document store under the hood).
If these data sets have keys that reference objects in your relational model, the data "joining" would be handled on read - so you need a middle tier that can handle it.
One plus for most NoSQL systems is that they are generally easier to scale horizontally than MS SQL, so if you have a system that is heavy on reads and needs scalability (e.g. a search engine), modeling that in something non-relational might be a win.
My org is keeping an open mind about NoSQL though all of our core systems remain firmly relational. We have committed heavily to ElasticSearch as our search engine.
Thanks for the reply.
I wonder... Our reporting team has a database where they essentially flatten all our data into giant tables so their reports read quicker. Would this be a candidate for a NoSQL solution?
Clustered ColumnStore (available in SQL Server 2014+) is good for very large flat tables. For denormalized tables with lots of repeatative text columns, I've seen it reduce both disk storage and query runtime by 90%. Your reporting team dump one of their full blown reports into a staging table and then create a clustered columnstore index on top of it. You'll see what I'm talking about.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2016 at 2:13 am
jasona.work (6/15/2016)
/me jiggles door handle.../me knocks softly, tries to open door...
/me pokes head into room, quietly calls out "hello? Anybody here?"
/me leaves when no one answers...
Is this you testing the water having got home late and drunk, Jason?
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
Viewing 15 posts - 54,586 through 54,600 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply