Krishna Sonti

An Introduction To Linked Servers

Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.

3.14 (7)

2007-06-08 (first published: )

47,316 reads

ScriptToFindWhichTablesBelongToWhichFileGroups

If we give SP_HELP , we'll know to which File Group the table belongs.If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group. But have you ever tried that, given a file group, how to find all the tables that belong […]

2004-05-10

131 reads

Blogs

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

CRM Data Source Connection Error

By

This article takes us to the edge with a couple of CRM related errors...

Read the latest Blogs

Forums

Recruitment question

By mcmiller1986

Thanks for fielding this question in advance: We are searching for a Microsoft SQL...

SQL Group by in STUFF function

By chowdarydeepus@gmail.com

I have one question in SQL and would like to take some help from...

Two beginner Availability Groups questions

By webrunner

Hello experts, I'm an accidental DBA who recently joined a new group, and I'm...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers