MS SQL Database Servers Articles

Store Procedures Vs User Defined Functions is MS SQL Server

SQL Server user-defined functions and stored procedures offer similar functionality. Both allow us to create bundles of SQL statements that are stored on the server for future use. This offers a tremendous efficiency benefit, as you can save programming time.     1. Reusing code from one program to another &......

Basic Administrative Tasks For MS SQL Database Server

If we want to keep server in top running conditions then we must have to perform regular maintenance from administrative levels. Each one has described as below: The First maintenance task is to perform regular backups . Without a backup strategy there may a chance to loose the data. This task is includes taking backups, rest......

An Introduction To MS SQL Database Server Roles

In MS SQL database server some user have total access of the server so they can do what ever they want while some usiers can only able to manage security. To Limit the amount of administrative access for a user Server Roles are defined. All the server roles are described as under with highest administrative access granted: ......

Features of MS SQL 2005

Here are summary of some useful features of MS SQL 2005 Edition: MS SQL 2005 Express: • Number of CPUs: - 1 • 1 GB max memory limit for buffer pool • Database Size: - 4GB • SQL Server Agent • Full Text Search • Advanced Integration Services MSSQL 2005 Workgroup Edition: ......

Stored procedure to check MS SQL database size growth

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:\"Table Normal\"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:\"\"; ......