SQL Server sample databases were always delivered with the product. Not so in SQL Server 2008. Microsoft decided to de-couple the dependency and have us download the samples for free from codepex.com.

Let’s use SQL Server Enterprise Manager to add a Windows group to a Pubs database (a sample database that comes with SQL Server 2000) role. The first step is to create a login for the members of ...

PAGEIOLATCH_*—Buffer latches, including the PAGEIOLATCH_EX wait type, are used to synchronize access to BUF structures and associated pages in the SQL Server database. The most frequently occurring ...

For this example, I’m choosing the AdventureWorksLT sample database as the source (Figure B). The next step is to create a server to host your SQL database. In the Server section, click the ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep ... you must be aware that a bare date (like "2017-10-31" in my sample query) includes a time: It's midnight in the ...