Batch Analysis Report

www.sqlbrowser.com

Database Procs Tables Views Triggers Functions Rules Defaults Unscanned master     59/152           117/176 sybsystemdb     2/32           31/33 sybsystemprocs   599/608 35/36 1   1     10/646 tempdb     532/29           27/30

Defects
MBPA 6 Not a parameter of this proc	21
MURC 6 Unreachable Code	42
PERR 6 Parsing Error	83
QBGB 6 Bad group by	8
QCAR 6 Cartesian product	40
MRIT 5 Return in Transaction	19
QJWI 5 Join or Sarg Without Index	326
MBRV 4 Bad return value [-1-99]	14
MCPC 4 Copy Paste Code	668
MCTR 4 Conditional Begin Tran or Commit Tran	124
MEST 4 Empty String will be replaced by Single Space	578
MINU 4 Unique Index with nullable columns	13
MMCN 4 Potentially Misleading Column Naming	1
MPSI 4 Possible SQL Injection	8
MTYP 4 Assignment type mismatch	575
MULT 4 Using literal database 'tempdb'	88
MUSP 4 Unquoted String Parameter	229
QCAS 4 Cartesian product with single row	57
QCSC 4 Costly 'select count()', use 'exists()'	40
QPR1 4 Potential Recompilation: index creation after access to table	1
QPUI 4 Join or Sarg with Un-Rooted Partial Index Use	457
QTYP 4 Comparison type mismatch	2712
QUDW 4 Update or delete with no where clause	3
TNOI 4 Table with no index	47
TNOU 4 Table with no unique index	6
VOVR 4 Variable is an input param and is overwritten	1
VRUN 4 Variable is read and not initialized	25
VUWR 4 Variable is an output param and is not written to	3
CUNU 3 Cursor not updated: cursor should contain 'for read only' clause	91
CUSU 3 Cursor updated through 'searched update': risk of halloween rows	11
CUUP 3 Cursor updated: cursor should contain 'for update' clause	2
MBLI 3 Integer Value of Binary Literal is Platform Dependant	210
MDYN 3 Proc uses Dynamic SQL but is not flagged with Dynamic Ownership Chain	31
MGTP 3 Grant to public	622
MLCH 3 Char type with length>30	213
MNAC 3 Not using ANSI 'is null'	84
MNEJ 3 'Not Equal' join	13
MNER 3 No Error Check	4155
MUBC 3 Unbalanced begin tran/commit tran	3
MUCO 3 Useless Code	7955
MUIN 3 Column created using implicit nullability	171
MUOT 3 Updates outside transaction	41
MUPK 3 Update column which is part of a PK or unique index	21
MUTI 3 Update temptable with identity - 12.5.4 Regression	13
MUUF 3 Update or Delete with Useless From Clause	24
MZMB 3 Zombie: use of non-existent object	103
QAFM 3 Var Assignment from potentially many rows	924
QAPT 3 Access to Proxy Table	60
QCRS 3 Conditional Result Set	282
QCTC 3 Conditional Table Creation	230
QDIS 3 Check correct use of 'select distinct'	64
QFAP 3 Force abstract plan	21
QFID 3 Force index	18
QGWO 3 Group by/Distinct/Union without order by	105
QISO 3 Set isolation level	327
QIWC 3 Insert with not all columns specified	145
QJWT 3 Join or Sarg Without Index on temp table	258
QMTB 3 From clause with many tables	1
QNAJ 3 Not using ANSI Inner Join	689
QNAM 3 Select expression has no name	60
QNAO 3 Not using ANSI Outer Join	71
QNCO 3 No column in result set	2
QNUA 3 Should use Alias:	875
QPNC 3 No column in condition	134
QPRI 3 Join or Sarg with Rooted Partial Index Use	937
QPSC 3 Join on same column	2
QRPR 3 Repeated predicate	5
QSWV 3 Sarg with variable	242
QTJ1 3 Table only appears in inner join clause	44
QTLO 3 Top-Level OR	40
QUNI 3 Check Use of 'union' vs 'union all'	38
VNRD 3 Variable is not read	360
VUNU 3 Variable is not used	481
CRDO 2 Read Only Cursor Marker	70
CUPD 2 Updatable Cursor Marker	101
MDRV 2 Derived Table Marker	10
MDYE 2 Dynamic Exec Marker	65
MDYS 2 Dynamic SQL Marker	80
MRST 2 Result Set Marker	369
MSTT 2 Shared Temptable Marker	270
MSUB 2 Subquery Marker	1033
MSUC 2 Correlated Subquery Marker	121
MTR1 2 Metrics: Comments Ratio	601
MTR2 2 Metrics: Cyclomatic Complexity	601
MTR3 2 Metrics: Query Complexity	601

Statistics per Database

DB Size

Table Count

Avg Size

Tot Size

Avg Rows

Tot Rows

Avg Cols

Tot Cols

Proc Count

Avg Lines

Tot Lines

Avg Bytes

Tot Bytes

Avg Cyclo

Avg Cmplx

Tot Exec

Tot Sel

Tot Ins

Tot Upd

Tot Del

Tot If

Tot While

master

13 MB

59

27 KB

1.5 MB

222

13 K

14

845

sybsystemdb

6 MB

2

2 KB

4 KB

14

28

sybsystemprocs

172 MB

35

2.5 MB

88 MB

2.6 K

92 K

15

525

600

271

159 K

7.6 K

4.5 M

21

115

2.7 K

369

948

490

179

7.8 K

340

tempdb

104 MB

TOTAL

295 MB

96

956 K

90 M

1.1 K

105 K

15

1.4 K

600

271

159 K

7.6 K

4.5 M

21

67 K

2.7 K

369

948

669

7.8 K

340