To install the WideWorldImporters sample database, restore its backup file in SSMS and check the files and the row counts. This post explains the Full and Standard versions, the disk space you need, the permission trap, and three queries that prove the install worked.
Deleting Millions of Rows in Batches Without Filling the Log
Plan deleting millions of rows with bounded commits, an indexed cutoff, log reuse checks, and a clear choice of retention method.
Install SSMS: Setup and First Connection
To install SSMS, download the installer, run it, and connect to your server. This post explains why SSMS is separate from the SQL Server engine, how to fill in the first connection, what to do about the certificate error, and how to check the connection with one query.
Does Dropping Clustered Index Drop Primary Key on the Same Column? – Interview Question of the Week #083
Does dropping clustered index also drop the primary key on the same column? Here is the short answer, a follow-up to last week’s question on the reverse case.
SQL SERVER – Error: 14258 – Cannot perform this operation while SQLServerAgent is starting. Try again later
A client could not run any job and got Error 14258: Cannot perform this operation while SQLServerAgent is starting. Here is what caused it and how we fixed it.
SQL SERVER – Event 17058 – initerrlog: Could not Open Error Log File
SQL Server would not start and there was no ERRORLOG. Event 17058, initerrlog: Could not open error log file, came from missing permissions on the Log folder.
Detect Performance Problems in SQL Server With DMVs
To detect performance problems in SQL Server, start with four suspects and a few dynamic management views that show CPU waits, memory use and the system_health session. This guest post by Eduardo Castro explains where to look first.