Admin posted on October 6, 2009 14:57

It's never too early, buddy.

 

You should start looking at these now.  Why? Because you are now developing and rewriting database objects for SQL Server 2008 - why use these items when you know that they're on the short list?  You can find them by using the following:

 

SELECT object_name, instance_name, cntr_type

from sys.dm_os_performance_counters

where object_name = 'instancenamehere:Deprecated Features'

 

 

Lee

 

 

---------------------------

 

I never knew that you could create a temp table with the name of # (it's deprecated LOL).  What kind of idiot...?

CREATE TABLE # (CustID int PRIMARY KEY)

 

http://planetsmilies.net/party-smiley-7500.gif

 


blog comments powered by Disqus

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog