As I mentioned before, reconstructing the XML with the changed values and do a normal update is one way of doing multiple updates on an XML in a single operation

😎

USE...

Quick question, what data type is your date...

ChrisM@Work (7/25/2016)

---

It's fine! I've seen NVARCHAR for gender...

Quick question, is there an Error 18456 entry in the logs and if so, what is the ERROR STATE?

😎

Further questions to the OP

😎

1) Do you really need the OrderID in the table? If the model has something like [Customer]---<[Order]>---[Produc] construct the OrderID is redundant as the Orders Fact...

abhishek_300 (7/24/2016)

---

Yes I am trying to fix performance issues. The fact column which has 15000000 records are all unique that's why I want to split this column as per the...

Doctor Who 2 (7/24/2016)

---

I finally got my SQL Server database uploaded into Azure SQL! I posted a blog post about it. Rather than repeat what I did I'll just give...

He he, was thinking...

At the first glance the statistics look way off, have those been updated recently? Further the index seek on [TRAFFILOG_GEO].[sys].[extended_index_2066106401_384000].[TBL_STREET_ROAD_NEW#ISRAEL_geom].(Spatial) is quite hefty, are you using FORCESEEK? A range scan...

Will have a look at this when I can, cannot see the any DDL for any indices though.

😎

Still puzzled why on earth (pun intended) you would use two dimensional geometry...

cboneill181 (7/23/2016)

---

So, I changed the name of the database I am deploying to and it's deploying fine now. Any idea why I am getting that error when trying to...

Post the actual execution plans please, images of execution plans do not help in any way

😎

Further, something is not quite right if you are using lat/long with geometry, can you...

sp_cycle_errorlog

😎

abhishek_300 (7/23/2016)

---

I want to split the tabular model column for a Fact Table to optimize the performance . The Fact Table Order ( OrderID column) has more...

Piling on

😎

Start by fixing these issues:

LN: 27 #test_Tmp_JRNL is Missing Clustered Index

LN: 71 #test_SAP_Tmp is Missing Clustered Index

LN:158 Wide distinct selection and group by for a single aggregate

LN:316 Wide distinct...