Can you show us what you already have?

Is this the link you were looking for, Steve? http://www.sqlservercentral.com/Forums/Group411.aspx

Depending on the FK constraint, doing them in reverse order may work also.

Eric Weinstein (4/21/2008)

---

In MS Access, I have a table defined with some fields as numbers defined as type double. When I open up this table, I noticed the data...

ishaan99 (4/21/2008)

---

I have a column with data as

00070111

0001111

00000111

00040111

00044111

000001111

I want a query which would get me all data preceding with 0's and ending as 1111. does anyone have a script...

ksullivan (4/21/2008)

---

Try this:

create table #xx (z1 varchar(10))

insert into #xx

select '00070111' union all

select '0001111' union all

select '00000111' union all

select '00040111' union all

select '00044111' union all

select '000001111'

select * from #xx

where convert(int,...

Ron:

I am not convinced that that MS issue has anything to do with your problem since it was talking about assembly mismatches during serialization tasks.

I have sucessfully used SMO on...

It should be released just like any other terminated process. Do you have reason to believe otherwise?

peter Vramby (4/22/2008)

---

Sorry that I forgot to add the Hard page faults counter in the initial message. (I forgot to paste it over from the 2nd trace file)

Memory\Page Faults/sec

average ...

GSquared (4/18/2008)

---

They're all "number of transactions". If you look up the measures, it'll tell you precisely what it measures, and you can compare that to what you're trying to...

These forums work better if you ask a question.

Also, you do not actually have Hard Page Faults listed anywhere in these statistics ("Page Reads/sec"). Pages/sec does not directly correspond with "Page Reads/sec" and a value of 40+...

Something is wrong with these numbers. In particular:

You shouldn't be getting Idle% greater than 100%. What is your...

I have tried 2008 and I cannot find the Service Broker GUI. Can you point me to it?

Do you have any procs, functions, etc. that you use to make...

I think that you would have you redefine the data after you pulled it out of the table/column by running it through a view or other virtual column that partitoned...