I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000.<BR><BR>Now the resulting data set will be about 10,000 records taken from ~ 8 ...

For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...