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 1234»»»

Critique - Common SQL Server Mistakes Expand / Collapse
Author
Message
Posted Thursday, January 20, 2011 10:24 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 1:49 PM
Points: 32,768, Visits: 14,929
This is a presentation that I have been working on and evolving at a few user groups. Is this abstract ok?

Abstract: This presentation looks at a number of common mistakes that people make in SQL Server. There are edge cases where these might not apply, but for the most part, these are mistakes that you do not want to repeat as you are building applications on the SQL Server platform.

The basic agenda:

* SELECT *
* Shrinking databases
* GUID as a Clustered Key
* Functions in the WHERE Clause
* IS NULL
* Multi-row triggers
* Indexing all Columns
* Cursors
* SA Account Usage







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1050970
Posted Thursday, January 20, 2011 10:40 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
I would add Schema qualifiers, Query Hints and Interleaving of DML and DDL

-Roy
Post #1050994
Posted Thursday, January 20, 2011 10:56 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:34 PM
Points: 15,442, Visits: 9,588
with(nolock)

'nuff said.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1051018
Posted Thursday, January 20, 2011 11:22 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
I am planning to write a controversial Blog regarding NO LOCK. I think you will broil me over red hot charcoal once I am done with it...

-Roy
Post #1051049
Posted Thursday, January 20, 2011 11:26 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:34 PM
Points: 15,442, Visits: 9,588
Roy Ernest (1/20/2011)
I am planning to write a controversial Blog regarding NO LOCK. I think you will broil me over red hot charcoal once I am done with it...


Nah.

Slow cooking is much better....


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1051051
Posted Thursday, January 20, 2011 11:30 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 1:49 PM
Points: 32,768, Visits: 14,929
Good feedback on this, however I'm more wondering if you think the abstract is well written. Does it make you want to go, or not go, to the session?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1051056
Posted Thursday, January 20, 2011 11:36 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:34 PM
Points: 15,442, Visits: 9,588
It looks a little too basic for me. I'd be more likely to present on that subject than to be on the receiving end of it.

Edit: Might want to fix the spelling on this thread too.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1051064
Posted Thursday, January 20, 2011 12:03 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 3,081, Visits: 11,230
You could expand with more on database design:
Failure to normalize
No primary keys or unique constraints
Inappropriate data types
Failing to define columns as not null
No foreign keys or DRI
No check constraints

Many problems are built into applications at the database design stage and turn the application into a giant mess of hacks to work around design failures.


Post #1051085
Posted Thursday, January 20, 2011 12:48 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:34 PM
Points: 6,997, Visits: 8,409
- Books online. and how to get there the easy way .
(highlight your keyword and hit shift+F1)

- point to "when using the query designer, this is how you assign table aliasses" !


- The importance of foreign keys, not only for data reliability, but how SQLServer actually will use this in your advantage. Grant has a great demo on that !! http://www.scarydba.com/2010/11/22/do-foreign-key-constraints-help-performance/
It is really an eye opener for most of my devs.

- chose a clustering index

- by default, index your foreign keys

- you need database maintenance !

- what's a sql cluster

- what's a DRP/backup/data loss

- how big will your table / database be at start, in 1 month, in 3 months, in 6 months,...

- consult your dba



However, if you overload, you'll just be another nagging pita dba
and the message is lost in a black hole :-(


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1051119
Posted Thursday, January 20, 2011 1:25 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:27 PM
Points: 12,185, Visits: 9,134
I would go to a session like this one.
I'm always eager to learn from more experienced people who have already learned from mistakes, so that I can avoid them

One question: what is wrong with IS NULL?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1051147
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse