David Moutray (12/29/2011)Seriously, if I have the opportunity to try it on a new system, I might put it in and forget to tell the developers (aka "the enemy") about...

How about using coalesce?

create table #test(id decimal);

insert into #test values(1);

insert into #test values(2);

insert into #test values(3);

insert into #test values(4);

insert into #test values(5);

insert into #test values(6);

insert into...

Little Nick (12/29/2011)

---

I like this one, 'If in doubt - add a second column to the PK, a column that would ensure uniqueness'

But I dont understand how to add a...

m--S3qU3L (12/28/2011)

---

I have often seen database views created in the database (where the dimension and fact tables reside) to support the Analysis Services for its Analysis.

In theory, from Project Real...

...but you don't know, huh? why don't just answer what op asked for instead of going border line off topic for no good...

Why? What's wrong with backend code...

You tell me 😀

You know your system then you know what are the chances of getting duplicates depending on how...

pandeesh (12/29/2011)

---

i Have a table which contains a column called "value".

The records are as below:

Value

-------

1

2

3

4

5

6

7

i need the output as single records as:

1,2,3,4,5,6,7

The logic is delimiting all the values by comma,

In...

Two notes:

1- Partitioning Column a.k.a. table PK must have a CHECK constraint describing the low and high end of the partition range stored in such a table - that's how...

frankcastle509 (12/28/2011)

---

you are probably looking to completely redesign your system and I think you should hire an expert for all your queries because you got lot of things to deal...

Amazing! How this thread that started as a question about the design of a OLTP Travel application derived into a discussion about Data Warehousing is something that puzzles me...

itsamarnath (12/28/2011)

---

One of the customers took a database offline in one of the sql server 2005 instances and wanted to findout if we get an alert or not through the...

Please check http://support.microsoft.com/kb/955725

Check the post dated 5/16/2009 12:02;17am on this thread: http://www.sqlservercentral.com/Forums/Topic717382-266-2.aspx

Edit: Sorry - I was reseaching this when you updated the thread with the news that a backup actually exists.

angel.fernandezj (12/27/2011)

---

I found a couple of articles on the web, some of them gave me the information on a scrip and the others as a report:

Script to find server level...