Hi Paul,

I have similar issue yesterday occurred after upgrading to the new version sql2008r2 from 2005 version. We haven't changed the compitible mode after the upgarde.

I have followed all...

Hi Gila.,

No we cannot run the checkdb as...

Already tried those and no luck

If you want to create a index for certain search criteria then you could use filtered index(non clustered) for specific type of data.

may be helpful

here[/url]

Sorry, i haven't seen that line to ignore the current data ...and create a unique index..sorry that is not possible for the table with that data.

It seems you have duplicate data in the columns and you will not able to create the unique index on a column with duplicate rows.

You might consider delete the duplicate...

the other way to confirm the number of rows in 2 tables select Count(*) from table and is same number of rows in both tables ?

Gillian_Pappas2002 (1/7/2013)

---

=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1)

gives me "Error" on output, but there are no error codes. The syntax checks out and the values for

fields urgency_level and...

Check this post

How about doing both tasks truncate and loading in a single transaction and commit at the end ? Does this makes any difference?

SQL Guy 1 (1/4/2013)

---

Here is a problem.

We have a table which is getting truncated and loaded anew every 10 min by a scheduled job. The table is of medium...

nawillia (1/4/2013)

---

My coworker are brainstorming some ideas because our network is divided geographically.

One question we are pondering is if you can restore a database to Server B using Server...

Mithra (1/2/2013)

---

Team,

I am looking for the TSQL to get the below details.

1)Total memory allocated in the windows machine where a sqlserver instances are installed.

2)Total memory allocated to each...

fabri8989 (12/28/2012)

---

Hi guys 🙂 my name is Fabrizio and i'm from italy 🙂 i work in a IT company here in italy, and i'm network & server administrator for cisco...

nelsonj-902869 (12/27/2012)

---

Greetings all.

I am learning SSIS and having great fun with Sequence Containers, Control flows and Data flows. I believe I have the general idea, so I am attempting to...