(Serdar Yegulalp) The DBCC PSS command enables you to obtain and dump out detailed information about processes and users currently connected to a SQL Server. It has remained an undocumented feature because the type of information dumped out by PSS has changed from one SQL Server edition to the next,

(george.p.alexander) So application programming in .Net is one thing. But tweaking the Database part of our application is a totally different matter. Earlier we had a look at enhancing database performance by getting the right index. This was followed by a look into using indexes along with SQL Sta

(Sonu Chauhan) Part I will brief you on How to Design Reports in VS.NET. And Part II will describe how to upload your reports on the Server and what code to write in the Application to invoke those reports.

(Baya Pavliashvili) SQL Server comes with several excellent tools for monitoring and tuning application performance. Profiler is perhaps the most powerful of these tools; it allows you to spy on and analyze the impact of SQL statements sent to your server.

(Arthur Fuller) A common SQL Server application requirement is to support searches based on one or more long strings. (In this article, we refer to anything with more than 20 characters as a long string.) Suppose that your front-end application wants to allow the user to supply two long strings; you

(William Pearson) In this article, we will continue the examination of "MDX for drilling up and down" that we began in Set Functions: The DrillDownMember() Function. We have discussed the nature of drilling, in general, in previous articles of our sub-series, stating that it comprises an analytical

(Baya Pavliashvili) When application users start experiencing performance problems, they typically call the database administrator and ask if there is a problem with the database. Interestingly, most people will look at memory, CPU and disk utilization, but not at the particular code modules that ca

(Don Schlichting) This article will explore the hows and whys of executing SQL Stored Procedures from inside a web application.

When you try to manually update table statistics in Microsoft SQL Server 2000, the following message may be logged in the SQL Server error log: DateTime server Error: 17883, Severity: 1, State: 0 DateTime server Process 905:0 (19c4) UMS Context 0x0000000053E318F0 appears to be non-yielding on

(Brian Walker) This article offers some additional commentary about the use of SQL Server IDENTITY values as surrogate keys. I will describe several utility routines to help maintain a surrogate key database. I will also provide six stored procedures to implement the utility functionality. (R)