Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 14,296 through 14,310 (of 66,712 total)

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

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

Roy Ernest

SSC-Dedicated

Points: 38780

April 14, 2010 at 12:13 pm

#1151618

Big Brother is always watching you... 🙂

-Roy

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Alvin Ramard (4/14/2010)
jcrawf02 (4/14/2010)
I've been out of Twitter-touch lately, but did you guys see this? Library of Congress is archiving every single tweet ever made?
I wonder how they're doing that when they're not following everybody.

Just like with phone calls. Tomorrow you may have men in black on your stoop because you tweeted about Dead Poets (and society got cut off due to length restrictions).

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 3

Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.

It looks like you can come back now.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.

And I did. Just waiting now to see what he has to say.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
And I did. Just waiting now to see what he has to say.

DDL SHMeeDL 😀

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

I realize many run SQL Server using a case insensitive collation, but really, your code should be consistant. I'm sorry, but roleID and RoleID aren't the same. That's why I write all system tables in lower case as well. We have systems that run using case insensitive collations and others that run using case sensitive collations. Makes things interesting, but forces us to be consistant so that code written on one system will also run on another.

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 7

Lynn Pettis (4/14/2010)
I realize many run SQL Server using a case insensitive collation, but really, your code should be consistant. I'm sorry, but roleID and RoleID aren't the same. That's why I write all system tables in lower case as well. We have systems that run using case insensitive collations and others that run using case sensitive collations. Makes things interesting, but forces us to be consistant so that code written on one system will also run on another.

I saw the posts your talking about. I hadn't really thought about collation lately, a few jobs ago we had mixed coallations and it drove me bonkers. BTW-- I like the solution you presented, is it scallable?

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Lynn Pettis (4/14/2010)
That's why I write all system tables in lower case as well.

I hadn't considered that. Makes sense. I should probably check my usage of the system tables and views to verify case consistency.

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 9

Lynn,

On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through the GUI. The GUI is so well written that sometimes the case is consistent and sometimes it is whatever CRM decides to make it. We are having fits with it right now trying to get the frickin thing to be consistent and it is like banging heads on walls or other inanimate objects.

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

WayneS SSC Guru Points: 95460 More actions · Answer 10

Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
And I did. Just waiting now to see what he has to say.

Yoose guys kare to inliten us with a link to what you're jabbering about?

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

Trey Staker (4/14/2010)
Lynn Pettis (4/14/2010)
I realize many run SQL Server using a case insensitive collation, but really, your code should be consistant. I'm sorry, but roleID and RoleID aren't the same. That's why I write all system tables in lower case as well. We have systems that run using case insensitive collations and others that run using case sensitive collations. Makes things interesting, but forces us to be consistant so that code written on one system will also run on another.
I saw the posts your talking about. I hadn't really thought about collation lately, a few jobs ago we had mixed coallations and it drove me bonkers. BTW-- I like the solution you presented, is it scallable?

Yes, it is scalable, especially when compared to a recursive CTE.

Wondering I am if he'll be back now an answer he has.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

WayneS (4/14/2010)
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
And I did. Just waiting now to see what he has to say.
Yoose guys kare to inliten us with a link to what you're jabbering about?

Hmmm - a question about a cte - have to find a link. Ah, yes - there it is.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 13

CirquedeSQLeil (4/14/2010)
Lynn,
On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through the GUI. The GUI is so well written that sometimes the case is consistent and sometimes it is whatever CRM decides to make it. We are having fits with it right now trying to get the frickin thing to be consistent and it is like banging heads on walls or other inanimate objects.

I'll keep that in mind.

Could be like Axapta. From what I understand, POST is POST. If you can POST a sales order, you can POST a payment also, even if you don't have security access to that module. Hopefully they fixed that, but you never know.

WayneS SSC Guru Points: 95460 More actions · Answer 14

CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
And I did. Just waiting now to see what he has to say.
Yoose guys kare to inliten us with a link to what you're jabbering about?
Hmmm - a question about a cte - have to find a link. Ah, yes - there it is.

Okay, gimme a break!:hehe: This sub-thread said nothing about a CTE... :w00t:

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn,
On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through the GUI. The GUI is so well written that sometimes the case is consistent and sometimes it is whatever CRM decides to make it. We are having fits with it right now trying to get the frickin thing to be consistent and it is like banging heads on walls or other inanimate objects.
I'll keep that in mind.
Could be like Axapta. From what I understand, POST is POST. If you can POST a sales order, you can POST a payment also, even if you don't have security access to that module. Hopefully they fixed that, but you never know.

Aggravating.

You also have to be extremely careful about doing anything outside of the GUI - else it could get deleted with the next release of CRM.

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