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

Design Oversight - Preliminary Review Expand / Collapse
Author
Message
Posted Wednesday, August 15, 2001 12:00 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/designoversight-preliminaryreview.asp

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #773
Posted Monday, August 20, 2001 7:26 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
Brian

Great article Brian, only things worth adding:

a) FK columns that are not indexed
b) Cluster indexes on identity columns
c) No collected or stale statstics

Cheers

Chris





Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #20790
Posted Wednesday, August 22, 2001 1:44 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
Brian

Here is another script to list all columns that have a "char" datatype where they possibly should be "varchar".

select sysobjects.name, sysusers.name, syscolumns.name
from syscolumns, sysobjects, sysusers
where syscolumns.type = 47
and syscolumns.id = sysobjects.id
and sysobjects.uid = sysusers.uid
and sysobjects.xtype = 'U'
order by 2,1




Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #20791
Posted Wednesday, August 22, 2001 9:25 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
Sounds good, Chris, I like the suggestions and the script. Looks like I need to write a part II. :)



K. Brian Kelley
bk@warpdrivedesign.org


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #20792
Posted Monday, August 27, 2001 8:15 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
Brian

Here is another classic problem... in a recent system consolidation I ended up with 6 or so tables that shared the same name but in different case. Perhaps a more advanced script would be to compare columns (maybe later!).

-- List possible duplicate tables based on table-name

select a.name
from sysobjects a, sysobjects b
where upper(a.name) = upper(b.name)
and a.id <> b.id
and a.xtype = 'U'
and b.xtype = 'U'




Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #20793
Posted Wednesday, November 7, 2001 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 13, 2001 12:00 AM
Points: 1, Visits: 1
I tried the query and got all tables.....with or without indexes and primary keys?????





Post #20794
Posted Wednesday, November 7, 2001 1:25 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:10 PM
Points: 33,095, Visits: 15,202
Good job Brian. A great topic and definitely place for a Part II!!!

Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #20795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse