SQL

Sometimes while using transaction in SQL Sesrver you get the following error: The ROLLBACK TRANSACTION request has no corresponding BEGIN...

The below  script uses sys.dm_db_index_usage_stats to get timestamps for the last read and write operations on a database.   SELECT   DB_...

If you are trying to update a column using an aggregate function like SUM, MAX or MIN etc the following error will come. Server: Msg 157,...

Sql Mail System provides an easy way to sent and receive emails using microsoft sql server. But you should have to install a MAPI susystem ...

Advantages of indexed views To Improve the performance of select queries Index data on columns on multiple tables The data from multipl...