SQL 2005 Dev

Content related to developing in SQL Server 2005

Improving delete operations with SQL Server

4
Your rating: None Average: 4 (1 vote)

The SQLCAT team blog has a great tip on deleting rows efficiently to help preventing blocking and minimize log file growth http://sqlcat.com/msdnmirror/archive/2009/05/20/fast-ordered-delete.aspx.

Great database design tips

0
Your rating: None

Louis Davidson (Dr. SQL) has a great book on the subject, but he also posted a great shorter version on simple-talk. Always a good reminder for us all...http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

Lookup table advice from Joe Celko

0
Your rating: None

Lookup tables or Entiry-Attribute-Value (EAV) tables are often used in SQL programming. Joe as always gives some great advice on how to properly design these kind of tables. http://www.simple-talk.com/sql/t-sql-programming/avoiding-the-eav-of-destruction/ His use of a view to prevent SQL engine from intent locking is a great idea that is new to me, I will have to remember that one.

Great SQL Functions You Should Know

0
Your rating: None

The guys over at less than dot have a great top 10 SQL Server functions you should know, that you probably have ignored until now (if you read it). http://wiki.lessthandot.com/index.php/Ten_SQL_Server_Functions_That_You_Have_Ignored_Until_Now

Data Dude - Visual Studio 2008 Database Edition GDR R2 Released

0
Your rating: None

If you are using the Visual Studio Team System Database Edition (Data Dude), you will want to upgrade to the latest version that came out at end of April 2009. http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en
Reason's to update:

Latest Books On Line (BOL) Downloads

0
Your rating: None

Make sure you have the latest version on your desktop and your servers.
SQL 2005 Latest version Dec 2008.
SQL 2008 Lastest version May 2009.

SQL Server Cheat Sheets

3.75
Your rating: None Average: 3.8 (12 votes)

I want to create a compendium of cheat sheet sites that I think are good for SQL Server. And if I can't find anything good, I was going to create my own.

SQL Server DBA focused

A simplified BOL site includes more than DBA info - http://www.ss64.com/sql

Pinal Dave has attempted to create a one page version for SQL 2008.

SQL Server Myths

0
Your rating: None

The PSS Team blog (Bob Dorr wrote article) has a great discussion on a couple of common myths for SQL Server performance:

  • SQL Server Uses One Thread Per Data File
  • A Disk Queue Length greater than 2 indicates an I/O bottleneck

 http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
Summary notes from article:

Excellent intro to reading execution plans

0
Your rating: None

Grant wrote an excellent introductory article on execution plan basics and has a more detailed ebook for sale on lulu.com. http://www.simple-talk.com/sql/performance/execution-plan-basics. Code listing link.

TCP Optimization for Windows

0
Your rating: None

 

Your NIC card configuration settings maybe the cause of slow file copies over your wide area network (WAN). Also, know that Windows Explorer file copy is designed to throttle its network usage, so use Robocopy, Richcopy, FTP, etc instead.