Critique - Common SQL Server Mistakes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Presentations and Speaking » Critique - Common SQL Server Mistakes

40 posts, Page 1 of 4

1 2 3 4 »»»

Critique - Common SQL Server Mistakes

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Thursday, January 20, 2011 10:24 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

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

Roy Ernest

Posted Thursday, January 20, 2011 10:40 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:29 AM
Points: 3,280, Visits: 6,626

I would add Schema qualifiers, Query Hints and Interleaving of DML and DDL

-Roy

Post #1050994

GSquared

Posted Thursday, January 20, 2011 10:56 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

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

Roy Ernest

Posted Thursday, January 20, 2011 11:22 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:29 AM
Points: 3,280, Visits: 6,626

I am planning to write a controversial Blog regarding NO LOCK. BigGrin

I think you will broil me over red hot charcoal once I am done with it... BigGrin

-Roy

Post #1051049

GSquared

Posted Thursday, January 20, 2011 11:26 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

Roy Ernest (1/20/2011)

I am planning to write a controversial Blog regarding NO LOCK. BigGrin

I think you will broil me over red hot charcoal once I am done with it... BigGrin

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

Steve Jones - SSC Editor

Posted Thursday, January 20, 2011 11:30 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

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

GSquared

Posted Thursday, January 20, 2011 11:36 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

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

Michael Valentine Jones

Posted Thursday, January 20, 2011 12:03 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:14 PM
Points: 2,969, Visits: 10,615

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

ALZDBA

Posted Thursday, January 20, 2011 12:48 PM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 2:13 PM
Points: 6,866, Visits: 8,071

- 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 Wink

and the message is lost in a black hole :-(

Johan

     Jul 13

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

- 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" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1051119

Koen Verbeeck

Posted Thursday, January 20, 2011 1:25 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 9,410, Visits: 6,495

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 Smile

One question: what is wrong with IS NULL? Blush

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 »

40 posts, Page 1 of 4

1 2 3 4 »»»

Permissions