Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 30,121 through 30,135 (of 66,712 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Roy Ernest (9/20/2011)
Brandie Tarvin (9/20/2011)
Whoot! So, who wants to go to Curacoa?
http://www.sqlsaturday.com/eventhome.aspx - SQL Saturday 103
Self plug...
This is a unique event where you can mix business with pleasure. Think about it, one day you are sipping a Pina colada or a margarita on a white sandy beach and the next day you are learning SQL Server. 🙂
One day you are scuba diving with my CTO as your Dive master and the next day you are getti9ng tons of useful information about SQL Server. 😀
I am not going to mention about the carnival here at all. 😀 (It is the weekend before the SQL Saturday.)

Scuba / snorkel / feed some sharks.

I am off to get my passport renewed.

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 2

L' Eomot Inversé (9/20/2011)

You changed your name?

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

Brandie Tarvin (9/16/2011)
I'm thinking about getting a tablet so I can do email & social networking apps while I am at functions (rather than lugging my laptop around), but also read books on it. Therefore, I went to look at the Nook Color today, but I'm still not convinced this is my best choice. The problem with the Nook Color is that it requires logging on to WiFi. I want to be able to log onto the internet even when there is no WiFi available (via use of a broadband card, etc.).
Anyone have any good options / advice on the matter?

Who's your carrier for cell service? Most of the devices that give you coverage for web (iPad, Transformer, etc.) have a $20/mo fee. I know Verizon has a $20/month sharing fee to let you use the phone as a hotspot. I think that's a better choice, more flexibility than having to use the tablet. Plus in a pinch you can use your laptop with it.

TomThomson SSC Guru Points: 104773 More actions · Answer 4

GSquared (9/20/2011)
Try that. You might be surprised by the results.

It would be much more fun just to stick SET ANSI_NULLS OFF in front of Paul's original suggestion. :w00t:

Actually, losing SPT_VALUES used to be fairly painless; I don't know for sure that it still is. :unsure:

Tom

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

WayneS (9/16/2011)
GilaMonster (9/16/2011)
I've been considering an article for Simple-Talk on that, to cover the subject properly and clear all the misconceptions floating around would take far more space than usual for an SSC article
Hey, Jeff has written some pretty long ones here. I bet Steve will go for it.

Flexible on length, though I do try to break them into a shorter series if I can

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

@Steve.

Did we get you the 300 notification your requested? 😀

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Ninja's_RGR'us (9/20/2011)
L' Eomot Inversé (9/20/2011)
Ninja's_RGR'us (9/20/2011)
What's up with the new signature Tom? It sure looks like french but I'm pretty sure it's not!
The subject of the song is never named in the song, but we are told that it has several names, all unacceptable, the worst of which is "un petit vocable de trois lettres pas plus familier coutumier", that "[il] porte le même nom qu'une foule de gens" and shame is cast upon whoever spitefully and venomously "dota du même terme en son fiel venimeux ce grand ami de l'homme et la cinglante injure". So it's pretty obvious what it is.:-D (unless your French is non-existent or nearly)
I'm from Quebec so my french is far from non-existent!

Probably better than mine 😛

So now you know what the song is about.

Tom

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 8

GilaMonster (9/17/2011)
Evil Kraig F (9/17/2011)
The request? I thought we were just hoping to break Steve's spirit in general.
CRAP, I've been doing it wrong again!;-)
Knowing Steve, it'll take far more than a few hundred forum notifications for that. Sanity, now that may be a different matter

LOL, I did come home to lots of notifications. I'm deleting most as I whip through this forum.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Steve Jones - SSC Editor (9/20/2011)
WayneS (9/16/2011)
GilaMonster (9/16/2011)
I've been considering an article for Simple-Talk on that, to cover the subject properly and clear all the misconceptions floating around would take far more space than usual for an SSC article
Hey, Jeff has written some pretty long ones here. I bet Steve will go for it.
Flexible on length, though I do try to break them into a shorter series if I can

I think we fell short by 300. We need to work at that a bit more.:-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

spaghettidba SSC Guru Points: 105732 More actions · Answer 10

L' Eomot Inversé (9/20/2011)
If ansi nulls are off it can. So you know lots of people who allow code to run with ansi nulls off? That's scary! :sick:

I know people that do lots of evil things.

And have no idea of what ANSI NULLS is.

-- Gianluca Sartori

GSquared SSC Guru Points: 260824 More actions · Answer 11

Gianluca Sartori (9/20/2011)
GSquared (9/20/2011)
Depending on your ANSI NULLs setting, it might try.
SET ANSI_NULLS OFF;
CREATE TABLE #T (
ID INT PRIMARY KEY);
INSERT INTO #T (ID)
VALUES (1),(2),(3);
SELECT * FROM #T;
MERGE #T AS A
USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
SELECT * FROM #T;
Try that. You might be surprised by the results.
OK, so I guess now I owe you my house. :unsure:

Okay. I'll let you live there if you pay the bills, the mortgage, take care of the yard, et al. Won't even charge you rent! :w00t:

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

GSquared (9/20/2011)
Gianluca Sartori (9/20/2011)
GSquared (9/20/2011)
Depending on your ANSI NULLs setting, it might try.
SET ANSI_NULLS OFF;
CREATE TABLE #T (
ID INT PRIMARY KEY);
INSERT INTO #T (ID)
VALUES (1),(2),(3);
SELECT * FROM #T;
MERGE #T AS A
USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
SELECT * FROM #T;
Try that. You might be surprised by the results.
OK, so I guess now I owe you my house. :unsure:
Okay. I'll let you live there if you pay the bills, the mortgage, take care of the yard, et al. Won't even charge you rent! :w00t:

Dude, you don't own your house if you have a mortgage!

spaghettidba SSC Guru Points: 105732 More actions · Answer 13

GSquared (9/20/2011)
Gianluca Sartori (9/20/2011)
GSquared (9/20/2011)
Depending on your ANSI NULLs setting, it might try.
SET ANSI_NULLS OFF;
CREATE TABLE #T (
ID INT PRIMARY KEY);
INSERT INTO #T (ID)
VALUES (1),(2),(3);
SELECT * FROM #T;
MERGE #T AS A
USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
SELECT * FROM #T;
Try that. You might be surprised by the results.
OK, so I guess now I owe you my house. :unsure:
Okay. I'll let you live there if you pay the bills, the mortgage, take care of the yard, et al. Won't even charge you rent! :w00t:

Looks like a good deal...

...

... for the bank! 😛

-- Gianluca Sartori

WayneS SSC Guru Points: 95460 More actions · Answer 14

GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).

I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 15

WayneS (9/20/2011)
GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).
I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.

But think of the damage you may be causing - a world shortage of semicolons resulting from overuse by certain people would be a major catastrophe. :hehe::hehe::hehe:

Tom