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,283 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

Azure Synapse Analytics new features

By

Almost lost in all the announcements from Ignite was a bunch of amazing new...

Docker, Git and DBATools

By

For those who don’t know, last week was the PASS Summit. It’s an amazing...

SQLSaturday Orlando Notes – Coffee

By

I like to say that the goal for any event is to meet the...

Read the latest Blogs

Forums

result in same line

By patdev99

Hello,   trying to query the result by success or failure in 2 seperate...

Dropping SP's safely

By sizal0234

Hi, Is the below script good to delete 3 sp's... Please let me know...

SQL 2017 Listener with Read-Scale (Clusterless environment) AG not working

By JP10

Hello, I have a Read-Scale AG set up.  I have it failing over back...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers