T-SQL Maintenance Plan Creation

Use this script ot be able to create DB Maintenance Plans fast. If you need to create the plans on servers similarly set up, edit the required parameters once, and when you create a new plan, you will only need to specify a database name and one task start time, run the script and the […]

2007-02-05 (first published: )

962 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Synapse Analytics and .NET for Apache Spark Example 3 - CTE()

By

The next example is how to do a CTE (Common Table Expression). When creating...

Read the latest Blogs

Forums

Group By and JOIN within SQL Server (when dealing with multiple columns)

By lynhudson1

I have 2 tables, df1, and df2. I would like to join the two...

Select "New Customer"

By gjoelson 29755

Hi , Has anyone tried to do this...I'm trying to select only "new customers"...

Get local server's alias in T-SQL

By schleep

Hello, I'm trying to get the server name programmatically. Even after I do this:...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers