Welcome RW.

Why not just do this?

INSERT INTO dbo.Units (PhaseID, BuildingID, UnitName, FileNumber, SubAddress, Eligible, EligibleReason, Priority, TownPriority, BidAmount, ConstructionCost, Comments, AccessCode)

VALUES (@phase_id,@bldg_id,'','',@index,'','','','','','','','');

AndrewSQLDBA (12/8/2011)

---

Sure will

I have been working on it, and going thru the small list by hand to see exactly what rows are not in the correct place. I am coming...

Can you run the code I offered and tell me exactly which row(s) are not positioning correctly?

Apologies, but I just don't have time to dig through that at the moment,...

Brandie Tarvin (12/8/2011)

---

Why? Well, it's my opinion that women tend to take a long term view of where their careers will be, in addition to the money and benefits, while...

oweston (12/7/2011)

---

Have a general question what setting/s would a dba hold true to implement on all servers touched? i.e Auto Grow always on. I know this is a very...

mtassin (12/7/2011)

---

Of 11million records... about 50,000 are failing with truncation. Near as I can tell there's no way I'm exceeding the bounds of a DT_I4 data type with this...

If this database is small and merely complex, I have a recommendation...

Script out all the schema, drop it to a new DB shell, and port your data over. Grab...

matthew.peters (12/7/2011)

---

Here is the query and I have attached the plan. I assumed a like operator required a index scan? Anyway any help would be appreciated, I have created a...

Yes, but not with a...

I would not under most...

Andrew,

I took a look through this and your data and what you've described as the business rules and it doesn't make sense offhand. Hopefully you can clarify.

Honestly, your initial...

LutzM (12/7/2011)

---

I hear both of ya!! :crying:

I'll keep trying to talk those folks into more spindles and much larger local drives (the fact they still didn't answer my memory dump...

matthew.peters (12/7/2011)

---

Hey Guys

I have an issue where an application is running a few different select queries with 'like' operators on a large table in the datebase. These queries in turn...

Sapen (12/7/2011)

---

Hi all,

I thought to run the victims (EF Generated SQL SELECT queries) through the DETA and see if it recommends any indexes. As expected DETA suggested that there will...

hxkresl (12/7/2011)

---

I'm successfully moving all columns from staging to destination table, with one caveat. The column with datatype (decimal 15,2) is getting truncated. Instead of preserving the values after...