Updating from a column value is equally simple, here is a quick sample, results are equal to the previous method.

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_XML_MODIFICATION') IS NOT NULL DROP TABLE dbo.TBL_XML_MODIFICATION;

CREATE...

One of the certainties of live: "There will always be wannabes"

😎

Quick example, should be enough to get you passed this hurdle

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_XML_MODIFICATION') IS NOT NULL DROP TABLE dbo.TBL_XML_MODIFICATION;

CREATE TABLE dbo.TBL_XML_MODIFICATION

(

XM_ID INT...

ocean3300 (7/20/2016)

---

This table has about 5M records and it takes about 300 milliseconds to execute below query. Just wondering if there are other ways do this for better performance?

SELECT MIN(Date),...

Turning the Azure SQL Databases on and off is not an option but you can throttle it down to a basic tier when not using it. The on/off option applies...

I have seen many of such solutions fail, OP, do you want to answer the questions I have asked or even better improve the scheme as suggested?

😎

Quick thought, foreign key constraint to the table from a pseudo table on a column with a default value constraint will do the trick.

😎

Edit: Typo

Quick suggestion, based on your questions I suggest you research those topics on BOL and come back if you have any further questions.

😎

There are quite few options here and each has it's pros and cons but to recommend any of those I would like to have more information as what may be...

Quick suggestion, add max on the values and group by the ID.

😎

Out of curiosity, why do you want to do...

Quick question, do you have any sample data to...

farooq_inlondon (7/18/2016)

---

Hi All,

I had database with ndf files in 5 filegroups, the big tables is partitioned and data is there in these files.

I dropped the database but mdf, ndf and...

Quick question, any MSDTC transactions?

😎

Further on John's reply, we need the table structures, the query and the actual execution plan, without the information it's only wild guesses.

😎