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 tre... Read More »
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 perf... Read More »
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... Read More »
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 &bull... Read More »
The figure of Database file growth is very important for a database administrator to check. Many hosts restrict the size of MS SQL database for their clients. In such case, database admi... Read More »
