April 4, 2017 at 1:04 pm
SQLRNNR - Tuesday, April 4, 2017 11:38 AMSo, in other news and because somebody is too quiet on the topic.This happened:
HOLY ****!
Congrats! I didn't see that. About time you got it all together... HA! Put that down. You can't hit me. I'll tell Jenn!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 4, 2017 at 2:21 pm
Grant Fritchey - Tuesday, April 4, 2017 1:04 PMSQLRNNR - Tuesday, April 4, 2017 11:38 AMSo, in other news and because somebody is too quiet on the topic.This happened:
HOLY ****!
Congrats! I didn't see that. About time you got it all together... HA! Put that down. You can't hit me. I'll tell Jenn!
It should be a huge relief for a few of us in that regard. No more physical abuse from this guy taking out his frustration on us. Sheesh.
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
April 5, 2017 at 1:18 am
WayneS - Tuesday, April 4, 2017 11:37 AM
Surprised it's taken this long. Well done Wayne!
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
April 5, 2017 at 1:56 am
WayneS - Tuesday, April 4, 2017 11:37 AM
Congratulations!!! Well done and well deserved!
π
April 5, 2017 at 2:43 am
rodjkidd - Tuesday, April 4, 2017 7:23 AMEirikur Eiriksson - Tuesday, April 4, 2017 7:20 AMrodjkidd - Tuesday, April 4, 2017 7:09 AMChrisM@Work - Tuesday, April 4, 2017 7:01 AMrodjkidd - Tuesday, April 4, 2017 6:50 AMChrisM@Work - Tuesday, April 4, 2017 6:45 AMThomasRushton - Tuesday, April 4, 2017 3:32 AMA new low... a new user, rather than posting a topic on one of the boards here, sent me a T-SQL question via PM...*sigh*
Just today to get through before SQLBits. Anyone else from here going to be there?
Not this year, got enough new stuff on my plate for a few months: getting to grips with configuring and troubleshooting transactional replication.
It's new to me, I'm a dev. One of the reasons I signed up as a permy with this company - the ample opportunities to learn (and own) aspects of SQL Server which I wouldn't normally get close to.Too bad Chris, seeing as I've managed to not meet up with you when I've popped into London!
have fun with replicationRodders...
We'll get those beers in one day Rodders, probably with the Icelandic reprobate in tow. I look forward to it π
Haha, indeed...
Talking of, he's being very quiet at the moment πRodders...
Trying desperately to make the time for this to happen, up to my neck at the moment.
πWell then, sorry to disturb you, Keep calm and Carry On, sir!
Rodders...
No worries, looking forward to it.
π
April 5, 2017 at 3:05 am
Has anyone looked into the security of the BPE? If so, please share on this thread
https://www.sqlservercentral.com/Forums/FindPost1869011.aspx
π
April 5, 2017 at 4:32 am
WayneS - Tuesday, April 4, 2017 11:37 AM
Congrats, Wayne. I owe you a drink sometime.
April 5, 2017 at 8:27 am
WayneS - Tuesday, April 4, 2017 11:37 AM
Congratulatios! I'm surprised you weren't an MVP already.
April 5, 2017 at 3:39 pm
Anyone else find it really frustrating when someone (with like <=5 points) posts an incomplete question, but you think "Yeah, I think I know what they want, but need a little clarification", and then you, or someone else has asks for it. Then, 48 hours later, although people have guessed, the OP never comes back... I mean, they probably went to Stack Overflow, and any other support site they could find, but some do peak my interest and other peoples insights are great for learning.
It's like reading a book, getting half way through and finding out the rest of the pages are blank. >_<
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 5, 2017 at 3:48 pm
Thom A - Wednesday, April 5, 2017 3:39 PMAnyone else find it really frustrating when someone (with like <=5 points) posts an incomplete question, but you think "Yeah, I think I know what they want, but need a little clarification", and then you, or someone else has asks for it. Then, 48 hours later, although people have guessed, the OP never comes back... I mean, they probably went to Stack Overflow, and any other support site they could find, but some do peak my interest and other peoples insights are great for learning.It's like reading a book, getting half way through and finding out the rest of the pages are blank. >_<
This happens enough that I have to ask for link.
April 5, 2017 at 4:23 pm
WayneS - Tuesday, April 4, 2017 11:37 AM
Absolutely awesome, ol' friend. Congratulations!
--Jeff Moden
Change is inevitable... Change for the better is not.
April 5, 2017 at 6:11 pm
Thom A - Wednesday, April 5, 2017 3:39 PMAnyone else find it really frustrating when someone (with like <=5 points) posts an incomplete question, but you think "Yeah, I think I know what they want, but need a little clarification", and then you, or someone else has asks for it. Then, 48 hours later, although people have guessed, the OP never comes back... I mean, they probably went to Stack Overflow, and any other support site they could find, but some do peak my interest and other peoples insights are great for learning.It's like reading a book, getting half way through and finding out the rest of the pages are blank. >_<
Rather annoying isn't it? :crazy:
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
April 5, 2017 at 8:59 pm
Grant Fritchey - Tuesday, March 28, 2017 4:25 AMHugo Kornelis - Tuesday, March 28, 2017 3:27 AMGrant Fritchey - Tuesday, March 28, 2017 3:00 AMLuis Cazares - Monday, March 27, 2017 11:58 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I've heard so many nice things about RedGate SQL Prompt that I'm afraid of asking for it to avoid losing it when changing jobs and fall into depression.
I am no longer able to type T-SQL without it.
Hmmm, not sure if I'd use that as a marketing slogan.
"SQL Prompt, the tool that makes you forget your basic skills""SQL Prompt, the tool so awesome it replaces your knowledge of T-SQL with bigger, better and more knowledge of T-SQL"
We'll just have to run a product warning too, something like what comes with Happy Fun Ball.
"SQL Prompt can cause permanent memory loss. Do not taunt SQL Prompt. If SQL Prompt begins to whine and emit smoke, seek shelter immediately..."
You jest, but having moved back to a coding position and not being allowed to use SQLPrompt for whatever reason, I just spent a couple hours tinkering with a stored procedure to recreate the ease of 'ssf', and then expanding the asterisk. Only to realize belatedly (after I got it working of course) that I could just right-click in Object Explorer, SELECT to another query window and copy/paste instead of feeding in servername/dbname/schema/table as parameters. Oh well, practiced my dynamic SQL for a bit, I guess.
can't use SSMSToolspack either, so I'm stuck with IntelligibleSense and Snippet Manager in SSMS for now.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
April 5, 2017 at 9:04 pm
drew.allen - Wednesday, March 29, 2017 11:11 AMBrainDonor - Tuesday, March 28, 2017 1:46 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I had SQL Prompt on my 2014 installation but had to re-install SQL Prompt after installing SSMS for 2016 and it was all fine.
I had it through my former employer, not on my personal computer. Buying a license for personal use isn't in my current budget.
Drew
SSMS toolspack, not the same, but awesome all the same
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
April 6, 2017 at 5:48 am
t they were a coupl e
Lynn Pettis - Wednesday, April 5, 2017 3:48 PMThom A - Wednesday, April 5, 2017 3:39 PMAnyone else find it really frustrating when someone (with like <=5 points) posts an incomplete question, but you think "Yeah, I think I know what they want, but need a little clarification", and then you, or someone else has asks for it. Then, 48 hours later, although people have guessed, the OP never comes back... I mean, they probably went to Stack Overflow, and any other support site they could find, but some do peak my interest and other peoples insights are great for learning.It's like reading a book, getting half way through and finding out the rest of the pages are blank. >_<
This happens enough that I have to ask for link.
Wasn't a particular topic, just that I seem to be noticing it more lately (maybe I hadn't been observant enough). Was browsing a couple of the forums and reading up on the answers and noticed a couple of examples, and just reminded me.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 15 posts - 58,006 through 58,020 (of 66,742 total)
You must be logged in to reply to this topic. Login to reply