Browse by Tags
All Tags »
version (RSS)
DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the
Read More...
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology
Read More...
You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this
Read More...
JDBC driver for SQL Server is not part of the Java SDK. To set the classpath to include the sqljdbc.jar file if you want to use it. The sqljdbc.jar file is installed in the following location: < installation directory >\sqljdbc_< version >\<
Read More...
No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000
Read More...
A stream of database compatibility numbers has come up to my mind while we are performing few configuration changes to the database to support a legacy application that can work upto SQL Server 2000. So what number we used during the days of SQL Server
Read More...
You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that
Read More...
A big question for every SQL Server user when a new version is released! Indeed, this was my question initially when looked at Microsoft SQL Server website homepage where the site is fully equipped with SQL Server 2005 version. It is more important for
Read More...
http://sqlserver-qa.net/blogs/bc/archive/2007/03/17/what-is-your-way-easy-to-upgrade-from-previous-versions.aspx
Read More...