September 13, 2016 at 8:09 am
I'm around 10,000 a month, give or take. I think that's about 300+ a day on week days. I know the big SQL Server bloggers like Brent or Paul & Kim, get considerably more than that. Don't sweat the numbers. Concentrate on consistency, generating material regularly so that those who do read it, come back for more. Also, regular posting makes you show up more on search engines. It's the search engines that bring you the numbers. That's why so many people spend most of their time attempting to game the search engines. I'm far too lazy for that. I just keep writing the stuff that interests me. Some of it works for the search engines, some doesn't.
"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
September 13, 2016 at 8:12 am
Phil Parkin (9/13/2016)
GilaMonster (9/13/2016)
~300-500 per day, except weekends.iirc I suggested ignoring blog stats initially...
I'm sure at least 1% of your traffic is me repeatedly reading your 'CATCH ALL QUERIES' post 😀
Count me another 1%. I refer others to that page daily. 😀
_______________________________________________________________
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 13, 2016 at 8:21 am
BLOB_EATER (9/13/2016)
Anyone willing to share general stats on their blogs. ( Or is this a rude request??!)I have received 1000 views within the past 6 months which is poor ( but expected as Im quite new).. I am just trying to understand the sort of view hit the elite bloggers get... i.e. the MVPs / MCMs of this world. I'm guessing you guys hit many many many thousands over the month??
I get precisely zero hits. In fact, I've never gotten a hit on one of my blogs. I strongly suspect that it's because I don't have a blog. 😀
Rather than trying to build up a reputation on a blog or taking the time to make regular entries or maintain a blog, I just post on and write articles on (way behind on that) on SQL Server Central where readership has already been established. It's not for everyone but it works for me.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 13, 2016 at 8:21 am
Grant Fritchey (9/13/2016)
I'm around 10,000 a month, give or take. I think that's about 300+ a day on week days. I know the big SQL Server bloggers like Brent or Paul & Kim, get considerably more than that. Don't sweat the numbers. Concentrate on consistency, generating material regularly so that those who do read it, come back for more. Also, regular posting makes you show up more on search engines. It's the search engines that bring you the numbers. That's why so many people spend most of their time attempting to game the search engines. I'm far too lazy for that. I just keep writing the stuff that interests me. Some of it works for the search engines, some doesn't.
Excuse my lack of understanding but what do you mean by game the search engines?
September 13, 2016 at 8:24 am
Jeff Moden (9/13/2016)
BLOB_EATER (9/13/2016)
Anyone willing to share general stats on their blogs. ( Or is this a rude request??!)I have received 1000 views within the past 6 months which is poor ( but expected as Im quite new).. I am just trying to understand the sort of view hit the elite bloggers get... i.e. the MVPs / MCMs of this world. I'm guessing you guys hit many many many thousands over the month??
I get precisely zero hits. In fact, I've never gotten a hit on one of my blogs. I strongly suspect that it's because I don't have a blog. 😀
Rather than trying to build up a reputation on a blog or taking the time to make regular entries or maintain a blog, I just post on and write articles on (way behind on that) on SQL Server Central where readership has already been established. It's not for everyone but it works for me.
Funny you say that because this is what is currently on my mind. I struggle to do both, I have done 5 articles on SSC within the last 12 months and was going to a 6th one on PowerShell for Azure SQL DBs then I decided to pull it because I was thinking of moving to it to my blog to build a presence over there... you are right I think I should pick one route and concentrate there, I just don't know where yet.
September 13, 2016 at 8:27 am
Jeff Moden (9/13/2016)
BLOB_EATER (9/13/2016)
Anyone willing to share general stats on their blogs. ( Or is this a rude request??!)I have received 1000 views within the past 6 months which is poor ( but expected as Im quite new).. I am just trying to understand the sort of view hit the elite bloggers get... i.e. the MVPs / MCMs of this world. I'm guessing you guys hit many many many thousands over the month??
I get precisely zero hits. In fact, I've never gotten a hit on one of my blogs. I strongly suspect that it's because I don't have a blog. 😀
Rather than trying to build up a reputation on a blog or taking the time to make regular entries or maintain a blog, I just post on and write articles on (way behind on that) on SQL Server Central where readership has already been established. It's not for everyone but it works for me.
I almost didn't finish reading your full answer, as I was about to go search for you blog - as the thought of wow Jeff blogs rushed across my brain ... 🙂
But then I saw the punchline, so to speak 😀
Rodders...
September 13, 2016 at 8:42 am
BLOB_EATER (9/13/2016)
Grant Fritchey (9/13/2016)
I'm around 10,000 a month, give or take. I think that's about 300+ a day on week days. I know the big SQL Server bloggers like Brent or Paul & Kim, get considerably more than that. Don't sweat the numbers. Concentrate on consistency, generating material regularly so that those who do read it, come back for more. Also, regular posting makes you show up more on search engines. It's the search engines that bring you the numbers. That's why so many people spend most of their time attempting to game the search engines. I'm far too lazy for that. I just keep writing the stuff that interests me. Some of it works for the search engines, some doesn't.Excuse my lack of understanding but what do you mean by game the search engines?
You have to look it up. I don't have all the methods. It has to do with using terms repeatedly in the post, pushing particular terms, using certain graphics and graphic types, all sorts of stuff. I read it once and decided I was not that interested, so I just organically appear on searches.
"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
September 13, 2016 at 8:49 am
BLOB_EATER (9/13/2016)
Jeff Moden (9/13/2016)
BLOB_EATER (9/13/2016)
Anyone willing to share general stats on their blogs. ( Or is this a rude request??!)I have received 1000 views within the past 6 months which is poor ( but expected as Im quite new).. I am just trying to understand the sort of view hit the elite bloggers get... i.e. the MVPs / MCMs of this world. I'm guessing you guys hit many many many thousands over the month??
I get precisely zero hits. In fact, I've never gotten a hit on one of my blogs. I strongly suspect that it's because I don't have a blog. 😀
Rather than trying to build up a reputation on a blog or taking the time to make regular entries or maintain a blog, I just post on and write articles on (way behind on that) on SQL Server Central where readership has already been established. It's not for everyone but it works for me.
Funny you say that because this is what is currently on my mind. I struggle to do both, I have done 5 articles on SSC within the last 12 months and was going to a 6th one on PowerShell for Azure SQL DBs then I decided to pull it because I was thinking of moving to it to my blog to build a presence over there... you are right I think I should pick one route and concentrate there, I just don't know where yet.
Don't know if I can sway you one way or another but I've found an extreme advantage to posting and writing articles on SSC and that advantage is the Community here. There is no way that I could have learned as much over the years if I posted my articles on a private blog. One of the great examples of what I mean can be found in the discussion on the article I wrote about reducing multiple adjacent spaces to one. The method I used worked great compared to what I was used to seeing. Then a whole bunch of people jumped in on the discussion and I ended up learning of the amazing power and speed of nested REPLACEs and a nasty fast solution was revealed complete with some of the most thorough testing I've ever witnessed. Same happened on the TALLY OH! article. Lot's of good folks made additional suggestions and, as a result, the community built function known as DelimitedSplit8K has never been faster until 2012 came out and Eirikur Eiriksson came out with a improvement that made even that twice as fast.
Then there are a ton of folks that have written based on something they saw on this site and have come up with new things to do using "old" methods... Pattern Splits, N-Grams, different ways to generate other-than-flat test data, to name a ffew. The list goes on.
Like I've said so many times, "You've just got to love this community" and I think I personally wouldn't have learned as much without it and I'm pretty sure that level of interaction wouldn't have occurred on any blog I may have written... which is why I don't have my own blog. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
September 13, 2016 at 9:55 am
Like Grant and Gail, I sit around 10-11k a month on average.
SEO (gaming the search engines) is an art really. I haven't got a good grasp on it. Fresh consistent content helps when you are on your own domain. You can probably let it slide a lot if you happen to be on a site with a bunch of other bloggers (ahem Hugo 😉 ).
If you get consistent content, you will bubble upwards in the search engines and readers will regularly return. In addition to the consistent content it is important to make sure the material is on point. I think it makes a lot of difference when the writing contributes to the technical aspect of the article. In other words; style, grammar, spelling do matter. Make sure the content is easily digested even if it is a very technical article. You can achieve the easy digestion by sectioning off your content (headers, small groups of content) and by having the content tell a story and reach an objective.
Those things may not always be necessary or achievable, but it sure helps.
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
September 13, 2016 at 10:05 am
So a coworker HipChats me saying he needs some advice. Here is his question:
i have a stored procedure but the initial table is about 10million records, what is a good practice to break this up
Wow, looks like the typical question we get here where we need the crystal ball.
September 13, 2016 at 10:14 am
Lynn Pettis (9/13/2016)
So a coworker HipChats me saying he needs some advice. Here is his question:i have a stored procedure but the initial table is about 10million records, what is a good practice to break this up
Wow, looks like the typical question we get here where we need the crystal ball.
Frozen pork chops loaded into the pork chop launcher?
A sledgehammer?
A jackhammer?
A 120mm APFSDS round? :hehe:
September 13, 2016 at 10:14 am
Lynn Pettis (9/13/2016)
So a coworker HipChats me saying he needs some advice. Here is his question:i have a stored procedure but the initial table is about 10million records, what is a good practice to break this up
Wow, looks like the typical question we get here where we need the crystal ball.
hahahaha
edit: fix quote bug
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
September 13, 2016 at 10:23 am
Talking of the crystal ball...
Yesterday, I had an email from the BI / DWH manager asking me to join the meeting... I looked in my calendar knowing that there wasn't a meeting in my diary... And sure enough there wasn't one. This appears to be the weekly status update meeting. Now where did I put that crystal ball.
So I replied which meeting this?
I then get a meeting request - now you would think it would be re-occurring for the next 6 weeks, its only a two month contract to help out an old client get a backlog of issues sorted out... And I'm two weeks in. But no it just had the details of yesterdays meeting. So I'm pretty sure what will happen next Monday... :w00t:
Rodders...
September 13, 2016 at 10:24 am
jasona.work (9/13/2016)
Lynn Pettis (9/13/2016)
So a coworker HipChats me saying he needs some advice. Here is his question:i have a stored procedure but the initial table is about 10million records, what is a good practice to break this up
Wow, looks like the typical question we get here where we need the crystal ball.
Frozen pork chops loaded into the pork chop launcher?
A sledgehammer?
A jackhammer?
A 120mm APFSDS round? :hehe:
Intermediate range ballistic missile, needs to go from Colorado Springs, CO to Hampton, VA.
September 13, 2016 at 10:54 am
I recently submitted my first article for SSC. I got some great feedback on my rough drafts. Thanks Chris, Graham, and Wayne. I'm not sure what more is involved until it is actually published.
I also have ideas for a series of articles. There was a recent answer that made me realize that when I do write the series, I need to start with a basic concepts article, because the answer given was more complicated than it needed to be.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 15 posts - 55,771 through 55,785 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply