rowversion

SQLServerCentral Article

An in-depth look at change detection in SQL Server - Part 02

  • Article

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

4.92 (12)

You rated this post out of 5. Change rating

2013-02-19

7,841 reads

SQLServerCentral Article

An in-depth look at change detection in SQL Server - Part 01

  • Article

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

4.58 (12)

You rated this post out of 5. Change rating

2013-02-12

4,791 reads

Technical Article

Suggestions on processing result set in T-SQL

  • Topic

Attempting to get column name from varchar staging table and data type from target table.Query works, but need ideas on processing rows returned to select IsDate, IsNumeric .. based on data type.select is1.column_name, is2.data_type from   information_schema.columns is1,        information_schema.columns is2 where  is1.table_name = 'StagingIn and    is2.table_name = 'Target' and    is1.column_name = is2.column_name and    is2.data_type <> […]

You rated this post out of 5. Change rating

2004-01-18

1 reads

Technical Article

RE: Converting Cubes

  • Reply

I guess I need to clarify my statement about using the cubes in both Oracle and SQLServer. What I have been told by my boss is that we want to be able to use 1 tool to create our cubes, such as the Analysis Manager, and then be able to distribute those cubes in our […]

You rated this post out of 5. Change rating

2003-07-31

Blogs

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers