SQL Server 2012 DatabaseMail Setup

  This is an enterprise solution for sending mails from the SQL Server database engine to SMTP servers. Introduction This is an enterprise solution for sending mails from the SQL Server database engine to SMTP servers.  SQL Server database applications can communicate with users through an email system. It provides features like scalability, security, and reliability. […]

Read More »

How to Partition an existing SQL Server Table

I have read many articles on SQL Server partitioning and how to create a partitioned table, but I have an existing SQL Server database that has a few very large tables that could benefit from partitioning. What are the steps required to partition an already existing table?   I will outline below, we can partition the table […]

Read More »