Wednesday, August 27, 2008 Register   Login   
   You Are Here: Articles » SQL Server Articles (Categorized)     
 SQL Community Portal
  
 Recently Submitted Articles
  
 Recent SQL Clinic Articles
  
  
Redgate SQL Server Tools
  
 SQL Server Articles

     

Permalink
Thumbnail
BEST PRACTICES FOR WRITING BETTER SQL
Author :: Mahmud Hasan
Date :: Tue 08/12/2008 @ 12:27

The performance of SQL query that we write for different projects is a very crucial issue for us. In many cases we have to perform time consuming optimization work to come out from this performance related problems. Surprisingly, most of the time we succeed to improve our poor SQLs to an optimum level of acceptance. In my experience, when we worked on these optimizations we found, if we could follow some very simple practices of writing SQL and were a little more aware of performance, this issue could have been avoided from the beginning. So, our goal should be to write the best possible SQLs in our first attempt so that we do not need to spend our expensive time to optimize them later.



read article
RATING:   COMMENTS (3)
Permalink
Thumbnail
Multiple INSERTS using Row Constructors in SQL Server 2008
Author :: Sirisha Kommushetty
Date :: Fri 08/08/2008 @ 02:01
Row Constructors in SQL Server 2008 are a relief to single ton manual inserts. They definitely help boost the efficiency of I-Transactions (INSERT).
If you really want to second my statement J… then I bet you should have a quick look at the case study below.

read article
RATING:   COMMENTS (1)
Permalink
Thumbnail
Estimate Disk Space Needed for SQL Server Installation
Author :: Cindy Gross
Date :: Wed 07/16/2008 @ 04:40
In addition to raw disk space you will want to consider number of physical disks, SAN vs. local disks (direct attached storage), RAID level, number of controllers, and number of arrays. Along with that is the decision on how to spread your data, indexes, and logs over the various arrays. This reply will concentrate purely on the overall disk size question. However, I do want to emphasize that it is VERY important to properly layout your files over multiple disks on the correct type of RAID and these things will affect the amount of disk space you need. [READ MORE]

read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
How to Layout Disk LUNS for SQL Server
Author :: louis nguyen
Date :: Tue 07/15/2008 @ 11:47
This article summarizes the best practices for allocating disk LUNS for SQL Server for a standard SQL instance.
read article
RATING:   COMMENTS (2)
Permalink
Thumbnail
How to Configure Memory for SQL Server
Author :: Louis Nguyen
Date :: Tue 07/15/2008 @ 11:47
How to configure operating system and SQL Server settings for optimum memory management.
read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Preventing SQL Injection Attack
Author :: Cindy Gross
Date :: Tue 07/15/2008 @ 03:35
SQL Injection is a method where people are able to change the code submitted to SQL to something else. It’s not something you can prevent on the database side with a configuration change or anything like that, though improving your server side security is key. You have to change your stored procedures, functions, and dynamic TSQL code to not allow the potential for injection of other code. The same basic steps apply whether it is SQL Server, DB2, Oracle, or any other relational database. [READ MORE]

read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Paging in Sql Server
Author :: Kaushal Parik
Date :: Thu 07/10/2008 @ 06:57

Describes about implementing Paging functinality in Sql Server while having thousands of data in your database.


read article