This blog will no longer be updated.

New content is available on my new blog

data access,t-sql - Piotr Rodak

Browse by Tags

All Tags » data access » t-sql (RSS)

DATA ACCESS setting on local server

When you look at the sys.servers catalog view, you will see list of linked servers defined on the server plus one additional row for the server itself. You can distinguish the local server from linked servers by column server_id, which in case of local...

MARS - does anyone use it?

I read recently about MARS - Multiple Active Result Sets, functionality that came with SQL Server 2005. I tried to find some 'real life' example of using MARS. Most of the resources I found showed examples on AdventureWorks database and they were...
Posted by Piotr Rodak | with no comments
Filed under: , , ,