Configuring SQL Database Mail

Here is a sample script for configuring database mail in the event you want to automate your SQL installs.      

How SQL Server processes a query

The logical order in which SQL Server parses a query and generates an execution plan: 1. FROM [left_table] 2. ON [join_condition] 3. [join_type]…

Using the KILL command

You can view the status of a KILL command used to stop an open transaction by typing the following:

Views – 469

About Replication

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…