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...

Quick suggestion, slightly different but easy to scale on large number of columns

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

declare @sampledata Table

(

ID int

, [Date] Date

...

Quick thought, although not too efficient Jacob's xmlTable function could be what you are looking for.

😎

Or the other way around

😎

SELECT

T1.ID

,T2.XDATE

FROM dbo.TABLE1 T1

RIGHT...

I have only used this method on production 2008 and 2012, used it on testing 2014 it worked fine including the machine I'm writing this answer on.

😎

Simply enable Ole Automation Procedures

😎

--SHOW ADVANCED OPTIONS

EXEC sp_configure 'show advanced options',1;

RECONFIGURE WITH OVERRIDE;

-- ENABLE OLE AUTOMATION PROCS

EXEC sp_configure 'Ole Automation Procedures',1;

RECONFIGURE WITH OVERRIDE;

-- HIDE ADVANCED OPTIONS

EXEC sp_configure 'show advanced options',0;

RECONFIGURE...

Eirikur Eiriksson (7/21/2016)

---

Quick question, if the date is earlier than the 1st of April then should it return the year - 2 or -3?, i.e.

a) 2016-01-01 ==> 2014-04-01...

Quick questions, do you have recent good backups? What did you try before using REPAIR_ALLOW_DATA_LOSS?

😎

This shouldn't be too hard, even calling the web service from SQL Server is straight forward, here is an example function from this thread

😎

CREATE function [dbo].[GetHttp]

(

@url...

Done this or similar to this since 4.2, haven't forgotten it yet;-)

😎

Quick suggestion

😎

/* -- ENABLE XP_CMDSHELL

EXEC SP_CONFIGURE 'show advanced options', 1

RECONFIGURE WITH OVERRIDE;

EXEC SP_CONFIGURE 'xp_cmdshell',1;

RECONFIGURE WITH OVERRIDE;

*/

DECLARE @services TABLE

(

SRV_TXT NVARCHAR(150) ...

Only one modification can be made at a time with the XML modify method, the workaround is to reconstruct the XML and replace the previous value, here is a quick...