Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 19,756 through 19,770 (of 66,749 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150468 More actions · Answer 1

Tom.Thomson (10/3/2010)
Anyone know of any MS plans to improve in this area?

Yes, they have confirmed SHA2 will be present in Denali:

http://connect.microsoft.com/SQLServer/feedback/details/585006/improve-hashing-support-hashbytes-improvements

For the time being we have SQLCLR integration, which means we can access the SHA256 and SHA512 variants of SHA2 that way:

http://msdn.microsoft.com/en-us/library/system.security.cryptography(v=VS.80).aspx

SQLCLR also allows us to break the 8000 byte limit of HashBytes:

http://blogs.msdn.com/b/shawnfa/archive/2004/02/20/77431.aspx

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Paul White SSC Guru Points: 150468 More actions · Answer 2

GilaMonster (10/3/2010)
I remember trying to get a 35kg barbell set up 2 flights of stairs. Took a while...

I can imagine. Luckily I am no sort of fitness devotee, so that is unlikely to ever be a problem for me 🙂

When I moved in to my current place, it took 4 strong people to get my desk up the stairs and inside. It was almost too large to fit through the door. The sofas were almost as large a challenge

The sofa was the toughest - the doorway is only just large enough, and the banisters leading up made the required rotations demanding (particularly for someone so unfamiliar with 35kg barbells).

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

TomThomson SSC Guru Points: 104773 More actions · Answer 3

Paul White NZ (10/3/2010)
Tom.Thomson (10/3/2010)
Anyone know of any MS plans to improve in this area?
Yes, they have confirmed SHA2 will be present in Denali:
http://connect.microsoft.com/SQLServer/feedback/details/585006/improve-hashing-support-hashbytes-improvements
For the time being we have SQLCLR integration, which means we can access the SHA256 and SHA512 variants of SHA2 that way:
http://msdn.microsoft.com/en-us/library/system.security.cryptography(v=VS.80).aspx
SQLCLR also allows us to break the 8000 byte limit of HashBytes:
http://blogs.msdn.com/b/shawnfa/archive/2004/02/20/77431.aspx

That's good to know.

SHA-224 is still missing though, maybe NIST has deprecated that and I didn't notice?

Tom

Jeff Moden SSC Guru Points: 1004441 More actions · Answer 4

CirquedeSQLeil (10/2/2010)
Brandie Tarvin (10/2/2010)
CirquedeSQLeil (10/2/2010)
Grant Fritchey (10/2/2010)
Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here last night?
No need for any substance here:-D
Need? No. Want?
The less said in public, the better. Wouldn't want the forum police to smite us for biltong blasphemy... @=)
Biltongonous blasphemer

Is that anything like a bombastic blatherskite? 😛

--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)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Jeff Moden (10/3/2010)
CirquedeSQLeil (10/2/2010)
Brandie Tarvin (10/2/2010)
CirquedeSQLeil (10/2/2010)
Grant Fritchey (10/2/2010)
Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here last night?
No need for any substance here:-D
Need? No. Want?
The less said in public, the better. Wouldn't want the forum police to smite us for biltong blasphemy... @=)
Biltongonous blasphemer
Is that anything like a bombastic blatherskite? 😛

It's the evolved form.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 6

Dave Ballantyne (10/3/2010)
Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked "who uses tally tables". Just hope i didnt suck to much, now waiting for the feedback forms.

I'm sure you did a great job, Dave.

I wish I had the time and money to attend this kind of conference.

-- Gianluca Sartori

BrainDonor SSCoach Points: 19256 More actions · Answer 7

Paul White NZ (10/2/2010)
Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. And I'm moving house.

How much is GST increasing by? We're planning a tour of both islands for next year and had all of the hotel, fuel bills and suchlike budgeted. If we have to increase it all by a large percentage then I'm selling some of the kid's organs.

Steve Hall
Linkedin
Blog Site

Paul White SSC Guru Points: 150468 More actions · Answer 8

BrainDonor (10/4/2010)
How much is GST increasing by? We're planning a tour of both islands for next year and had all of the hotel, fuel bills and suchlike budgeted. If we have to increase it all by a large percentage then I'm selling some of the kid's organs.

It went from 12.5% to 15%

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

BrainDonor SSCoach Points: 19256 More actions · Answer 9

Paul White NZ (10/4/2010)
BrainDonor (10/4/2010)
How much is GST increasing by? We're planning a tour of both islands for next year and had all of the hotel, fuel bills and suchlike budgeted. If we have to increase it all by a large percentage then I'm selling some of the kid's organs.
It went from 12.5% to 15%

Thanks. One kidney should cover that. They have four between them - I'll let them decide.

Steve Hall
Linkedin
Blog Site

Paul White SSC Guru Points: 150468 More actions · Answer 10

BrainDonor (10/4/2010)
Thanks. One kidney should cover that. They have four between them - I'll let them decide.

Seems fair 🙂

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Jeff Moden SSC Guru Points: 1004441 More actions · Answer 11

Dave Ballantyne (10/3/2010)
Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked "who uses tally tables". Just hope i didnt suck to much, now waiting for the feedback forms.

BWAA-HAAA!!!! Oh lordy! The question I normally ask is "Who of you knows what a Numbers or Tally Table is"? I throw the "Numbers" name in there just in case they know it by that name.

Just like you said... everywhere no one from SSC hasn't been before, I get that proverbial "deer in headlights" stare. The last time I asked it at a local PASS meeting I taught to, only one person out of nearly 50 raised their hand and he had never actually used one... just heard of it.

I'm sorry I lost track of what your presentation was on so let me ask... what was your presentation on and is there someplace where we can see either the deck or the movie?

And, congratulations on the presentation. I just know you did well.

--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)

Kit G SSCrazy Points: 2888 More actions · Answer 12

Jeff Moden (10/1/2010)
And I DID ask. Yes. That answers my question. Thanks for the bit of insight, Kit.

You're welcome. 🙂

-- Kit

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 13

Jeff Moden (10/4/2010)
Dave Ballantyne (10/3/2010)
Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked "who uses tally tables". Just hope i didnt suck to much, now waiting for the feedback forms.
BWAA-HAAA!!!! Oh lordy! The question I normally ask is "Who of you knows what a Numbers or Tally Table is"? I throw the "Numbers" name in there just in case they know it by that name.
Just like you said... everywhere no one from SSC hasn't been before, I get that proverbial "deer in headlights" stare. The last time I asked it at a local PASS meeting I taught to, only one person out of nearly 50 raised their hand and he had never actually used one... just heard of it.
I'm sorry I lost track of what your presentation was on so let me ask... what was your presentation on and is there someplace where we can see either the deck or the movie?
And, congratulations on the presentation. I just know you did well.

Speaking of this, I presented at a Developers code camp the other day and had an absolute blast. I've got 12-15 people in a room and none of them knew about parameter sniffing or sargeability or any of the basics of query tuning. It was excellent. I'm thinking about stopping presentations for DBAs and just presenting to developers. I probably made more impact there than I have in several presentations.

"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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 14

Speaking of this, I presented at a Developers code camp the other day and had an absolute blast. I've got 12-15 people in a room and none of them knew about parameter sniffing or sargeability or any of the basics of query tuning. It was excellent. I'm thinking about stopping presentations for DBAs and just presenting to developers. I probably made more impact there than I have in several presentations.

I think you're right on the money about making more impact, Grant.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Jack Corbett SSC Guru Points: 184394 More actions · Answer 15

Who you are presenting to definitely makes a difference on impact.

I know that my Why I Use Stored Procedures would probably have a bigger impact at a code camp instead of a SQL User group or SQLSaturday.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question