Archives: March 2010
Indexes are the objects that DBA uses them everyday and maintaining them very often, during the maintenance routines. The main purpose that we use the indexes is to retrieve data as fast as it possible.
Types of indexes are:
Cluster - max 1 per table & more about the… Read more
The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions (DataCenter, Enterprise, Standard, Web, Workgroup, Express with Advanced, Express with Tools, Express). The list contains very usefull info about the fetures where the companies or users can find the… Read more
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005), and they are the documented one which is "sp_SpaceUsed" and undocumented one "sp_MSTableSpace".
A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).
SQL Server 2008 - Max Specification
SQL Server 2005 - Max Specification
There it is some big max possibility in SQL Server:
Database size - 524,272 TB
Databases per instance of… Read more
Since the early versions of SQL Server, from version 6.5 we can know and determine the latest version that we install in our machine. I will show you the list that determine the latest version of the SQL Server.
In SQL Server 2008/2005 (using SSMS) & 2000 (using Query Analyzer)… Read more
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and we want to change the datatype or adding any column in a table with SSMS (SQL Server Management Studio), and the SSMS will said to… Read more
SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
The content of this update includes 11 Presentations, 17 Demos, 10 Hands-on Lab and 17 Videos, yes it is lot of stuff!
It is dedicated for the SQL Server developers who build applications with Microsoft… Read more