:::: MENU ::::

Posts Categorized / DBA Interview questions

  • Nov 05 / 2008
  • 0
DBA Interview questions, dbDigger

Arithmetic Abort Enabled (ARITHABORT) in SQL Server T-SQL

You can use Arithmetic Abort option to determine the behavior of certain exception conditions. When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, a query is terminated when divide-by-zero error or overflow occurs during query execution. When set to FALSE, a warning message is displayed when one of these errors occurs, but the query, batch, or transaction continues to process as if no error occurred.

  • Nov 05 / 2008
  • 0
DBA Interview questions, dbDigger

SQL Server 2005 sample databases AdventureWorks and AdventureWorksDW

The AdventureWorks and AdventureWorksDW are two sample databases introduced in SQL Server 2005. The AdventureWorks database is an online transaction processing (OLTP) sample database while the AdventureWorksDW is a data warehousing sample database. AdventureWorks and AdventureWorksDW have replaced the pubs and Northwind databases of earlier versions of SQL Server.
Both of these sample databases can be installed from client tools during installation as shown. Or you may download these separately from here and install/attach.

SQLServer 2005 Sample databases

  • Oct 27 / 2008
  • 0
DBA Interview questions, dbDigger, Hardware and Platform, Performance Tunning and Optimization

Scenarios when SQL Server 2000/2005 64-bit is recommended

Microsoft had provided 64-bit support since SQL Srever 2000. So for SQL Server 2000 and SQL Server 2005 DBA always have a choice to choose the 32-bit version and 64-bit version. 64-bit supported hardware is primary requirement. As 32-bit SQL Server can be used on 64-bit architecture machine, so it becomes a matter of choice to choose between the two SQL Server architectures. There are some very specific scenarios in which it becomes highly recommended to use SQL Server 64-bit

  • When number of concurrent users and sessions are in thousands
  • Database is over 100 GB
  • Database is heavily growing
  • If going to buy new system, its better to migrate on 64-bit platform rather to adopt it later with more changes required.

Click here to read all posts related to Hardware and OS related to SQL Server

  • Oct 27 / 2008
  • 0
DBA Interview questions, dbDigger, Hardware and Platform

Hardware Platforms for SQL Server 2005

SQL Server 2005 is supported on following three platforms

* X 86 platforms (32 bit)
* X 64 (X86-64) platforms (64 bit)
* And Itanium platforms (64 bit)

X86 and X64 chips are with same architecture while Itanium uses a different architecture.

X86 can access physical memory up to 64 GB using PAE and AWE and 4 GB of virtual memory. Intel and AMD have introduced processors that support both X86 and X64 architectures on same machine.

X64 can access up to 1-4 terabyte of physical memory and 256 terabyte of virtual memory. X64 is flexible platform, can work as 32-bit or 64-bit depending upon what operating system is installed. If 64-bit OS is installed even then 32-bit applications run. For SQL Server 2005, it is recommended that 64-bit version of SQL Server 2005 should be used with 64-bit OS (Windows Server 2003).

Itanium architecture is also known as IA-64 architecture. It can address physical memory up to 1 petabyte with 50-bit physical addressing mode. Virtual memory up to 60 exabyte may be addressed in 64-bit addressing mode. Microsoft has also introduced versions of Windows XP, Windows 2000 and Windows 2003 for Itanium processors. So SQL Server 2005 64-bit may be used on Windows 2000 and Windows 2003 on Itanium. A version of SQL Server 2000 is also available for Itanium but only with server components.

Click here to read all posts related to Hardware and OS related to SQL Server

  • Sep 30 / 2008
  • 0
DBA Interview questions, dbDigger, Indexes, Performance Tunning and Optimization

Why to create more than one spatial index on SQL Server table

Question: Why would you create more than one spatial index on the same spatial column in SQL Server 2008?

Answer: To set different tessellation parameters

Explanation: The primary reason for creating multiple spatial indexes on the same spatial column is to apply different tessellation parameters to the index. The tesselation process fits the data in the column into a grid area, allowing faster queries. Different parameters might result in grosser or finer grids applied.

Ref: Spatial Indexing Overview –

Note: The Question is taken from SQLServercentral.com.

  • Sep 27 / 2008
  • 0
DBA Interview questions, dbDigger

Code names of Microsoft SQL Server family

I have noted that at many places SQL Servers are referred with their code name rather than their version. Code names are awarded while a product is in process before launching to market. Microsoft usually does not announce a final name until shortly before the product is publicly available. So it is good to share here a list of code names awarded to SQL Server family by Microsoft.
Known as SQL Server 6.0. It was the first version of Microsoft SQL Server that was designed for Windows NT

Known as SQL Server Enterprise Manager. Management tool, included in SQL Server 6.0 – SQL Server 2000

Known as SQL Server 6.5. It is same as Terminal Services, Terminal Server

Known as SQL Server 7.0.

Known as SQL Server 7.0 OLAP Services. It was (later called Analysis Services, in SQL Server 2000

Known as SQL Server 2000 (32-bit). It is version 8.0

Known as SQL Server 2000 (64-bit). It is version 8.0, Intel Itanium based system only

Known as SQL Server Reporting Services.

Known as SQL Server 2005. It is version 9.0

Known as SQL Server 2005 Mobile Edition.

Katmai / Akadia
Known as SQL Server 2008. It is Version 10

Known as SQL Report Designer 2.0. This is the stand alone release of the tool for SQL Server Reporting Services.

Consult us to explore the Databases. Contact us