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
Category: T-SQL Reference
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.
Calculating Datetime Based on NT Time
A colleague of mine gave me an interesting challenge today. I am by no means a T-SQL expert, however it was interesting dissecting the problem.
INSERTED and DELETED Logical Tables
The INSERTED and DELETED logical tables that exist in SQL Server and allow for handling the data when information is inserted, updated and deleted in