Wiley 978-0-470-05520-5 Datasheet

SQL Server 2005ArchitectureThe days of SQL Server being a departmental database are long gone, and SQL Server can noweasily scale to databases dozens

SELECT o.name AS ObjectName,c.name AS ColumnName,TYPE_NAME(c.user_type_id) as DataTypeFROM sys.objects o JOIN sys.columns cON o.object_id = c.ob

Data Type Stores Storage SpaceBit 0 or 1 1 byteTinyint Whole numbers from 0 to 255 1 bytesSmallint Whole numbers from –32,768 to 32,767 2 bytesInt Who

inserted. To get only the date out of a datetime data type, you must essentially “fool” the data type byconverting it:SELECT CONVERT(varchar, GetDate(

Edition of SQL Server allows you to have high-availability options, Enterprise Edition far outdoes itssister edition with higher-end clustering as wel

Database Features by EditionThe main benefit from one edition of SQL Server to the next are the features enabled. In the following setof grids, you ca

Feature SQL Express Workgroup Standard EnterpriseReport Subscriptions ✓✓Data-Drive Subscriptions ✓Report Builder ✓✓✓Report Manager ✓✓✓Infinite Drill-d

LicensingEvery DBA has probably received a dreaded licensing question or two, and we hope to answer some ofthose common questions in this section. The

SummaryIn this chapter, we covered the basic architecture for how SQL Server stores its data and how it commu-nicates. We also addressed the various d

04_055200 ch01.qxp 10/31/06 12:37 PM Page 18

Since SQL Server 2000, there has been a trend away from full-time Production DBAs, and the role hasmerged with that of the Development DBA. The trend

Business Intelligence DBAThe Business Intelligence (BI) DBA is a new role that has grown due to the increased surface area of SQLServer. In SQL Server

Industry TrendsWe’ll get into the SQL Server 2005 features momentarily, but you’ll notice a trend as you begin to see thelist. Feature after feature w

The transaction log’s most important purpose is to serve as an exact point in time in case you need torecover your database. Each data-modifying trans

System DatabasesThe system databases in SQL Server are crucial, and you should leave them alone most of the time. Theonly exception to that rule is th

just holds the schema and stored procedures needed to run your instance. You should always back upthe master database after creating a new database, a

dbo schema is called dbo.Employee. This table would be different from HumanResource.Employee, if youhad that table in the database. It is a best pract

SELECT login_name, COUNT(session_id) as NumberSessionsFROM sys.dm_exec_sessions GROUP BY login_nameIn fact, DMVs are also sometimes functions and acce