Deprecated Features

Question

Post reply

Deprecated Features

Ron McCullough

SSC Guru

Points: 63877
More actions
August 4, 2010 at 8:43 pm

#225795

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[/url]
Before posting a performance problem please read[/url]

Viewing 15 posts - 1 through 15 (of 25 total)

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

Jostein Saethern SSCommitted Points: 1861 More actions · Answer 1

Jostein Saethern

SSCommitted

Points: 1861

August 4, 2010 at 8:48 pm

#1202460

None of the listed views exist.

UMG Developer SSChampion Points: 13482 More actions · Answer 2

Jostein Saethern (8/4/2010)
None of the listed views exist.

Are you using SQL Server 2008 or newer?

UMG Developer SSChampion Points: 13482 More actions · Answer 3

Nice question, thanks!

But for the record it is spelled deprecated not depreciated.

Jostein Saethern SSCommitted Points: 1861 More actions · Answer 4

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 6

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

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

honza.mf SSCertifiable Points: 5519 More actions · Answer 7

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.

See, understand, learn, try, use efficient
© Dr.Plch

Fozzie SSCrazy Points: 2222 More actions · Answer 8

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.

Toreador SSChampion Points: 11365 More actions · Answer 9

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 🙁

Toreador SSChampion Points: 11365 More actions · Answer 10

I've had a play with this on my development server, and the results seem a little curious. Apparently, I've used each of the collations Macedonian, Lithuanian_Classic, Korean_Wansung_Unicode, Hindi, Azeri_Latin_90, and Azeri_Cyrillic_90 - but I know for an absolute certainty (I'm the only person with access to this server) that I have not!

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 11

Toreador (8/5/2010)
I've had a play with this on my development server, and the results seem a little curious. Apparently, I've used each of the collations Macedonian, Lithuanian_Classic, Korean_Wansung_Unicode, Hindi, Azeri_Latin_90, and Azeri_Cyrillic_90 - but I know for an absolute certainty (I'm the only person with access to this server) that I have not!

I only just installed the other day, and I have the same counter values. Also 22 for DATABASEPROPERTY, one for sp_db_vardecimal_storage_format, 4 for syscolumns etc. My guess would be that it's either the installation of the AdventureWorks databases, or it's Managment Studio that uses a number of these do do it's normal things. It would be interesting to find out. There are a couple of Profiler counters for Depreciated features, so I've set that running and will see what turns up.

Duncan

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 12

Duncan Pryde (8/5/2010)
Toreador (8/5/2010)
I've had a play with this on my development server, and the results seem a little curious. Apparently, I've used each of the collations Macedonian, Lithuanian_Classic, Korean_Wansung_Unicode, Hindi, Azeri_Latin_90, and Azeri_Cyrillic_90 - but I know for an absolute certainty (I'm the only person with access to this server) that I have not!
I only just installed the other day, and I have the same counter values. Also 22 for DATABASEPROPERTY, one for sp_db_vardecimal_storage_format, 4 for syscolumns etc. My guess would be that it's either the installation of the AdventureWorks databases, or it's Managment Studio that uses a number of these do do it's normal things. It would be interesting to find out. There are a couple of Profiler counters for Depreciated features, so I've set that running and will see what turns up.
Duncan

OK, so right-clicking a database and selecting "Properties" generates a "Depreciation Final Support" event for DATABASEPROPERTY, and looking at the code used by Management Studio I can see the sp_db_vardecimal_storage_format in there as well. All interesting stuff. Still not sure where the Macedonian collation stuff comes in though.

Duncan

Dennissinned Ten Centuries Points: 1318 More actions · Answer 13

Dennissinned

Ten Centuries

Points: 1318

August 5, 2010 at 6:30 am

#1202683

Great DMV. Thanks for the question.

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 14

nise qwestion. two baad their iz two miny tipoz.

Converting oxygen into carbon dioxide, since 1955.