Are the posted questions getting worse?
-
Luis Cazares (8/18/2016)
Steve Jones - SSC Editor (8/18/2016)
Luis Cazares (8/18/2016)
We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)It's not a problem to find the packages, the problem is that I don't have Admin rights on the new laptop and can't install anything without approval through the company appstore.
At least I could recover my previous laptop and I'll use it for some time.
Well, at least you get to be productive. Get the paperwork submitted for them to finish your laptop and continue to work using the old one.
I can't believe you don't have admin rights on your local computer. That's going to tie your hands quite a bit.
-
BWFC (8/18/2016)
TomThomson (8/17/2016)
Three or four years ago they did reasonable breakfasts. Now the ones I know do absolutely rubbish breakfasts, the worst and most overpriced in town. There's a nice little pub just up the road from the local Wetherspoons where I am this month, and it does a good breakfast for a lot less than Wetherspoons charges for a not very good one; and it does an excellent large breakfast too, more eggs, more bacon, more sausage, more beans, more toast, and more tomato than Wetherspoons' standard breakfast and it costs quite a bit less too.I've never had a bad pint in a Wetherspoons. They're a bit McPub in that you can walk into one anywhere and know what you're going to get. Don't get me wrong, I'll pick the local 'independent' where I can but sometimes the choice of independent can be a bit limited. Up until recently, the only pub in Bury worth refuelling in during an extended sampling of refreshing beverages was the Wetherspoons.
I agree they are good on beer, although I'd like to see some decent heavy instead of nothing but bitter and lager, and always be able to find a mild instead of only a couple of times a year. But their food has really gone down the tubes over the last few years, and all but a couple of their options are overpriced (better quality version of the same dish can be had cheaper elsewhere).
Tom
-
Luis Cazares (8/18/2016)
Steve Jones - SSC Editor (8/18/2016)
Luis Cazares (8/18/2016)
We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)It's not a problem to find the packages, the problem is that I don't have Admin rights on the new laptop and can't install anything without approval through the company appstore.
At least I could recover my previous laptop and I'll use it for some time.
]
If you can get rights to get chocolatey working, it will run packages without admin rights 😉
-
I guess it's my turn in the proverbial barrel.
http://www.sqlservercentral.com/Forums/FindPost1810510.aspx
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
BLOB_EATER (8/18/2016)
jasona.work (8/17/2016)
Man, take a week and change off from here, and have a lot to catch up on...Forums being moved to a new back-end, cheap beer pubs with hair in the food...
At least my back-up DBA (who's an Oracle goddess) was able to keep the nitty-gritty caught up so I wasn't inundated when I got back to work today.
what is the new back-end??
This is the new back-end
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 -
Jeff Moden (8/18/2016)
I guess it's my turn in the proverbial barrel.For this, you wear the HAT OF SHAME.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
SQLRNNR (8/18/2016)
BLOB_EATER (8/18/2016)
jasona.work (8/17/2016)
Man, take a week and change off from here, and have a lot to catch up on...Forums being moved to a new back-end, cheap beer pubs with hair in the food...
At least my back-up DBA (who's an Oracle goddess) was able to keep the nitty-gritty caught up so I wasn't inundated when I got back to work today.
what is the new back-end??
This is the new back-end
:w00t:
-
Steve Jones - SSC Editor (8/18/2016)
Luis Cazares (8/18/2016)
We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)Chocolatey nuget, favourite snack of posh gits.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
ChrisM@Work (8/18/2016)
Brandie Tarvin (8/18/2016)
ThomasRushton (8/18/2016)
Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"erm...
SELECT GETDATE()Thanks Jeff! Without you, I would never have known that answer.
*cough*
Except the asker then said "no, I just want the date part, no time" And she's running on SQL2005, so no DATE. Bloody users, changing the requirements halfway through the project...
*cough*
SELECT CONVERT(DATETIME,CONVERT(CHAR(10),GETDATE(),101),101);
We have that happen all the time in our environment. EDIT: 101 is assuming you're using MM/DD/YYYY in your date formatting. Check BOL under CONVERT to get the code you need if that's not true. We used this in SQL 2000, 2005, etc. Still use it because bloody csv files that need dates formatted for other systems and legacy DATETIME columns that cannot be converted to DATE upon pain of being thrown in the lagoon with the alligator.
There's this too:
SELECT DATEADD(DAY,DATEDIFF(DAY,0,GETDATE()),0)Yes, I went with the dateadd/datediff option as being most portable. The joys of writing code that has to run everywhere...
Thomas Rushton
blog: https://thelonedba.wordpress.com -
ThomasRushton (8/19/2016)
ChrisM@Work (8/18/2016)
Brandie Tarvin (8/18/2016)
ThomasRushton (8/18/2016)
Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"erm...
SELECT GETDATE()Thanks Jeff! Without you, I would never have known that answer.
*cough*
Except the asker then said "no, I just want the date part, no time" And she's running on SQL2005, so no DATE. Bloody users, changing the requirements halfway through the project...
*cough*
SELECT CONVERT(DATETIME,CONVERT(CHAR(10),GETDATE(),101),101);
We have that happen all the time in our environment. EDIT: 101 is assuming you're using MM/DD/YYYY in your date formatting. Check BOL under CONVERT to get the code you need if that's not true. We used this in SQL 2000, 2005, etc. Still use it because bloody csv files that need dates formatted for other systems and legacy DATETIME columns that cannot be converted to DATE upon pain of being thrown in the lagoon with the alligator.
There's this too:
SELECT DATEADD(DAY,DATEDIFF(DAY,0,GETDATE()),0)Yes, I went with the dateadd/datediff option as being most portable. The joys of writing code that has to run everywhere...
Bah. Who needs portability?
😀
-
The Dixie Flatline (8/18/2016)
Jeff Moden (8/18/2016)
I guess it's my turn in the proverbial barrel.For this, you wear the HAT OF SHAME.
Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal as "pork chop". 😀
I don't understand why that person reacted that way when asked for a complete solution that folks could test. Maybe I need sensitivity training. :blink:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff Moden (8/19/2016)
The Dixie Flatline (8/18/2016)
Jeff Moden (8/18/2016)
I guess it's my turn in the proverbial barrel.For this, you wear the HAT OF SHAME.
Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal as "pork chop". 😀
I don't understand why that person reacted that way when asked for a complete solution that folks could test. Maybe I need sensitivity training. :blink:
Nope. That person needs to attend some skin thickening treatments. And kind of sad really that with as experience is claimed they can't seem to understand ctes or partitioning of window functions. :crying:
_______________________________________________________________
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/ -
Sean Lange (8/19/2016)
Jeff Moden (8/19/2016)
The Dixie Flatline (8/18/2016)
Jeff Moden (8/18/2016)
I guess it's my turn in the proverbial barrel.For this, you wear the HAT OF SHAME.
Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal as "pork chop". 😀
I don't understand why that person reacted that way when asked for a complete solution that folks could test. Maybe I need sensitivity training. :blink:
Nope. That person needs to attend some skin thickening treatments. And kind of sad really that with as experience is claimed they can't seem to understand ctes or partitioning of window functions. :crying:
I took a quick look at Jeff's code and I have to agree, it really isn't that complex. To understand the code, just run it in parts starting at the top to see what is piece is doing, not that difficult to do.
If Jeff doesn't mind I may try and use it for a quick session at the Colorado Springs SQL Server Users Group meeting, that is what I did this past Wednesday with that simple solution that the OP considered complex. This time, though, I will put the presentation together first rather than finding myself winging it when I though I had another week to work on the presentation.
-
And then we have people that think they can learn our job from a book.
-
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.blink
blinkblink
Ummmm, that's how I learned it. Books and a small PC and doing the exercises in the books. Does that make me a not-a-dba?
Viewing 15 posts - 55,396 through 55,410 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply