Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 12,841 through 12,855 (of 66,712 total)

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

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Grant Fritchey (3/17/2010)
Oooh. Don't say fanny-pack in England. I already made that mistake.

Not quite as bad as "I really need a Fag" , as i once loudly announced in a Boston office. 🙂

Clear Sky SQL
My Blog[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 2

Paul White (3/16/2010)
Jeff Moden (3/16/2010)
I assume that by "explicit date" you mean something like '1900-01-01'... and that's not a date either... that's a string that looks like a date. 😛
Aside from using CAST or CONVERT, the following produce a DATETIME directly:
SELECT d = {d '1900-01-01'}, -- Date only at midnight
t = {t '00:00:00.000'}, -- Today at midnight
ts = {ts '1900-01-01 00:00:00.000'} -- Full timestamp

Paul,

In BOL for ODBC Scalar Functions, it has a syntax of {fn ...}. Do you have a link that shows the use of d/t/ts like you used above?

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

Paul White SSC Guru Points: 150467 More actions · Answer 3

WayneS (3/17/2010)
In BOL for ODBC Scalar Functions, it has a syntax of {fn ...}. Do you have a link that shows the use of d/t/ts like you used above?

Yep...http://msdn.microsoft.com/en-us/library/ms180878.aspx#ODBCDatetimeFormat

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

Jeff Moden (3/16/2010)
Roy Ernest (3/16/2010)
CirquedeSQLeil (3/16/2010)
Roy Ernest (3/16/2010)
I got my $500 yesterday. If I can write an article there, anyone here can write it for sure. 🙂
You wrote an article for the standard? What's the link so we can go read it.
It has not been published yet. Still more people in front of the queue. 🙂
What is the subject matter for your article, Roy?

Resource Governor...:-)

-Roy

Paul White SSC Guru Points: 150467 More actions · Answer 5

Roy Ernest (3/17/2010)
Resource Governor...:-)

Good choice. I am a fan of the resource governor.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 6

Holy Cow! I just received a list of errata on my book so detailed I would have thought it came from one you guys, except they were wrong on a couple of technical issues that you guys wouldn't have messed up. Woof. Someone has too much time on their hands (although, most of it was valid issues, continuity issues between the text & code & images).

Woof.

And, I was navigating to The Thread directly and notice that the original poster, Michael Earl, hasn't even logged on since: Last Login: 10/9/2009 9:14 PM

The Thread lives on!

"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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

Hey guys, can you throw me a bone here for SSRS how-to-make-a-simple-billing-report?

I can't find anything usefull on google which means I don't know what to search for!

http://www.sqlservercentral.com/Forums/Topic884086-150-1.aspx

TIA.

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

Grant Fritchey (3/17/2010)
Holy Cow! I just received a list of errata on my book...

At least you know someone has read it now 😛

(sorry)

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 9

Paul White (3/17/2010)
Grant Fritchey (3/17/2010)
Holy Cow! I just received a list of errata on my book...
At least you know someone has read it now 😛
(sorry)

My mom looked at it. Everything else is gravy.

"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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 10

Grant Fritchey (3/17/2010)
Paul White (3/17/2010)
Grant Fritchey (3/17/2010)
Holy Cow! I just received a list of errata on my book...
At least you know someone has read it now 😛
(sorry)
My mom looked at it. Everything else is gravy.

Can we send her questions to see how well she understood it? 😀

.... not queers, I said Q-U-E-R-I-E-S!!!! ....

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for 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]

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 11

Alvin Ramard (3/17/2010)
Grant Fritchey (3/17/2010)
Paul White (3/17/2010)
Grant Fritchey (3/17/2010)
Holy Cow! I just received a list of errata on my book...
At least you know someone has read it now 😛
(sorry)
My mom looked at it. Everything else is gravy.
Can we send her questions to see how well she understood it? 😀
.... not queers, I said Q-U-E-R-I-E-S!!!! ....

You have time on your hands too?

"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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

Grant Fritchey (3/17/2010)
Alvin Ramard (3/17/2010)
Grant Fritchey (3/17/2010)
Paul White (3/17/2010)
Grant Fritchey (3/17/2010)
Holy Cow! I just received a list of errata on my book...
At least you know someone has read it now 😛
(sorry)
My mom looked at it. Everything else is gravy.
Can we send her questions to see how well she understood it? 😀
.... not queers, I said Q-U-E-R-I-E-S!!!! ....
You have time on your hands too?

Is that what this sticky stuff is? I thought it was some of that sugary stuff from the donuts. 🙂

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for 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]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Paul White (3/17/2010)
WayneS (3/17/2010)
In BOL for ODBC Scalar Functions, it has a syntax of {fn ...}. Do you have a link that shows the use of d/t/ts like you used above?
Yep...http://msdn.microsoft.com/en-us/library/ms180878.aspx#ODBCDatetimeFormat

Thanks for providing more documentation

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 SSC Guru Points: 281334 More actions · Answer 14

Roy Ernest (3/17/2010)
Resource Governor...:-)

Nice topic.

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 SSC Guru Points: 281334 More actions · Answer 15

Grant Fritchey (3/17/2010)
Holy Cow! I just received a list of errata on my book so detailed I would have thought it came from one you guys, except they were wrong on a couple of technical issues that you guys wouldn't have messed up. Woof. Someone has too much time on their hands (although, most of it was valid issues, continuity issues between the text & code & images).
Woof.
And, I was navigating to The Thread directly and notice that the original poster, Michael Earl, hasn't even logged on since: Last Login: 10/9/2009 9:14 PM
The Thread lives on!

Ouch - a lot of time on their hands.

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