Additional Articles

All authors

External Article

Using TRY/CATCH to Resolve a Deadlock in SQL Server 2005

A deadlock is an inevitable situation in the RDBMS architecture and very common in high-volume OLTP environments. A deadlock situation is when at least two transactions are waiting for each other to complete. The Common Language Runtime (CLR) of .NET lets SQL Server 2005 provide developers with the latest way to deal with error handling. In case of a deadlock, the TRY/CATCH method is powerful enough to handle the exceptions encountered in your code irrespective of how deeply nested the application is in a stored procedure.

2005-11-25

3,655 reads

External Article

Views in SQL Server

A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query stored as an object. Hence, a view is an object that derives its data from one or more tables. These tables are referred to as base or underlying tables.

2005-11-24

4,248 reads

Technical Article

Checksum Transformation

The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services, for use within the pipeline without code or a SQL Server connection.

2005-11-23

1,697 reads

Technical Article

Building Reports Based On Stored Procedures

Usually developers like having full control over their reports but what happens if you have someone designated to build reports who does not quite know the backend schema. A good way to separate the building of the data for the report and the report design could be stored procedures. Now I consume stored procedures using Oracle which is not much different consuming stored procedures with SQL Server, however building the procedures is much different between the two. Even though I mention and show examples of stored procedures this is not an article for building them, just a guide for consuming a stored procedure within a Reporting Services Report.

2005-11-22

3,591 reads

Technical Article

SQL Server 2005 Learning Guide

It's been five years since Microsoft released a new DBMS, but both experts and users agree that this one was worth the wait. SQL Server 2005's enhancements and new features have made the system a much more attractive attractive option to both large and small shops. Nonetheless, upgrading to SQL Server 2005 is a serious undertaking, requiring extensive training, planning and testing. In this Learning Guide, you will find news, technical tips and expert advice to help address your questions and concerns regarding SQL Server 2005 and put you on the road to a successful upgrade.

2005-11-16

5,506 reads

External Article

Dynamic Management Views

The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. This article provides an introduction to DMVs and covers a few of the basic views and functions.

2005-11-15

2,315 reads

All authors

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

By

Reading tutorials is fine. Shipping something is better. If you are trying to break...

The Book of Redgate: Taking Breaks

By

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Database AI Agents: The Read-Only Rule

By

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Read the latest Blogs

Forums

Liability for AI Errors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Liability for AI Errors

Bank BCA KCU Singaraja Telp/Wa:0817 839 777

By R4nt4u

Bantuan CS : (0817) 839777 Jalan Dokter Sutomo No.3, Banjar Bali, Kec. Buleleng, Kabupaten...

Bank BCA KCU Kuta Telp/Wa:0817 839 777

By layanan_Bca88

Bantuan CS : (0817) 839777 Jl. Sunset Road No.88B, Kuta, Kec. Kuta, Kabupaten Badung,...

Visit the forum

Question of the Day

Running SQLCMD II

I run this command to start SQLCMD: 

sqlcmd -S localhost -E -c "proceed"
At the prompt, I type this (the 1> and 2> are prompts): 
1> select @@version
2> go
What happens?

See possible answers