Deprecated Features

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » Deprecated Features

26 posts, Page 1 of 3

1 2 3 »»»

Deprecated Features

Rate Topic

Display Mode

Topic Options

Author

Message

bitbucket-25253

Posted Wednesday, August 04, 2010 8:43 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 5,123, Visits: 20,370

Comments posted to this topic are about the item <A HREF="/questions/Depreciated+Features/70490/">Depreciated Features</A>

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #963924

Jostein Saethern

Posted Wednesday, August 04, 2010 8:48 PM

SSCommitted

Group: General Forum Members
Last Login: Sunday, December 09, 2012 2:25 PM
Points: 1,555, Visits: 291

None of the listed views exist.

Post #963928

UMG Developer

Posted Wednesday, August 04, 2010 10:51 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 2,163, Visits: 2,151

Jostein Saethern (8/4/2010)

None of the listed views exist.

Are you using SQL Server 2008 or newer?

Post #963960

UMG Developer

Posted Wednesday, August 04, 2010 10:52 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 2,163, Visits: 2,151

Nice question, thanks!

But for the record it is spelled deprecated not depreciated.

Post #963962

Jostein Saethern

Posted Wednesday, August 04, 2010 11:33 PM

SSCommitted

Group: General Forum Members
Last Login: Sunday, December 09, 2012 2:25 PM
Points: 1,555, Visits: 291

UMG Developer (8/4/2010)

Jostein Saethern (8/4/2010)

None of the listed views exist.

Are you using SQL Server 2008 or newer?

I'm using 2008 R2. The correct answer is listed as sys.dm_os_sys_performance_counters, but in the example query sys.dm_os_performance_counters is used. sys.dm_os_sys.info should be sys.dm_os_sys_info. Not sure what the other two are supposed to be.

Post #963980

SQLRNNR

Posted Wednesday, August 04, 2010 11:50 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 3:33 PM
Points: 18,858, Visits: 12,443

Thanks for the question. I had to search a bit harder for this one due to the options in the answers.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #963988

Hugo Kornelis

Posted Thursday, August 05, 2010 1:21 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:45 PM
Points: 5,297, Visits: 7,240

Interesting question. Shame about the typos in the answer options, though - they almost made me miss the correct answer.

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #964027

honza.mf

Posted Thursday, August 05, 2010 1:45 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 1,115, Visits: 1,210

UMG Developer (8/4/2010)

Nice question, thanks!

But for the record it is spelled deprecated not depreciated.

I think the typo in title is not such a great problem. Both words exist.
I had worse troubles with spell checkers, I had to turn automatic corrections in Word off. Sometimes it created (unwanted) offensive combinations.

Thanks for the nice question.

Post #964034

Fozzie

Posted Thursday, August 05, 2010 2:46 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 3:42 AM
Points: 356, Visits: 759

Actually if you're on a case sensitive server it's:

SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%Deprecated%')

I didn't know about this, I don't know alot about the DM features of SQL 2008. Something I need to learn about, thanks for the question and highlighting it to me.

Post #964065

Toreador

Posted Thursday, August 05, 2010 2:50 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:27 AM
Points: 1,384, Visits: 4,881

Jostein Saethern (8/4/2010)

The correct answer is listed as sys.dm_os_sys_performance_counters, but in the example query sys.dm_os_performance_counters is used.

Well spotted - I was wondering why the 'correct' view does not exist in my database.
I went for the first option (assuming the final '.' was a typo) as it's the only one which exists.

A useful question as it's taught me something, but a shame a few more seconds weren't spent in proof-reading Sad

Post #964068

« Prev Topic | Next Topic »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions