January 31, 2016 at 1:34 pm
Jeff Moden (1/31/2016)
Hugo Kornelis (1/31/2016)
Jeff Moden (1/31/2016)
Hugo Kornelis (1/31/2016)
Ed Wagner (1/30/2016)
The articles and discussion on this site are top-notch.I am once more going to be contrary. But let me start with the positive: a lot of the articles over here, and all the ensuing discussions on the forums, are fantastic. But Steve has made the decision to present new content (almost) every day. And unless you have unlimited budget, that choice will always reflect on quality. On a site such as Simple Talk[/url], the overall quality of the articles is much higher than it is here. But that's easy to achieve for Tony (the editor of that site), because on that site the quality is prioritized over the quantity of new content. At this time, there are just 6 articles in all of January.
I personally prefer the type of choice made at Simple Talk over the choice made here. The requirement to have new content every day means that it's impossible to go through a full quality control process before publishing for all articles. And that sometimes does show in the content. Now the good news is that this will always be pointed out in the forums, including possible solutions, workarounds, and/or discussion on whether a perceived mistake is really a mistake. Always good to read. But unfortunately, I am 100% sure that most of the people who read an article on this site never click the link to the forums - so all those good additions and rectifications are never seen by the majority of the site visitors.
Gosh, with so many negative things to say about SSC, why do you post here?
Do not confuse criticism for negativity.
Not sure that I am. Is there anything that you like about SSC other than the "lot" of articles?
Oh, I like a lot. Most of all the forums - yes, I did say that a lot of people do not go there, but I do and I really like them.
Next, there are lots of articles that are actually great. That may not have been clear from my previous reply. But that is in fact one of the reasons why I dislike the exceptions so much. On a website where the overall quality is low, bad articles are no exception. But such a site will never get as many hits as a site as this. So perhaps I should have been clearer - the reason I dislike the lower-quality so much, is that they are published on a site with a (well-deserved) very good reputation, and a very high serarch engine rating. So on a casual search, articles on this site will pop up. Including the bad ones. And that's where I see a risk.
And as you probably are well aware, I also like the Question of the Day. Just by looking at the questions and attempting to answer, a lot of people are exposed to a lot of different aspects of SQL Server. And especially that section has a lot of really great discussion on the forums. True, the many people who post a simple "me too" or similar because they feel that they need to earn a point are a distraction, but not enough to stop me from subscribing to each and every QotD discussion.
I hope this is a better explanation. And trust me, if I didn't like the site, or didn't have confidence in it, I would not spend as much time here.
January 31, 2016 at 1:56 pm
Hmmm, that's strange. I got email notifications about new posts to a topic that I previously contributed to, but when I click the link I get an error message. And I cannot find the topic in the forum anymore.
Hi Hugo Kornelis,
A new reply has been added by Jeff Moden to a topic you're subscribed to.
You can view the reply by clicking the link below...
http://www.sqlservercentral.com/Forums/FindPost1757142.aspx
You can unsubscribe from topics at anytime from your control or the following link...
http://www.sqlservercentral.com/Forums/TopicSubscriptions1.aspx
You may need to manually copy & paste the URL into the address bar of your browser if the text above is not linked. Please watch for the URL wrapping onto 2 lines.
Does anyone know what happened?
January 31, 2016 at 2:02 pm
Hugo Kornelis (1/31/2016)
Hmmm, that's strange. I got email notifications about new posts to a topic that I previously contributed to, but when I click the link I get an error message. And I cannot find the topic in the forum anymore.Hi Hugo Kornelis,
A new reply has been added by Jeff Moden to a topic you're subscribed to.
You can view the reply by clicking the link below...
http://www.sqlservercentral.com/Forums/FindPost1757142.aspx
You can unsubscribe from topics at anytime from your control or the following link...
http://www.sqlservercentral.com/Forums/TopicSubscriptions1.aspx
You may need to manually copy & paste the URL into the address bar of your browser if the text above is not linked. Please watch for the URL wrapping onto 2 lines.
Does anyone know what happened?
http://www.sqlservercentral.com/Forums/FindPost1757152.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 31, 2016 at 7:51 pm
GilaMonster (1/30/2016)
Ed Wagner (1/29/2016)
Is it really that much better than SSMS intellsense? I'm asking because I don't know; not trying to start a riot.Oh, hell, yes. SSMS intellisense wastes more time than it saves due to its habits of autocorrecting strange things. SQLPrompt can be configured to activate when you want, not automatically, has some actual intelligence and saves me huge amounts of time.
That's before we get to the auto-format script, auto-insert ;, auto-qualify columns, find invalid objects in the entire database, find unused parameters/variables in the current script, etc
Ed,
What Gail said.
Two years ago, I blogged a product review of SQL Prompt 6.2 (they are up to 7.1 now). The link to that is here[/url].
It really is that good. And I was serious about the "use it for a month, and you'll gladly pay for it" part. Something that Gail didn't mention is the snippets - that is my favorite feature. Type something like "dt" and press tab, and it changes to "DROP TABLE". And you can add your own. I have a snippet for creating a dynamic tally table that I use all the time. Just type tally and press tab, and there's all the code for the dynamic tally table (and to reiterate - I did have to add this, but that is easy to do also).
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 31, 2016 at 7:56 pm
How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better... come on out to my session!)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 31, 2016 at 8:10 pm
WayneS (1/31/2016)
GilaMonster (1/30/2016)
Ed Wagner (1/29/2016)
Is it really that much better than SSMS intellsense? I'm asking because I don't know; not trying to start a riot.Oh, hell, yes. SSMS intellisense wastes more time than it saves due to its habits of autocorrecting strange things. SQLPrompt can be configured to activate when you want, not automatically, has some actual intelligence and saves me huge amounts of time.
That's before we get to the auto-format script, auto-insert ;, auto-qualify columns, find invalid objects in the entire database, find unused parameters/variables in the current script, etc
Ed,
What Gail said.
Two years ago, I blogged a product review of SQL Prompt 6.2 (they are up to 7.1 now). The link to that is here[/url].
It really is that good. And I was serious about the "use it for a month, and you'll gladly pay for it" part. Something that Gail didn't mention is the snippets - that is my favorite feature. Type something like "dt" and press tab, and it changes to "DROP TABLE". And you can add your own. I have a snippet for creating a dynamic tally table that I use all the time. Just type tally and press tab, and there's all the code for the dynamic tally table (and to reiterate - I did have to add this, but that is easy to do also).
Thank you Gail and Wayne. I think I'm going to download and install it tomorrow and give it a run for a month. The snippets sound promising and if it's better than SSMS intellisense with not adding all kinds of junk, then it will definitely be worth it.
January 31, 2016 at 8:17 pm
WayneS (1/31/2016)
How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better... come on out to my session!)
Yes, I'll be there. Jeff and I are driving in on Friday and would like to get together if the timing works for you. If I recall correctly, you have a story for me about a query that ran too fast. I'll even buy you a beer for it. 😉
February 1, 2016 at 1:33 am
Ed Wagner (1/31/2016)
WayneS (1/31/2016)
GilaMonster (1/30/2016)
Ed Wagner (1/29/2016)
Is it really that much better than SSMS intellsense? I'm asking because I don't know; not trying to start a riot.Oh, hell, yes. SSMS intellisense wastes more time than it saves due to its habits of autocorrecting strange things. SQLPrompt can be configured to activate when you want, not automatically, has some actual intelligence and saves me huge amounts of time.
That's before we get to the auto-format script, auto-insert ;, auto-qualify columns, find invalid objects in the entire database, find unused parameters/variables in the current script, etc
Ed,
What Gail said.
Two years ago, I blogged a product review of SQL Prompt 6.2 (they are up to 7.1 now). The link to that is here[/url].
It really is that good. And I was serious about the "use it for a month, and you'll gladly pay for it" part. Something that Gail didn't mention is the snippets - that is my favorite feature. Type something like "dt" and press tab, and it changes to "DROP TABLE". And you can add your own. I have a snippet for creating a dynamic tally table that I use all the time. Just type tally and press tab, and there's all the code for the dynamic tally table (and to reiterate - I did have to add this, but that is easy to do also).
Thank you Gail and Wayne. I think I'm going to download and install it tomorrow and give it a run for a month. The snippets sound promising and if it's better than SSMS intellisense with not adding all kinds of junk, then it will definitely be worth it.
Keep in mid that you'll spend a lot of time in the first week or two tweaking the settings to how you like them. Be sure to export them once done and save the settings file somewhere safe.
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
February 1, 2016 at 8:27 am
Ed Wagner (1/31/2016)
WayneS (1/31/2016)
How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better... come on out to my session!)Yes, I'll be there. Jeff and I are driving in on Friday and would like to get together if the timing works for you. If I recall correctly, you have a story for me about a query that ran too fast. I'll even buy you a beer for it. 😉
You all enjoy. I would have come, but need to be back here Sat night and didn't want a short trip, or two weekends in a row of travel.
February 1, 2016 at 8:35 am
Anyone? Although this looks to me like a case of 'give me the answer I want'.
http://www.sqlservercentral.com/Forums/Topic1757296-3411-1.aspx
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
February 1, 2016 at 8:48 am
GilaMonster (2/1/2016)
Anyone? Although this looks to me like a case of 'give me the answer I want'.http://www.sqlservercentral.com/Forums/Topic1757296-3411-1.aspx
Posted my 2¢.
_______________________________________________________________
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/
February 1, 2016 at 9:22 am
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
I was a bit muddled about what I was going to do when I was in my late teens; couldn't decide whether I wanted to do a degree in modern languages or maths. Eventually went for maths. After a degree and a research degree in maths, switched to computing in industry; thought about trying for a career in music, but decided to try for an academic carrer in computing instead. After a year back in academe, decided I would probably be happier in industry and stayed in computing in the computer industry for the next 39½ years.
Didn't get bored though - did all sorts of different things, always learning something new - that's why I stayed in computing.
Tom
February 1, 2016 at 9:29 am
Added my note. I hadn't considered the restore/dbcc/drop of databases on a dev machine. I've done this, but usually in places where I had an Enterprise agreement. I suspect, or believe, that this isn't allowed on Dev, unless you are doing a refresh for development, but it would be interesting to know what MS says.
Perhaps I should set up a fake environment and call them.
February 1, 2016 at 9:44 am
Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as I really don't want to call MS Licensing and sit on hold for half the day," instead of "give me the answer I want."
February 1, 2016 at 10:10 am
jasona.work (2/1/2016)
Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as I really don't want to call MS Licensing and sit on hold for half the day," instead of "give me the answer I want."
Well, the bottom line is that we're not Microsoft. They have the answer that matters.
Viewing 15 posts - 52,486 through 52,500 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply