SQL Server 2005 Best Practices

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 Nanda Kishore » SQL Server 2005 Best Practices

25 posts, Page 3 of 3

«««1 2 3

SQL Server 2005 Best Practices

Rate Topic

Display Mode

Topic Options

Author

Message

pamarant

Posted Monday, August 20, 2007 2:38 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 30, 2010 6:29 AM
Points: 16, Visits: 126

Yes, I was looking for a best practices document outlining such as in this doc for sql 2000:

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

Post #392247

JCass

Posted Friday, March 14, 2008 2:04 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 11, 2013 4:53 AM
Points: 12, Visits: 51

What does this mean:
"If you are using any object type code as “S” this will not work. System tables (S) are not exposed"

Does it mean you can not use S as a table name for instance?

Post #469225

kevriley

Posted Friday, March 14, 2008 2:49 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

Think you are referring to the 'type' column in sys.objects

From BOL, values for this are
type char(2) Object type:

AF = Aggregate function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
PK = PRIMARY KEY constraint
P = SQL stored procedure
PC = Assembly (CLR) stored procedure
FN = SQL scalar function
FS = Assembly (CLR) scalar function
FT = Assembly (CLR) table-valued function
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) DML trigger
TR = SQL DML trigger
IF = SQL inline table-valued function
TF = SQL table-valued-function
U = Table (user-defined)
UQ = UNIQUE constraint
V = View
X = Extended stored procedure
IT = Internal table

Post #469231

seattle5050

Posted Monday, March 17, 2008 4:24 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 17, 2008 4:21 PM
Points: 1, Visits: 3

Agreed, not a best practice list. Some good information. You should have a 'tips' section - or simply a 'best practice' that others can add to and maintain.

Jim Teaks
http://www.mssqlonline.com/
editor

Post #470564

Anipaul

Posted Tuesday, March 18, 2008 1:49 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:03 AM
Points: 4,786, Visits: 1,335

The article seems incomplete and it is not a 'Best Practice' ariticle also. There are lot of gaps in the informations.

Sad

Post #470669

« Prev Topic | Next Topic »

25 posts, Page 3 of 3

«««1 2 3

Permissions