When managing large SQL Server instances; the number of databases on a server sometimes start creating a headache to manage. If we can group the
Top Tips for Effective Database Maintenance
Tip Tips for Effective Database Maintenance
Inserting into Linked Servers
Recently I was trying to help someone on Microsoft Newsgroups with issue with Linked Server. When inserting into Linked Server directly via the SQL Statement
Default Schema in SQL 2005/SQL 2008
When you create a new AD group login in SQL Server and then create the Database user based of that login it is not possible
Activity Monitor in SQL 2008 …
It disappeared … So it seems; it no longer shows up under Management -> Activity Monitor. Even on-line books state it is there. I still
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
