Deprecated features

Question

Deprecated features

Viewing 14 posts - 16 through 28 (of 28 total)

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

SanDroid SSChampion Points: 10068 More actions · Answer 1

I would also would like to thank the author for an easy Monday Morning question.

😎

It reminds me of the SAT prep classes that said when faced with two right answers always select the one that comes first. 😛

mtassin SSC-Insane Points: 23099 More actions · Answer 2

SanDroid (8/15/2011)
I would also would like to thank the author for an easy Monday Morning question.
😎
It reminds me of the SAT prep classes that said when faced with two right answers always select the one that comes first. 😛

I haven't done the SAT for over 20 years. ANSI_PADDING is also correct.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

SanDroid SSChampion Points: 10068 More actions · Answer 3

mtassin (8/15/2011)
SanDroid (8/15/2011)
I would also would like to thank the author for an easy Monday Morning question.
😎
It reminds me of the SAT prep classes that said when faced with two right answers always select the one that comes first. 😛
I haven't done the SAT for over 20 years. ANSI_PADDING is also correct.

I totally agree. But seems like it has been said enough you would hope.

sburcombe SSCrazy Points: 2460 More actions · Answer 4

Good question, poorly edited; should have been two answers.

Simone

David P Fisher SSC Eights! Points: 818 More actions · Answer 5

Spot on Simone - there should have been two answers!

Doing this post to get my point back 😛

The impossible can be done at once, miracles may take a little longer 🙂

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 6

OCTom (8/15/2011)
I like the fact that the author spelled deprecated correctly. I'm tired of seeing it spelled depreciated. 🙂

I think I depreciated the other answers 🙁

Didn't check them, have gotten out of the habit of checking for "correct" answers in the wrong ones. The question has been corrected and points awarded back.

Robert Davis One Orange Chip Points: 28027 More actions · Answer 7

Looks like I missed the fun. I was able to check two answers and got it correct.

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Robert Davis (8/15/2011)
Looks like I missed the fun. I was able to check two answers and got it correct.

Ditto

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

Rich Mechaber SSChampion Points: 11130 More actions · Answer 9

Feh, answered the question that arrived in my email this morning, which unfortunately wasn't the (corrected) question posted on the website at the time I answered.

Real lesson learned today from QotD -- re-read the question before issuing a COMMIT:

IF OBJECT_ID('tempdb.dbo.#QotD', 'U') IS NOT NULL DROP TABLE #QotD;

CREATE TABLE #QotD (Answer VARCHAR(100));

DECLARE @QotD_Email VARCHAR(MAX), @QotD_Web VARCHAR(MAX);

SET @QotD_Email = 'In a future version of SQL Server, which option will always be ON and generate an error when any applications explicitly set the option to OFF?';

SET @QotD_Web = 'In a future version of SQL Server, which two options will always be ON and generate an error when any applications explicitly set the option to OFF?';

BEGIN TRAN

INSERT INTO #QotD

(Answer)

VALUES

(

'SET ANSI_PADDING ON'

);

IF @QotD_Email = @QotD_Web

BEGIN

COMMIT TRAN

SELECT * FROM #QotD;

END

ELSE

BEGIN

ROLLBACK

SELECT 'Re-read the question! Version 2.0 has been posted....';

END

IF OBJECT_ID('tempdb.dbo.#QotD', 'U') IS NOT NULL DROP TABLE #QotD;

Rich

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

Thanks for the question. I'm glad it was fixed.

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

OCTom SSChampion Points: 11785 More actions · Answer 11

Steve Jones - SSC Editor (8/15/2011)
OCTom (8/15/2011)
I like the fact that the author spelled deprecated correctly. I'm tired of seeing it spelled depreciated. 🙂
I think I depreciated the other answers 🙁
Didn't check them, have gotten out of the habit of checking for "correct" answers in the wrong ones. The question has been corrected and points awarded back.

I appreciate the depreciation... or, something like that.

Thanks Steve.

Ken SSCoach Points: 17191 More actions · Answer 12

Thanks for the question. I too got to it after it was fixed.

pnewhart SSC Eights! Points: 983 More actions · Answer 13

SQLRNNR (8/15/2011)
Robert Davis (8/15/2011)
Looks like I missed the fun. I was able to check two answers and got it correct.
Ditto

Dido....:-P

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 14

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP