Many times the administrators ask about the transaction log size limit and how to shrink it. Even the log records are not managed properly and
Ways of Managing SQL Server Database Fragmentation
If you are an SQL admin or user, you must be familiar with the term” fragmentation.” In every SQL Server, indexes get fragmented as the
Quick Methods to Restore Database from MDF File Only
“Recently, my system has encountered a severe breakdown. I lost most of my files and applications attached to it. Luckily, the MDF file of the
Learn How to Find Who Deleted Records in SQL Server
Query 1: “Hello friends, I am writing for the first time hoping that some of the learned friends can help me sort out the problem.
Where have I been?
Lost I guess. I had to put my blog on the back burner while I focus on life and work. I hope to come back
Quick Things to Do When DBCC CHECKDB Display Corruption Message
Have you ever wondered that you are working on Microsoft SQL Server and database shows some abnormal file crash or error issue? And, when you
SQL Canada (SQLCAN) 