Archive for September 2008
Understanding RAID
Posted by: Manpreet Singh on: September 18, 2008
Fault-Tolerant Disk Systems Is the best way to protact your sql server from crashing down. In 1988, a specific scheme that uses multiple disks for data redundancy was defined. This scheme was called Redundant Array of Inexpensive Disks (RAID). RAID defines several levels of redundancy using a number of disk drives. What sets RAID apart [...]
Save Stored Procedure text to a text file in SQL Server 2005
Posted by: Manpreet Singh on: September 15, 2008
- In: Export| SQLCMD
- 4 Comments
Yesterday, somebody has asked me for a way to Save Stored Procedure text to a text file. I have told him to use management studio for this. But he told me that he needs each stored procedure to be in different file and he also want it to run as a schedule task I tried [...]
SQL Server Naming Conventions
Posted by: Manpreet Singh on: September 9, 2008
- In: General| RDBMS
- Leave a Comment
Naming conventions are as important as a solid design to database. It is very important to name your table, views and stored procedure in a ways so that anyone could easily understand the query or structure of table in first glance. Poor naming convention can result in a lot of problems for both yourself [...]
SQL Server 2005 in a Virtual Environment
Posted by: Manpreet Singh on: September 1, 2008
Today, in IT world the next hot thing in discussion is the concept of virtualization. A survey from a reputed firm shows that more then 50 percent of application running on individual physical server consumes only 10 percent of CPU on an average and I/O and data transfer rates are also low. Companies of [...]
