Google Custom Search

Saturday, February 23, 2008

SQL 2005 Edition Comparision

SQL Server 2005 comes with different editions with each having features that are either available in the other or not. This document lists the comparison of the features available between the different editions
http://www.sql-articles.com/index.php?page=articles/edcomp.htm

Isolation Levels

This article provides an easy-to-understand view of what ‘Isolation Levels’ really mean and when to use which level. ‘Isolation Level’ is a setting that decides how data which is a part of an ongoing transaction is made visible to other transactions.

http://www.sql-articles.com/index.php?page=articles/isolevel.htm

Locks & Locking Hints

Locking, Locks and Deadlocks are words that a developer/DBA does not want to hear in real life but still there are possibilities that we hear them because of some bad code written. This article takes you on to the type of locks available in SQL server and the ways of avoiding them using the hints available. Before getting into know the types of locks and the hints available, let us see what is meant by a lock and a deadlock.

http://www.sql-articles.com/index.php?page=articles/lhints.htm

Moving System Databases

There are lots of articles, Links and sites that describe how to move system databases from the SQL default location to the location described by the DBA but still lot of users find difficult while moving them and land up in trouble. So I thought that I would just do a graphical way of moving the databases so that the users can use the same and enjoy the task.

http://www.sql-articles.com/index.php?page=articles/msysdb.htm

Upgrading to SQL Server 2005

As we all know that Microsoft has released SQL Server 2005 sometime back and is planning to release the next version KATMAI before end of 2008. Also it has announced the end of life cycle support for SQL Server 2000. It’s high time that we start with upgrading our instances with SQL Server 2005 and upgrade before the life cycles support ends.

http://www.sql-articles.com/index.php?page=articles/usql.htm

Query Plans & Planguides

Most developer DBAs have tough time tuning TSQL part of the database and application. And most people leave in middle of it either frustrated or can’t go beyond that. Here is a simple look on how to use the query hints and plan guides to tune the TSQL part of your database and application.

http://www.sql-articles.com/index.php?page=articles/query_plans.html

Memory Management in SQL Server

I have heard people asking me how SQL Server manages memory. The answer to this was very difficult with SQL Server earlier versions. And with SQL Server 2005 it has been simpler to explain and understand. SQL Server by default installation manages memory dynamically and has settings that it can well negotiate with the operating system for the need of memory. Let us look into the depth of the SQL Server memory management.

Read more of this on http://www.sql-articles.com/index.php?page=articles/memory_management.html

Check Identity

This will list out identity columns in a Database. This is compatible to SQL 2005 only.
http://www.sql-articles.com/index.php?page=Scripts/check_idenity.php

Connection Property

This script will list out the current connection properties on SQL 2005.

http://www.sql-articles.com/index.php?page=Scripts/conn_prop.php


Database Details

This will list out the Database properties of your database in sql server. This is compatible to SQL 2000 and 2005. Before you use the script make sure you have given the databasename for the parameter @dbname.

http://www.sql-articles.com/index.php?page=Scripts/db_details.php

Index Details for Tables

This script will list out the details of the indexes in a table.This is compatible to SQL 2000 and 2005.
http://www.sql-articles.com/index.php?page=Scripts/index_details.php

Permission List

This script gives a detailed information about permission for users in a database. This output lists Object name, Schema name, user name and permission. This is compatible only to SQL 2000.
http://www.sql-articles.com/index.php?page=Scripts/permission_list.php

Permission List SQL 2005

This script gives a detailed information about permission for users in a database. This output lists Object name, Schema name, user name and permission. This is compatible only to SQL 2005.

http://www.sql-articles.com/index.php?page=Scripts/permission_list_2005.php

Scripting User level Permission - SQL2000

This script gives a out script that can be used to script out the exising user permissions in a database.This is compatible only to SQL 2000.Don't forget to change the database name in paramert @dbname before using the script.

http://www.sql-articles.com/index.php?page=Scripts/scrip_user_00.php

Scripting User Level Permission SQL2005

This script gives a out script that can be used to script out the exising user permissions in a database.This is compatible only to SQL 2005.

http://www.sql-articles.com/index.php?page=Scripts/scrip_user_05.php

Server Property

This will list out the server properties of your sql server including the account under which your services run. This is compatible to SQL 2000 and 2005.

http://www.sql-articles.com/index.php?page=Scripts/ServerProperties.php

Table Space Details

This script will list out the details of the space used by each in a database.This is compatible to SQL 2000 and 2005.

http://www.sql-articles.com/index.php?page=Scripts/sp_details_tbl.php

Table and Column Details

This script gives a detailed information about tables and thier associated column properties for each database. This lists out Database name, owner name, table name, column name, data type, collation, etc. This is compatible to SQL 2000 and 2005.

http://www.sql-articles.com/index.php?page=Scripts/tbl_col_det.php

Trigger Status

This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.

http://www.sql-articles.com/index.php?page=Scripts/trigger_status.php