March 14, 2016 at 3:00 pm
Phil Parkin (3/14/2016)
Brandie Tarvin (3/14/2016)
Steven.Grzybowski (3/14/2016)
Brandie Tarvin (3/14/2016)
Eirikur Eiriksson (3/12/2016)
Brandie Tarvin (3/11/2016)
What a wonderfulStill not sure if I like Data Tools or not. It seems very sensitive to every little click of the mouse. And heaven forbid if I try to move a container a quarter inch down. Because suddenly the package window increases by 200% and the container is so far away from the other containers that I can't see everything on one screen anymore.
Grrr.
If you hit the little arrow to minimize/roll up the container, they seem to move without any issues.
But the issue is more than just the containers. If I group grab a bunch of tasks, Data Tools seems insistent on moving them down a mile (I can't seem to move them back up, the more I try, the further down they go) and the font changes have messed up all my annotation boxes and the tasks so that everything is on top of each other and I can't read anything unless I try to adjust sizes.
And if I try to adjust borders, things widen impossibly big or cover up other items.
I really am beginning to hate Data Tools.
I hate that too. I'd suggest that you stick to the FORMAT menu options and, ideally, just use Auto Layout after getting your sizing correct.
If you do need to move stuff around manually, for small changes try using the keyboard (CTRL & arrow keys) rather than the mouse (after selecting the objects to move, of course).
I hate how data tools does that as well. I agree on the keyboard shortcuts.
I found that after getting the move started with the keyboard, then the mouse generally works better (without jumping a mile).
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
March 14, 2016 at 11:48 pm
Brandie Tarvin (3/14/2016)
Eirikur Eiriksson (3/12/2016)
Brandie Tarvin (3/11/2016)
What a wonderful day in the upgrade-hood...Sigh.
So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:
Baggages?
😎
😛
Still not sure if I like Data Tools or not. It seems very sensitive to every little click of the mouse. And heaven forbid if I try to move a container a quarter inch down. Because suddenly the package window increases by 200% and the container is so far away from the other containers that I can't see everything on one screen anymore.
Grrr.
The UI and it's behaviour leaves a bit to be desired, still prefer it to the older BIDS.
😎
March 15, 2016 at 3:49 am
Eirikur Eiriksson (3/14/2016)
Brandie Tarvin (3/14/2016)
Eirikur Eiriksson (3/12/2016)
Brandie Tarvin (3/11/2016)
What a wonderful day in the upgrade-hood...Sigh.
So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:
Baggages?
😎
😛
Still not sure if I like Data Tools or not. It seems very sensitive to every little click of the mouse. And heaven forbid if I try to move a container a quarter inch down. Because suddenly the package window increases by 200% and the container is so far away from the other containers that I can't see everything on one screen anymore.
Grrr.
The UI and it's behaviour leaves a bit to be desired, still prefer it to the older BIDS.
😎
I don't. Every time I try to close a solution or open a new solution in place of the current one, Data Tools crashes on me.
And now I'm getting weird errors when trying to read or post on SSC. Because it can't find the post in question.
March 15, 2016 at 3:51 am
In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working supported solution?
March 15, 2016 at 4:02 am
Brandie Tarvin (3/15/2016)
In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working supported solution?
I find it more odd that a 'Recovery Expert' would repeatedly suggest nonsensical things.
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
March 15, 2016 at 4:05 am
GilaMonster (3/15/2016)
Brandie Tarvin (3/15/2016)
In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working supported solution?I find it more odd that a 'Recovery Expert' would repeatedly suggest nonsensical things.
Yup that "Recovery expert" tag needs to go.... Only a few people in the world deserve that tag.
March 15, 2016 at 5:06 am
GilaMonster (3/15/2016)
Brandie Tarvin (3/15/2016)
In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working supported solution?I find it more odd that a 'Recovery Expert' would repeatedly suggest nonsensical things.
Like telling someone to drop a filegroup they already posted they couldn't drop? Where's that "answers getting worse" thread again? 😉
March 15, 2016 at 5:32 am
Ed Wagner (3/15/2016)
GilaMonster (3/15/2016)
Brandie Tarvin (3/15/2016)
In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working supported solution?I find it more odd that a 'Recovery Expert' would repeatedly suggest nonsensical things.
Like telling someone to drop a filegroup they already posted they couldn't drop? Where's that "answers getting worse" thread again? 😉
More the last one. Add a file to a filegroup that's offline, then shrink a file that's not there to move its data into the newly added file, then drop the filegroup that's offline and hence can't be dropped.
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
March 15, 2016 at 5:40 am
GilaMonster (3/15/2016)
Ed Wagner (3/15/2016)
GilaMonster (3/15/2016)
Brandie Tarvin (3/15/2016)
In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working supported solution?I find it more odd that a 'Recovery Expert' would repeatedly suggest nonsensical things.
Like telling someone to drop a filegroup they already posted they couldn't drop? Where's that "answers getting worse" thread again? 😉
More the last one. Add a file to a filegroup that's offline, then shrink a file that's not there to move its data into the newly added file, then drop the filegroup that's offline and hence can't be dropped.
I don't think he bothered to read the actual scenario. He just saw the title and the first sentence or two and assumed he knew what the solution was (and probably wondered why no one else was "smart enough" to post it).
March 15, 2016 at 6:47 am
March 15, 2016 at 7:00 am
jasona.work (3/15/2016)
Is this the end?Will Jeff Moden be able to stop work on his string splitter??
Will Batman be able to get rid of the bomb before it blows up?!?!
Tune in next week!
https://www.brentozar.com/archive/2016/03/splitting-strings-sql-server-2016-rescue/[/url]
😎
hehe apparently you are not following the comments on Jeff's article. Start here and you decide if his work will end.
http://www.sqlservercentral.com/Forums/FindPost1768675.aspx
_______________________________________________________________
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/
March 15, 2016 at 7:04 am
jasona.work (3/15/2016)
Is this the end?Will Jeff Moden be able to stop work on his string splitter??
Will Batman be able to get rid of the bomb before it blows up?!?!
Tune in next week!
https://www.brentozar.com/archive/2016/03/splitting-strings-sql-server-2016-rescue/[/url]
😎
Performance testing is underway, albeit not by me because I don't have a SQL 2016 to play around with. :crying: There are also a couple of connect items open on it already and the Tally Oh! thread has recent debate on relational theory. One downside is that it doesn't have ItemNumber, but that can be added into the parent query if needed, which is frequently is.
I'm super-interested to see how it performs against DS8K or DS8K_Lead.
March 15, 2016 at 7:37 am
Have I been reasonable with this guy? He crops up fairly regularly and is quite obviously well out of his depth - but I don't see a huge amount of effort on his part to learn. I'm willing to help - as are others of course - but I'd like to encourage him to take up the baton rather than simply increase the size of the existing pile of stuff. Feel free to criticize my post if you think it might give him that wee nudge that I think he needs.
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
March 15, 2016 at 7:59 am
Sean Lange (3/15/2016)
jasona.work (3/15/2016)
Is this the end?Will Jeff Moden be able to stop work on his string splitter??
Will Batman be able to get rid of the bomb before it blows up?!?!
Tune in next week!
https://www.brentozar.com/archive/2016/03/splitting-strings-sql-server-2016-rescue/[/url]
😎
hehe apparently you are not following the comments on Jeff's article. Start here and you decide if his work will end.
Whoo! That was *fun* to read (and I don't mean that sarcastically)
And it all boiled down to (it seems) does this: '' represent a NULL or an empty string?
And yeah, based on that discussion, I don't think Jeff's 8k splitter is going to be consigned to the dust heap of history any time soon...
March 15, 2016 at 8:17 am
ChrisM@Work (3/15/2016)
Have I been reasonable with this guy? He crops up fairly regularly and is quite obviously well out of his depth - but I don't see a huge amount of effort on his part to learn. I'm willing to help - as are others of course - but I'd like to encourage him to take up the baton rather than simply increase the size of the existing pile of stuff. Feel free to criticize my post if you think it might give him that wee nudge that I think he needs.
On the contrary. I think you were far gentler and nicer than I would have been. That code is an absolute train wreck for what appears to be something relatively simple. He needs to either put on his big boy pants or spend the rest of his career in the kiddie pool.
_______________________________________________________________
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/
Viewing 15 posts - 53,041 through 53,055 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply