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

Daily Coping 1 Oct 2020

By

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

PASS Virtual Summit 2020 Conference Sessions

By

Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...

Running Express Edition in a Container–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Internal Query Processor Error: The query processor could not produce a query pl

By YSLGuru

Is there a standard method for troubleshooting the below error? Internal Query Processor Error:...

How to extract string between variable characters?

By C-M-A

Hi All, I've got a nasty column that I need to get the name...

Making 1 row from 2

By SQLHeap

I'm struggling a bit here. It seems easy, but I 'm not getting it....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers