What does this return?

select (1324 & 1024)

How are modified extents tracked in SQL Server...

You are looking to import a large amount...

Introduction to SQL Server Management Studio

SQL Server Management Studio is used to manage, query and design SQL Server solutions. In this video you're shown the basics of how to use Management Studio.

Database Snapshots in SQL Server 2005

One of the brand new features in SQL Server 2005 is the database snapshot. New authors Arvinder Singh Khosla and S.Srivathsani Murthy bring us a look at how these static view databases can be setup and used in your environment.

Which of the following is not something the...

What does the max full-text crawl range option...

Data partitioning in SQL Server 2005 - Part III

Part III of the article series illustrates how to partition an existing table with data into four different file groups.

Moving Your Database to a New Server

As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.

You are loading 100 rows of data into...