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.
2007-10-02 (first published: 2004-06-02)
47,927 reads
2004-10-29
2,673 reads
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
136 reads
It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
2002-09-19
326 reads
Look, we all know data is king these days. But having mountains of data...
This topic keeps coming up with my customers so the purpose of this blog...
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
Hi, how to send emails on Azure Hyperscale server and which sp we...
I was trying to access SSRS report in host server browser , throwing an...
Sorry, more bakery stuff. Say I buy ingredients over time and I want to...
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers