Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...

Archives: March 2010

Indexes - where you cannot create them!

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

2 comments, 966 reads

Posted in Dukagjin Maloku - Dugi'DBA on 29 March 2010

SQL Server 2008 R2 - The list of the supported features

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

1 comments, 451 reads

Posted in Dukagjin Maloku - Dugi'DBA on 24 March 2010

SP_SPACEUSED & SP_MSTABLESPACE

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".

SP_SPACEUSED

Yes, it is documented store procedure inside the SQL Server 2008 (incl,… Read more

3 comments, 1,635 reads

Posted in Dukagjin Maloku - Dugi'DBA on 22 March 2010

Info about Maximum specifications for SQL Server 2008/2005

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

0 comments, 650 reads

Posted in Dukagjin Maloku - Dugi'DBA on 21 March 2010

Determine which version of SQL Server is running...

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

0 comments, 437 reads

Posted in Dukagjin Maloku - Dugi'DBA on 20 March 2010

A little restriction that prevent changing tables in SQL Server 2008

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

4 comments, 1,587 reads

Posted in Dukagjin Maloku - Dugi'DBA on 20 March 2010

SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)

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

0 comments, 255 reads

Posted in Dukagjin Maloku - Dugi'DBA on 6 March 2010