Krishna Sonti

Krishna been working as a SQL DBA for over 5 years.

I'm an MCDBA.

Currently working with Surgical Information Systems (as SQL DBA - Team Lead)(an Atlanta, US based company) at Hyderabad, India.


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,467 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 26 Jan 2021

By

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

Rowcount estimates when there are no Statistics

By

When you don't have statistics, what does SQL use to calculate the estimated number...

Synapse Analytics and .NET for Apache Spark Example 4 - JOINS

By

This is a bit of a longer one, a look at how to do...

Read the latest Blogs

Forums

Accessing a RESTORING database for test refresh

By Pete Bishop

I have a requirement whereby testers on ServerA need a copy of the production...

How to get value portion key to every rn from 1 to 3 row on one row?

By ahmed_elbarbary.2010

I need to get value portion key to every 3 row on one row...

Median Processing time, Average Procesisng time for created/closed date

By mnr123

  We have sharepoint as the data source and we have 2 dates created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers