September 28, 2017 at 10:47 am
Sean Lange - Thursday, September 28, 2017 10:41 AMjasona.work - Thursday, September 28, 2017 10:28 AMSean Lange - Thursday, September 28, 2017 9:57 AMWoohoo. And just a few weeks after we have finally migrated the last of our production databases off of 2005. Sadly we only upgraded to 2014 but hey at least our production databases are at least using a currently supported version. :crazy:Don't feel too bad, I'm *almost* done getting all my servers off 2008R2 to 2014.
I had someone ask me yesterday when we'd be going to 2017, my answer was "only when someone comes to me and says there's this really neat new feature in 2017 that we just HAVE to have!"
Then it'll probably still be 6-9 months just to get the server stood up and installed, another several months (or more) to get SSMS17 approved for use on our network, plus a couple months for the desktop people to figure out how to install it, get that approved and tested...The biggest win is that we are no longer replicating data from our flat file data source from the AS400 to sql server. We couldn't even use sql server replication, we instead had to use a third party replication tool designed for replicating that type of data.
Heh
One of my customers still pulls in data, in flat files, from a mainframe...
September 28, 2017 at 10:49 am
The upcoming PASS conference in Seattle this November will be my first. Looking at the line-up of presentation topics and speakers; I can tell it's going to be a great year to attend.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 28, 2017 at 10:59 am
Lynn Pettis - Thursday, September 28, 2017 10:44 AMEric M Russell - Thursday, September 28, 2017 10:42 AMAll you guys with SQL Server 2014 certification listed on your resume; you're like 2 releases behind already. Try to keep up. 😉We are still on SQL Server 2012. Not looking at upgrading at the moment, but hoping to soon.
We're currently running on scores of 2008 / 2008 R2 / 2012 / 2014 / 2016 / Azure instances. Also a handful of SQL Server 2005 instances supporing a vendor app about to be pushed under a bus. OK, that's just production. Across DEV, QA, and PROD; it's a couple hundred servers. I'm sure at this very moment someone is installing both Linux and 2017 on a development server.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 28, 2017 at 11:01 am
Eric M Russell - Thursday, September 28, 2017 10:49 AMThe upcoming PASS conference in Seattle this November will be my first. Looking at the line-up of presentation topics and speakers; I can tell it's going to be a great year to attend.
Wish I could go, finances just aren't there. I enjoyed PASS 2015. Have fun!
September 28, 2017 at 11:18 am
September 28, 2017 at 11:21 am
Summer90 - Thursday, September 28, 2017 11:18 AM
Didn't have much to say on this I take 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/
September 28, 2017 at 11:39 am
jasona.work - Thursday, September 28, 2017 10:47 AMHeh
One of my customers still pulls in data, in flat files, from a mainframe...
Shush, you weren't meant to tell anyone we're still doing that!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 1:44 pm
Thom A - Thursday, September 28, 2017 11:39 AMjasona.work - Thursday, September 28, 2017 10:47 AMHeh
One of my customers still pulls in data, in flat files, from a mainframe...Shush, you weren't meant to tell anyone we're still doing that!
So I shouldn't mention the data getting loaded in from flat files that are sent in a weird compressed format that takes a custom archive application to uncompress them and stick them back together in multiple SQL Agent job steps?
September 28, 2017 at 2:04 pm
jasona.work - Thursday, September 28, 2017 1:44 PMThom A - Thursday, September 28, 2017 11:39 AMjasona.work - Thursday, September 28, 2017 10:47 AMHeh
One of my customers still pulls in data, in flat files, from a mainframe...Shush, you weren't meant to tell anyone we're still doing that!
So I shouldn't mention the data getting loaded in from flat files that are sent in a weird compressed format that takes a custom archive application to uncompress them and stick them back together in multiple SQL Agent job steps?
But just think of all the disk space they've been saving. Back in 1987 when the export process was created, it was like $50,000 per GB on the mainframe, and the developer's PC only had a 10 MB hard disk.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 28, 2017 at 2:35 pm
jasona.work - Thursday, September 28, 2017 1:44 PMThom A - Thursday, September 28, 2017 11:39 AMjasona.work - Thursday, September 28, 2017 10:47 AMHeh
One of my customers still pulls in data, in flat files, from a mainframe...Shush, you weren't meant to tell anyone we're still doing that!
So I shouldn't mention the data getting loaded in from flat files that are sent in a weird compressed format that takes a custom archive application to uncompress them and stick them back together in multiple SQL Agent job steps?
You are actually almost quoting how one of my systems at the office works (replace SQL Agent with BULK INSERT)... I'm not sure if to be worried or upset at the fact that that's how it works still in 2017. :crying:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 4:07 pm
jasona.work - Thursday, September 28, 2017 10:47 AMSean Lange - Thursday, September 28, 2017 10:41 AMjasona.work - Thursday, September 28, 2017 10:28 AMSean Lange - Thursday, September 28, 2017 9:57 AMWoohoo. And just a few weeks after we have finally migrated the last of our production databases off of 2005. Sadly we only upgraded to 2014 but hey at least our production databases are at least using a currently supported version. :crazy:Don't feel too bad, I'm *almost* done getting all my servers off 2008R2 to 2014.
I had someone ask me yesterday when we'd be going to 2017, my answer was "only when someone comes to me and says there's this really neat new feature in 2017 that we just HAVE to have!"
Then it'll probably still be 6-9 months just to get the server stood up and installed, another several months (or more) to get SSMS17 approved for use on our network, plus a couple months for the desktop people to figure out how to install it, get that approved and tested...The biggest win is that we are no longer replicating data from our flat file data source from the AS400 to sql server. We couldn't even use sql server replication, we instead had to use a third party replication tool designed for replicating that type of data.
Heh
One of my customers still pulls in data, in flat files, from a mainframe...
Heh... well, at least its not some tag delimited atrocity like XML, JSON, etc. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2017 at 4:09 pm
jasona.work - Thursday, September 28, 2017 1:44 PMThom A - Thursday, September 28, 2017 11:39 AMjasona.work - Thursday, September 28, 2017 10:47 AMHeh
One of my customers still pulls in data, in flat files, from a mainframe...Shush, you weren't meant to tell anyone we're still doing that!
So I shouldn't mention the data getting loaded in from flat files that are sent in a weird compressed format that takes a custom archive application to uncompress them and stick them back together in multiple SQL Agent job steps?
Heh... almost as bad as XML, then. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2017 at 5:07 pm
The Data Tuning Adviser is going to recommend columnstore indexes for me? October 2nd can't come soon enough! </sarcasm>
It's cool to finally see some new T-SQL commands. TRIM and CONCAT_WS are not game changers but I was excited about STRING_AGG and TRANSLATE. Unfortunately, as was the case with string_split, STRING_AGG and TRANSLATE were poorly implemented IMHO.
I've been using 2017 SSMS for a while and I have seen some cool changes to the execution plans.
-- Itzik Ben-Gan 2001
September 28, 2017 at 6:05 pm
Alan.B - Thursday, September 28, 2017 5:07 PMThe Data Tuning Adviser is going to recommend columnstore indexes for me? October 2nd can't come soon enough! </sarcasm>It's cool to finally see some new T-SQL commands. TRIM and CONCAT_WS are not game changers but I was excited about STRING_AGG and TRANSLATE. Unfortunately, as was the case with string_split, STRING_AGG and TRANSLATE were poorly implemented IMHO.
I've been using 2017 SSMS for a while and I have seen some cool changes to the execution plans.
Really?... STRING_AGG (or at least the functionality) has been a wish list for quite awhile now. I hate XML and I always feel a bit "unclean" every time I use FOR XML PATH('').
Is it not as fast as XML (or JSON)?
September 28, 2017 at 9:43 pm
Jason A. Long - Thursday, September 28, 2017 6:05 PMAlan.B - Thursday, September 28, 2017 5:07 PMThe Data Tuning Adviser is going to recommend columnstore indexes for me? October 2nd can't come soon enough! </sarcasm>It's cool to finally see some new T-SQL commands. TRIM and CONCAT_WS are not game changers but I was excited about STRING_AGG and TRANSLATE. Unfortunately, as was the case with string_split, STRING_AGG and TRANSLATE were poorly implemented IMHO.
I've been using 2017 SSMS for a while and I have seen some cool changes to the execution plans.
Really?... STRING_AGG (or at least the functionality) has been a wish list for quite awhile now. I hate XML and I always feel a bit "unclean" every time I use FOR XML PATH('').
Is it not as fast as XML (or JSON)?
I don't like XML concatenation at all and was very happy to hear about STRING_AGG; it was actually the first thing I played around with after installing 2017.
It's a is a HUGE improvement, don't get me wrong. I work with Redshift (postgresql) and it's STRING_AGG has DISTINCT. In SQL server you
have to do this:
SELECT csv = STRING_AGG(token,',')
FROM
( SELECT DISTINCT token
FROM dbo.ngrams8k('aabbcc', 1)
) ng(token);
..which all of a sudden is not much prettier than:
SELECT csv = STUFF(
( SELECT DISTINCT ','+token
FROM dbo.ngrams8k('aabbcc', 1)
FOR XML PATH('')),1,1,'');
With STRING_AGG I can guarantee I get the rows in the order I want using WITHIN GROUP: SELECT csv = STRING_AGG(token,',') WITHIN GROUP (ORDER BY position)
FROM dbo.ngrams8k('abc', 1);
Without STRING_AGG DISTINCT, however, I can't figure out how I would return a distinct concatenated set in the order I want? E.g. how do I get this to work?SELECT csv = STRING_AGG(token,',') WITHIN GROUP (ORDER BY position)
FROM
( SELECT DISTINCT token
FROM dbo.ngrams8k('aabbcc', 1)
) ng(token);
Again - I'm very happy to see it, "poorly implemented" was not a good choice of words for STRING_AGG.
-- Itzik Ben-Gan 2001
Viewing 15 posts - 16 through 30 (of 32 total)
You must be logged in to reply to this topic. Login to reply