(Jagadish Chaterjee) This article mainly focuses on the new “output” clause introduced in Microsoft SQL Server 2005. In this article I shall also teach you about producing output for DML statements, which could not be done in any of the previous versions of SQL Server. I shall give examples of sever

(Jugal Shah) SQL Server performs a couple of internal steps before executing a query. The steps that interest us here are compilation and execution.

(Arthur Fuller) In the typical dev environment, there is a development server, a functional testing server, a quality assurance server, and one or more production servers. Let’s suppose that your mandate is to modify a table on the development server, adding a column or changing a column’s name or d

(Soshan Fernandes) I was currently working for a company name Hermz Software which needed to create reports using SQL Server Reporting Services as it’s reporting tool. As far as creation of reports is concerned, I didnt have much problems!! However, the delivery of the reports were to be done based

(Mirko Marovic) Two frequently asked related questions in Microsoft SQL Server discussion groups are: –How to pass an array to a stored procedure? –How to select data based on a list of values?

(Michelle Gutzait) As a DBA, you may need to work in multi-collation environments. You have different development teams, as well as packaged software from different vendors, and you have to satisfy everyone’s needs regarding collation type. (R)

(Bob Beauchemin and Dan Sullivan) Whether you access data from the client, middle tier, or server, when you’re using SQL Server and the .NET Framework, you use the SqlClient data provider. Your data access code is similar regardless of its location, but the .NET Framework 2.0 version of SqlClient co

This article describes that Microsoft SQL Server 2000 64-bit eagerly acquires the amount of memory that is specified in the min server memory configuration option, regardless of the memory that it currently needs.

(Hilary Cotter) The boom in uncontrolled and uncoordinated SQL Server deployments has led to numerous challenges for the enterprise. (R)

This article explains the different technologies that are available for scaling out a SQL Server 2005 database application, focusing on the factors that go into deciding which solution(s) to use in your application.