Linked servers allows to issue SQL commands against OLE DB providers. Because Microsoft also makes available an “OLE DB Provider for ODBC Drivers”, it is also possible to issue queries against a variety of ODBC drivers. With linked servers and distributed queries, you can query all sorts of data sources and merge them on the […]
Posts Tagged ‘sql server’
October 23, 2011 by Francois · 3 Comments
Filed under: Administration, Performance
Social Tagging: collation • distributed query • linked server • query plan • remote query • sql server • statistics • sub-optimal query plan • TSQL • Use Remote Collation
Filed under: Administration, Performance
Social Tagging: collation • distributed query • linked server • query plan • remote query • sql server • statistics • sub-optimal query plan • TSQL • Use Remote Collation
May 6, 2011 by Francois · Leave a Comment
Filed under: TSQL
Social Tagging: @@IDENTITY • bug • INSERT • OUTPUT • SCOPE_IDENTITY() • sql • sql server • TSQL
Filed under: TSQL
Social Tagging: @@IDENTITY • bug • INSERT • OUTPUT • SCOPE_IDENTITY() • sql • sql server • TSQL
It is a common business case to have to reuse the auto-generated SQL Server’s IDENTITY value. One way to deal with the problem is to use the system function @@IDENTITY. For example:
April 29, 2011 by Francois · 2 Comments
Filed under: Performance
Social Tagging: Clustered • Heap • Index • sql • sql server
Filed under: Performance
Social Tagging: Clustered • Heap • Index • sql • sql server
Heap tables (tables without a clustered index) are generally not part of a good database design. Unless you never actually query your table, you should always put a clustered index on it. Heap table are generally slower on selects, updates and deletes. They are also generally slower on inserts if you decide to use a […]
RSS