In many cases, while we using DBCC commands, we must to run two statements instead of one, in order to receive the wishful result. For...

Once upon a time there was a database. The database was perfectly designed with beautiful tables and views accompanied by good-looking...

Many people get confused, thinking that SQL Server Profiler is the actual tracing feature of SQL Server, while in fact it is only an...