Are the posted questions getting worse?
-
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.
Why? Are you trying to say that you would have guessed them? 😉
-
GilaMonster (1/6/2012)
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.
It was a joke and fortunately, he thought it was funny.
--------------------------------------
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 -
Ninja's_RGR'us (1/6/2012)
Greg Edwards-268690 (1/6/2012)
Ninja's_RGR'us (1/6/2012)
Brandie Tarvin (1/6/2012)
Ninja's_RGR'us (1/6/2012)
Steve Jones - SSC Editor (1/6/2012)
Since inception, here are the postsWith yearly rollup please?
Picky, picky, picky.
You sound just like an end user.
What the heck do you think we are here ;-)?
Worse than that I'm the BI guy. :hehe:
All the more reason to be able to ask someone else.
Yesterday I had to update my default on a prompt to 2012.
Felt like just blanking it out.
The things we do to lower the noise level....
Or change it to current_year.
Or better, I have a function to save the default parameters for each users / reports. Never have to change a default ever again!
But on Jan 03 2012, when you have to pull Fiscal Week 52 from 2011, things get more complicated.
Idea was to have something a bit more generic, but made the mistake by inserting a small bit of help with a default.
I just have to think quietly to myself how many keystokes it took them to compose an email asking me to change the year from 2011 to 2012.
They run this once a day, so they burned up a couple of months of effort.
Shame on me for reducing their productivity. Bad IT guy.
-
Top 10 from 2011
User postsSQLRNNR 945
Stefan Krzywicki 785
GilaMonster 771
Ninja's_RGR'us 645
GSquared 583
Brandie Tarvin 558
Evil Kraig F 431
Steve Jones - SSC 427
Jeff Moden 379
L' Eomot Inversé 360
-
Steve Jones - SSC Editor (1/6/2012)
Top 10 from 2011User postsSQLRNNR 945
Stefan Krzywicki 785
GilaMonster 771
Ninja's_RGR'us 645
GSquared 583
Brandie Tarvin 558
Evil Kraig F 431
Steve Jones - SSC 427
Jeff Moden 379
L' Eomot Inversé 360
Huh, I'm a lot chattier than I thought...
--------------------------------------
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 -
Stefan Krzywicki (1/6/2012)
Steve Jones - SSC Editor (1/6/2012)
Top 10 from 2011User postsSQLRNNR 945
Stefan Krzywicki 785
GilaMonster 771
Ninja's_RGR'us 645
GSquared 583
Brandie Tarvin 558
Evil Kraig F 431
Steve Jones - SSC 427
Jeff Moden 379
L' Eomot Inversé 360
Huh, I'm a lot chattier than I thought...
Heh, you too?
- Craig FarrellNever 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 -
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.
@=)
Yeah - i saw that, despite the fact that just looking at that name hurts my eyes.
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 -
Brandie Tarvin (1/6/2012)
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.
I can't help it but I do the same thing with books, magazines, articles that are "published" that I read. I am more lenient with blogs and forums, but still see those errors and wince every time. I really hate finding errors of my own.
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 -
Stefan Krzywicki (1/6/2012)
GilaMonster (1/6/2012)
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.
It was a joke and fortunately, he thought it was funny.
Yeah, I need to play a joke like that still. It needs to be setup in such a way that when you expand the tree in SSMS it creates an interesting picture and not something that looks random.
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 -
Steve Jones - SSC Editor (1/6/2012)
Top 10 from 2011User postsSQLRNNR 945
Stefan Krzywicki 785
GilaMonster 771
Ninja's_RGR'us 645
GSquared 583
Brandie Tarvin 558
Evil Kraig F 431
Steve Jones - SSC 427
Jeff Moden 379
L' Eomot Inversé 360
Crap - and all that after I was trying to scale back. I think Steve fudged the numbers:-D
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 -
SQLRNNR (1/6/2012)
Steve Jones - SSC Editor (1/6/2012)
Top 10 from 2011User postsSQLRNNR 945
Stefan Krzywicki 785
GilaMonster 771
Ninja's_RGR'us 645
GSquared 583
Brandie Tarvin 558
Evil Kraig F 431
Steve Jones - SSC 427
Jeff Moden 379
L' Eomot Inversé 360
Crap - and all that after I was trying to scale back. I think Steve fudged the numbers:-D
If I was fudging, I'd have moved me out of the top 10.
-
Steve Jones - SSC Editor (1/6/2012)
Top 10 from 2011User postsSQLRNNR 945
Stefan Krzywicki 785
GilaMonster 771
Ninja's_RGR'us 645
GSquared 583
Brandie Tarvin 558
Evil Kraig F 431
Steve Jones - SSC 427
Jeff Moden 379
L' Eomot Inversé 360
Congrats Grant! 🙂
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
Lynn Pettis (1/6/2012)
Case insensitive vs case sensitive, one of the reasons I write all my queries and t-sql code as if everything was case sensitive. Don't have to worry about it that way.I agree it is a good practice, but it doesn't make one invulnerable:
USE master
CREATE DATABASE Test COLLATE Latin1_General_CS_AS
GO
USE Test
GO
-- Success
CREATE TABLE dbo.t (col1 INT)
GO
-- Success!
CREATE TABLE dbo.T (col1 INT)
GO
-- Success if server collation is case-sensitive
DECLARE @a INTEGER, @a INTEGER
GO
DROP TABLE dbo.t, dbo.T
GO
USE master
DROP DATABASE Test
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
SQLRNNR (1/5/2012)
And we dedicate this page to Jeff (pork chop launcher, Evil Santa or something like that and most posts on this page 😉 )😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
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
This one is way worse!
Viewing 15 posts - 33,316 through 33,330 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply