Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud
.net .net 4.0 asp.net asp.net mvc azure backup book bug business intelligence c# cloud computing community database dmv excel google gotcha help high availability how to howto interview linq mirroring mvc nhibernate nunit performance programming reportviewer rhino mocks security silverlight sql sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 ssis structuremap t-sql tip trick vb.net visual studio 2010 vmware windows 7 wpf
Authors
- SQLDenis (297)

- chrissie1 (234)

- Ted Krueger (onpnt) (130)

- George Mastros (35)

- Alex Ullrich (29)

- tarwn (28)

- naomi (11)

- thatrickguy (11)

- chaospandion (8)

- ca8msm (8)

- damber (7)

- emtucifor (7)

- More...
Main Categories
Search
Google Ads
Tags: performance
12 ways to break your database server before the first transaction
Defaults hurt. They take a 3 inch splinter and try to bury it as far up and under your nail as far as they possibly can. Every database server has a task. A mission if you will. That mission is to serve the data and secure the data. Some need 32GB of RAM; some need 3GB of RAM. This one might need 32 spindles on RAID 3 billion.
Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform
You see this kind of question all the time in newsgroups/forums, someone wants to return all the rows if nothing is passed in or just the rows that match the variable when something is passed in. Usually someone will reply with a suggestion to do something like this
WHERE (SomeColumn=@col OR @col IS NULL)
The problem with that approach is that it doesn't perform well, let's take a look, first create this table
Lee Everest created a post named MongoDB vs. SQL Server - INSERT comparison where he compared inserting 50001 rows with MongoDB vs. SQL Server. So he claims that MongoDB inserts 50001 rows in 30 seconds while the SQL Server one takes 1.5 minutes. Okay so I looked at this SQL Script and can make 2 improvements
First create this table
Index DMV usage considerations
Index DMV/DMF goodness! SQL Server 2005 and up has given us the ability to truly be more efficient in gathering information in which we can be more proactive. With everything these objects give us, a price has to be paid. We will discuss that price but first, we’ll go over a few major features that DMV/DMF has provided to us in regards to indexes to help us in our daily tasks.
Yesterday I made a post about using a queue instead of a list because the code was so much cleaner. I think it is very important that code is clean and easier to read.
But then Denis asked about the performance differences between the 2 methods. I hadn't worried about the performance, because in my case the performance was good in both cases.
But I aim to please my fellow LTDers, so I did a little performance test. And let me remind you that like most performance tests, this one ...
:: Next >>


LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.