Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SQL Server 2005 Best Practices Expand / Collapse
Author
Message
Posted Monday, August 20, 2007 2:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, March 14, 2008 2:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 7, 2014 7:31 AM
Points: 14, Visits: 60
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
Posted Friday, March 14, 2008 2:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:22 AM
Points: 2,684, Visits: 2,438
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
Posted Monday, March 17, 2008 4:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, March 18, 2008 1:49 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:26 AM
Points: 5,335, Visits: 1,383
The article seems incomplete and it is not a 'Best Practice' ariticle also. There are lot of gaps in the informations.




Post #470669
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse