Jason Shadonix

Practical Uses for Synonyms in SQL Server

The concept of a synonym was introduced in SQL Server 2005. Synonyms are very simple database objects, but have the potential to save a lot of time and work if implemented with a little bit of thought. This article discusses what exactly a synonym is, and a few examples of how to use them.

4.06 (54)

2016-06-24 (first published: )

20,548 reads

Blogs

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

SQL Server Authentication

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Daily Coping 4 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Physical db changes stored in transaction log file?

By madEG

Hello, I'm trying to understand what is needed to support a development team when...

Daily Coping 5 Jun 2020

By Steve Jones - SSC Editor

Today’s tip is to decide to look for what’s good, even on difficult days....

Query last too long

By aureliu

Hello,   I have this execution plan and the query last   24 h. How...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers