Refactoring and static code analysis tool for SQL Server
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

August 2008 - Posts

SQL Server Transaction Isolation Level - SNAPSHOT

SQL Server 2000 supports 4 transaction Isolation levels. We have examined them in the previous posts. The 4 transaction isolation levels supported by SQL Server 2000 is given below: READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE Each of...
by Jacob Sebastian on 08-30-2008 | 136 Views

SQL Server Transaction Isolation Level - SERIALIZABLE

In the previous posts we have examined READ COMMITTED , READ UNCOMMITTED and REPEATABLE READ transaction isolation levels. We will focus on SERIALIZABLE isolation level, in this post. SERIALIZABLE is very close to REPEATABLE READ isolation level, except...
by Jacob Sebastian on 08-30-2008 | 46 Views

SQL Server Transaction Isolation Level - REPEATABLE READ

In the previous posts, we examined two transaction isolation levels: READ COMMITTED and READ UNCOMMITTED . In this post we will look at REPEATABLE READ isolation level. Before we discuss REPEATABLE READ, let me show a few queries that demonstrate the...
by Jacob Sebastian on 08-30-2008 | 49 Views

SQL Server Transaction Isolation Level - READ UNCOMMITTED

In the previous post , we examined READ COMMITTED . READ COMMITTED is SQL Server's default transaction isolation level. Under READ COMMITTED isolation level, the modification that a transaction makes on the data will be visible to other transactions...
by Jacob Sebastian on 08-29-2008 | 46 Views

SQL Server Transaction Isolation Level - READ COMMITTED

Summary: The default transaction isolation level of SQL server is READ COMMITTED. This article explains the behavior of READ COMMITTED isolation level. Under READ COMMITTED isolation levels, changes to the data is not visible to other transactions until...
by Jacob Sebastian on 08-28-2008 | 42 Views

Introduction to SQL Server Transaction Isolation Levels

Summary: This post discusses the basics of SQL Server Transaction Isolation Levels. One of the basic characteristics of a transaction is the Isolation Level. This is the "I" in ACID (Atomicity, Consistency, Isolation and Durability) properties...
by Jacob Sebastian on 08-28-2008 | 62 Views

XQuery Lab 24 - Reading value of an element specified by a variable

  We have seen the usage of XQuery function "local-name()" in one of the previous posts . This function is very helpful when you don't know the element or attribute to process. The calling process can specify an element or attribute...
by Jacob Sebastian on 08-25-2008 | 658 Views

Understanding SQL Server SET Options 1 - SET ANSI_WARNINGS ON | OFF

This is the first of a series of posts I would like to make on the SET options in SQL Server. These set options are well documented in BOL, however, some of the options are explained with a very high level language that look bit difficult to understand...
by Jacob Sebastian on 08-22-2008 | 79 Views

Service Broker - Service Broker will be disabled when a backup is restored

You may be surprised to see your service broker application does not work after you restore a backup. The reason is that, when you restore a backup, the new database will be restored with service broker in disabled mode. You can run the following query...
by Jacob Sebastian on 08-21-2008 | 73 Views

FOR XML PATH - Generating an element having NULL value

When you generate an XML document using FOR XML, columns having NULL value will be eliminated. Some times you might need to have an empty element (even if there is no value) generated to make sure that the application that processes the XML document does...
by Jacob Sebastian on 08-21-2008 | 928 Views

XQuery Lab 23 - Retrieving values and position of elements

  I wrote this query a few months back to help some one in the XML forums. Here is the sample XML data for this lab. < Names > < Name > Jacob </ Name > < Name > Steve </ Name > < Name > Bob </ Name > <...
by Jacob Sebastian on 08-20-2008 | 1,033 Views

TSQL Lab 3 - How to join the results of a Table Valued Function to a table using CROSS APPLY

This example shows how to join the results of a Table Valued Function to a table usin CROSS APPLY. Let us create the database objects needed for this lab. Let us create the tables. -- Customer Table IF OBJECT_ID( 'Customers' ) IS NOT NULL DROP...
by Jacob Sebastian on 08-18-2008 | 47 Views

TSQL Lab 2 - How to change the schedule of a JOB from TSQL

The following code snipped shows an example that alters the schedule of a SQL Server Job from TSQL. We can use the system stored procedure sp_update_jobschedule to alter the schedule of a job. I have a job named "ScheduleUpdateDemo" and a schedule...
by Jacob Sebastian on 08-17-2008 | 106 Views

TSQL Lab 1 - Using an INSTEAD OF INSERT/UPDATE TRIGGER to validate data

An INSTEAD OF INSERT and INSTEAD OF UPDATE triggers can be used to validate the data being inserted or updated in a table. You could perform your validations in the trigger and the update will take place only if the validation succeeds. INSTEAD of triggers...
by Jacob Sebastian on 08-17-2008 | 159 Views

XQuery Lab 22 - How to change the position of elements - Move an item to a specific position

  In lab 20 we saw how to move an element up or down. In lab 21 we saw how to move an element to a location relative to another element having a specific value. In this lab, let us see how to move elements to specific positions. Here is the sample...
by Jacob Sebastian on 08-16-2008 | 357 Views
More Posts Next page »

Copyright © Beyondrelational.com