August 11, 2015 at 7:50 pm
WayneS (8/11/2015)
Any other Threadizens going to the Louisville SQL Saturday next week?
Nope - I have plans.
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
August 12, 2015 at 4:25 am
Can someone please help me out over here?
August 12, 2015 at 4:31 am
SQLRNNR (8/11/2015)
That said, Steve has a magic query that can help determine points from this thread so it can be excluded from total counts should anybody need to know their point counts.
On occasion I've wondered if people get points for posting a question (I.E. starting a new thread).
Do we?
August 12, 2015 at 5:13 am
WayneS (8/11/2015)
Any other Threadizens going to the Louisville SQL Saturday next week?
Nope. Omaha this week and then Okie City at the end of the month.
"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
August 12, 2015 at 5:14 am
Brandie Tarvin (8/12/2015)
SQLRNNR (8/11/2015)
That said, Steve has a magic query that can help determine points from this thread so it can be excluded from total counts should anybody need to know their point counts.On occasion I've wondered if people get points for posting a question (I.E. starting a new thread).
Do we?
Yes. Questions count too. As did this answer.
"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
August 12, 2015 at 5:17 am
GilaMonster (8/11/2015)
Ed Wagner (8/11/2015)
Lynn Pettis (8/11/2015)
SQLRNNR (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
VARCHAR(1) and NVARCHAR(1) are my absolute favorite "stupid database design" problems. Seriously. Love them. I point and laugh and laugh. Weird how the database design people don't appreciate the humor.
I sort of get it when they allow NULL. I wouldn't design anything like that but I can understand where that comes from. But to allow variable length and force a single character just kills me. :-D:-D:-D
I especially love it when they use an NVARCHAR(1) to store a 0 or 1. Unfortunately, that's a real-life example.
It's not just an edge-case real life example either. I have seen something like this at just about every client I have had.
Using SQL Server, storing a 0,1, or null; sounds like a good use of the BIT data type to me.
Yes it does, doesn't it? You'd think it would be intuitive, but I guess it isn't to everyone.
Personally I might use Tinyint with a constraint. Bit doesn't play nice with SUM.
I don't tend to use BIT for fields I might need to add. I use it for things where I need a CASE statement to check the status of the associated record.
August 12, 2015 at 5:20 am
YAY! The forums are back!
I was worried they'd be down all day.
August 12, 2015 at 5:53 am
Brandie Tarvin (8/12/2015)
YAY! The forums are back!I was worried they'd be down all day.
Me too. I sent an email to RG support. Maybe someone did something.
"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
August 12, 2015 at 6:11 am
Grant Fritchey (8/12/2015)
Brandie Tarvin (8/12/2015)
YAY! The forums are back!I was worried they'd be down all day.
Me too. I sent an email to RG support. Maybe someone did something.
RG support guy sees e-mail hollers across the room "Hey Sid! Unplug the coffee maker and plug the forum server back in, people've noticed!"
:hehe:
August 12, 2015 at 8:17 am
jasona.work (8/12/2015)
RG support guy sees e-mail hollers across the room "Hey Steve! Unplug the coffee maker and plug the forum server back in, people've noticed!":hehe:
FIFY 😉
August 12, 2015 at 9:43 am
jasona.work (8/12/2015)
Grant Fritchey (8/12/2015)
Brandie Tarvin (8/12/2015)
YAY! The forums are back!I was worried they'd be down all day.
Me too. I sent an email to RG support. Maybe someone did something.
RG support guy sees e-mail hollers across the room "Hey Sid! Unplug the coffee maker and plug the forum server back in, people've noticed!"
:hehe:
:hehe::hehe:
August 12, 2015 at 10:14 am
Lynn, I think that may have been unnecessarily antagonistic.
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
August 12, 2015 at 10:29 am
GilaMonster (8/12/2015)
Lynn, I think that may have been unnecessarily antagonistic.
Agree, given the shortage of Silver Spoons since the last shipment hasn't arrived end yet.
😎
Edit: speech to text bug.
August 12, 2015 at 10:37 am
WayneS (8/11/2015)
Any other Threadizens going to the Louisville SQL Saturday next week?
I am. See you there.
August 12, 2015 at 10:39 am
WayneS (8/11/2015)
Any other Threadizens going to the Louisville SQL Saturday next week?
I'm thinking about it.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 15 posts - 50,101 through 50,115 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply