January 6, 2012 at 10:26 am
Steve Jones - SSC Editor (1/6/2012)
Jeff Moden (1/5/2012)
Steve... any chance of getting a "thread count" for 2011?Posts by year? Sure, I'll query it.
obscure the data too
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
January 6, 2012 at 10:30 am
Steve Jones - SSC Editor (1/6/2012)
Yearly rollup
Year Total
2008 525
2009 9,884
2010 12,437
2011 10,189
2012 249
Stats like this (with names attached) is why we are losing steam on this thread.
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
January 6, 2012 at 10:33 am
GilaMonster (1/6/2012)
And vague question of the week award goes to: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169885
hahaha
How do I do that?
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
January 6, 2012 at 10:38 am
Ninja's_RGR'us (1/6/2012)
SQLRNNR (1/6/2012)
GilaMonster (1/6/2012)
I hate underscores. I hate all caps naming. I have a special hatred for what I have in a system at the moment:INSURANCECAMPAIGNREVIEW_STARTDATE
That sounds a lot like some tables I have seen in various vendor databases.
iNSuRaNCeCaMPaiGNRaVieW_STaRTDaTe_eNDDaTe_aND_aLL_DaTeSiNBeTWeeN
So glad you didn't overexagerate this!
Crud, and there is a typo
iNSuRaNCeCaMPaiGNReVieW_STaRTDaTe_eNDDaTe_aND_aLL_DaTeSiNBeTWeeN
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
January 6, 2012 at 10:43 am
MysteryJimbo (1/6/2012)
GilaMonster (1/6/2012)
And vague question of the week award goes to: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169885I don't know. This is pretty vague.
http://www.sqlservercentral.com/Forums/Topic1231424-1549-1.aspx
Ow, I didn't see that one. What do people expect when they post something like that? Magical solutions?
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
January 6, 2012 at 10:59 am
Brandie Tarvin (1/6/2012)
Evil Kraig F (1/5/2012)
One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss it.If for example I stroll in and start venting about Coca-Cola having too much damned sugar for the database to handle, and they're going to crash and burn because I'm looking at how the databases are self-destructing, this would be a problem. It's both insider information being distributed in a bad way without attempting to allow the company to correct it and I'm throwing my employer under the bus.
If I start up a discussion on the soda industry and discuss the problems I'm having keeping sugar in the database and how it's restricting my ability to work and I'm trying to find solutions, I'm good to go.
If I start complaining that either of those are making me crazy because I can't get their advertising jingles out of my head they have no right to give a flip. 😀
This is exactly the discussion that I'm talking about. It's nice to hear everyone else's opinion on the subject, but I'm wondering if anyone has caught themselves venting in a way that throws a bad light on their company.
The thing is, some of the news examples (none of which I can remember off the top of my head) of people getting fired over the whole social network thing were situations where the people in question weren't venting about the company itself or sharing insider secrets, but they still got fired because their opinions contradicted the image and brand their employer likes to maintain.
This last point is why I was curious how an outsiders view of The Thread affects hiring decisions.
Well, Red Gate hired me despite my participation on The Thread. In fact, they hired me even though they actually knew me.
"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
January 6, 2012 at 11:04 am
Grant Fritchey (1/6/2012)
Brandie Tarvin (1/6/2012)
Evil Kraig F (1/5/2012)
One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss it.If for example I stroll in and start venting about Coca-Cola having too much damned sugar for the database to handle, and they're going to crash and burn because I'm looking at how the databases are self-destructing, this would be a problem. It's both insider information being distributed in a bad way without attempting to allow the company to correct it and I'm throwing my employer under the bus.
If I start up a discussion on the soda industry and discuss the problems I'm having keeping sugar in the database and how it's restricting my ability to work and I'm trying to find solutions, I'm good to go.
If I start complaining that either of those are making me crazy because I can't get their advertising jingles out of my head they have no right to give a flip. 😀
This is exactly the discussion that I'm talking about. It's nice to hear everyone else's opinion on the subject, but I'm wondering if anyone has caught themselves venting in a way that throws a bad light on their company.
The thing is, some of the news examples (none of which I can remember off the top of my head) of people getting fired over the whole social network thing were situations where the people in question weren't venting about the company itself or sharing insider secrets, but they still got fired because their opinions contradicted the image and brand their employer likes to maintain.
This last point is why I was curious how an outsiders view of The Thread affects hiring decisions.
Well, Red Gate hired me despite my participation on The Thread. In fact, they hired me even though they actually knew me.
Well you know what they say about 'mad dogs and Englishmen'... 😉
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
January 6, 2012 at 11:19 am
GilaMonster (1/6/2012)
Grant Fritchey (1/6/2012)
Brandie Tarvin (1/6/2012)
Evil Kraig F (1/5/2012)
One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss it.If for example I stroll in and start venting about Coca-Cola having too much damned sugar for the database to handle, and they're going to crash and burn because I'm looking at how the databases are self-destructing, this would be a problem. It's both insider information being distributed in a bad way without attempting to allow the company to correct it and I'm throwing my employer under the bus.
If I start up a discussion on the soda industry and discuss the problems I'm having keeping sugar in the database and how it's restricting my ability to work and I'm trying to find solutions, I'm good to go.
If I start complaining that either of those are making me crazy because I can't get their advertising jingles out of my head they have no right to give a flip. 😀
This is exactly the discussion that I'm talking about. It's nice to hear everyone else's opinion on the subject, but I'm wondering if anyone has caught themselves venting in a way that throws a bad light on their company.
The thing is, some of the news examples (none of which I can remember off the top of my head) of people getting fired over the whole social network thing were situations where the people in question weren't venting about the company itself or sharing insider secrets, but they still got fired because their opinions contradicted the image and brand their employer likes to maintain.
This last point is why I was curious how an outsiders view of The Thread affects hiring decisions.
Well, Red Gate hired me despite my participation on The Thread. In fact, they hired me even though they actually knew me.
Well you know what they say about 'mad dogs and Englishmen'... 😉
Now I'm sitting here in the airport giggling. They're going to come & arrest me and it'll be your fault.
"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
January 6, 2012 at 11:28 am
SQLRNNR (1/6/2012)
GilaMonster (1/6/2012)
I hate underscores. I hate all caps naming. I have a special hatred for what I have in a system at the moment:INSURANCECAMPAIGNREVIEW_STARTDATE
That sounds a lot like some tables I have seen in various vendor databases.
iNSuRaNCeCaMPaiGNRaVieW_STaRTDaTe_eNDDaTe_aND_aLL_DaTeSiNBeTWeeN
First of all, Jason, you spelled "review" wrong. Second of all, if you ever do that to one of my databases, I will tie you to the d@mn pork chop flinger and inflict more misery upon you than it is possible to inflict upon any other living human being.
@=)
January 6, 2012 at 11:32 am
Brandie Tarvin (1/6/2012)
SQLRNNR (1/6/2012)
GilaMonster (1/6/2012)
I hate underscores. I hate all caps naming. I have a special hatred for what I have in a system at the moment:INSURANCECAMPAIGNREVIEW_STARTDATE
That sounds a lot like some tables I have seen in various vendor databases.
iNSuRaNCeCaMPaiGNRaVieW_STaRTDaTe_eNDDaTe_aND_aLL_DaTeSiNBeTWeeN
First of all, Jason, you spelled "review" wrong.
What, you believe databases should be spelt correctly? How quaint.
I had all sorts of fun last week trying to 'optimise' a 4000 line long proc (well, 4200 after I ran SQLPrompt's formatter over it. 1200 before). It took me quite a while to notice that there was a parameter @ACCOUNTID and a variable @ACCCOUNTID and they both used at various places with no rhythm or rhyme.
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
January 6, 2012 at 11:38 am
GilaMonster (1/6/2012)
Brandie Tarvin (1/6/2012)
First of all, Jason, you spelled "review" wrong.What, you believe databases should be spelt correctly? How quaint.
Yeah, I'm kinda old fashioned that way.
Just got my copy of Redmond magazine in today and gave up trying to read it when I found three grammatical errors in the first three pages. Sentences that make absolutely no sense, and one page formatting that misleads the eye into believing it's a continuation from a previous page. I will never be able to take that magazine seriously again.
January 6, 2012 at 11:39 am
Grant Fritchey (1/6/2012)
GilaMonster (1/6/2012)
Grant Fritchey (1/6/2012)
Brandie Tarvin (1/6/2012)
Evil Kraig F (1/5/2012)
One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss it.If for example I stroll in and start venting about Coca-Cola having too much damned sugar for the database to handle, and they're going to crash and burn because I'm looking at how the databases are self-destructing, this would be a problem. It's both insider information being distributed in a bad way without attempting to allow the company to correct it and I'm throwing my employer under the bus.
If I start up a discussion on the soda industry and discuss the problems I'm having keeping sugar in the database and how it's restricting my ability to work and I'm trying to find solutions, I'm good to go.
If I start complaining that either of those are making me crazy because I can't get their advertising jingles out of my head they have no right to give a flip. 😀
This is exactly the discussion that I'm talking about. It's nice to hear everyone else's opinion on the subject, but I'm wondering if anyone has caught themselves venting in a way that throws a bad light on their company.
The thing is, some of the news examples (none of which I can remember off the top of my head) of people getting fired over the whole social network thing were situations where the people in question weren't venting about the company itself or sharing insider secrets, but they still got fired because their opinions contradicted the image and brand their employer likes to maintain.
This last point is why I was curious how an outsiders view of The Thread affects hiring decisions.
Well, Red Gate hired me despite my participation on The Thread. In fact, they hired me even though they actually knew me.
Well you know what they say about 'mad dogs and Englishmen'... 😉
Now I'm sitting here in the airport giggling. They're going to come & arrest me and it'll be your fault.
Don't forget to make sure model and master are using enforced case sensitivity as their default so all the system tables require proper case. 😀
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 6, 2012 at 11:50 am
Brandie Tarvin (1/6/2012)
SQLRNNR (1/6/2012)
GilaMonster (1/6/2012)
I hate underscores. I hate all caps naming. I have a special hatred for what I have in a system at the moment:INSURANCECAMPAIGNREVIEW_STARTDATE
That sounds a lot like some tables I have seen in various vendor databases.
iNSuRaNCeCaMPaiGNRaVieW_STaRTDaTe_eNDDaTe_aND_aLL_DaTeSiNBeTWeeN
First of all, Jason, you spelled "review" wrong. Second of all, if you ever do that to one of my databases, I will tie you to the d@mn pork chop flinger and inflict more misery upon you than it is possible to inflict upon any other living human being.
@=)
I enjoyed creating tables and columns for one job like this
CREATE TABLE "--¦" ( "+--+-+" int, "+-+" date)
Told my boss it was a security measure 'cause no-one would be able to guess the names.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
January 6, 2012 at 12:30 pm
Stefan Krzywicki (1/6/2012)
I enjoyed creating tables and columns for one job like this
CREATE TABLE "--¦" ( "+--+-+" int, "+-+" date)Told my boss it was a security measure 'cause no-one would be able to guess the names.
You're fired.
January 6, 2012 at 12:33 pm
Steve Jones - SSC Editor (1/6/2012)
Stefan Krzywicki (1/6/2012)
I enjoyed creating tables and columns for one job like this
CREATE TABLE "--¦" ( "+--+-+" int, "+-+" date)Told my boss it was a security measure 'cause no-one would be able to guess the names.
You're fired.
From a cannon.
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
Viewing 15 posts - 33,301 through 33,315 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply