In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database ... with identity seed values and the T-SQL ...

How to Repair a Corrupted SQL Server database with the DBCC CHECKDB Command DBCC CHECKDB is a set of T-SQL commands to check the logical and physical integrity of SQL database objects in a SQL Server ...

In order to ensure consistency, you need to run the DBCC CHECKDB SQL Server command regularly. I'll talk more about CHECKDB later in this article. First, let's talk about database corruption.

BULK INSERT commands, or full-search queries. PAGEIOLATCH_*—Buffer latches, including the PAGEIOLATCH_EX wait type, are used to synchronize access to BUF structures and associated pages in the SQL ...