When setting up a linked server to Oracle, I normally install the Oracle client, which can be obtained from the Oracle web site, on the SQL Server Box. (Make sure...

Try something like:

SELECT DISTINCT

local_net_address

,local_tcp_port

FROM sys.dm_exec_connections

WHERE local_net_address IS NOT NULL;

As you seem to be using SQL2012, why not use a SEQUENCE instead of an IDENTITY?

If your formulas are really that secret, the only way I can think of protecting them is to keep them on your own secure servers. Your customers could then do...

I suspect all the joins in the sub-query will not do the query plan much good.

It will probably be best to create a temp table with all the IDs to...

You may find the Word document referenced here to be useful:

https://msdn.microsoft.com/en-us/library/dn673537.aspx

Please note, I have played with this a bit but not used it in anger as we do not have...

IF (@date IS NULL)

SET @day = (SELECT MAX(day1) FROM table1 WHERE date1 = (SELECT MAX(date1) FROM table1));

ELSE

SET @day = (SELECT MAX(day1) FROM table1 WHERE date1 = @date);

Just query the backup tables in MSDB.

eg Something like the following will get the logs since the last full backup.

SELECT 'RESTORE LOG YourDBRestore FROM DISK =''' + M.physical_device_name + '''...

Try something like:

WITH RNs

AS

(

SELECT *

,-ROW_NUMBER() OVER (ORDER BY <WhatEverYouWant>) AS rn

FROM YourTable

WHERE YourPK IS NULL

)

UPDATE RNs

SET YourPK = rn;

As backups are not always done from the SQL Agent, your can also check for backups by looking at MSDB.

Try playing with the following script for FULL and LOG backups.

Ideally...

Our upgrade policy tends to be driven by Micorsoft's support cycle rather than new features.

(ie It is relatively easy to get money for an upgrade if we say the old...

Using Orlando's test data, maybe:

WITH Groups

AS

(

SELECT ID, Measure

,ROW_NUMBER() OVER (ORDER BY ID)

- ROW_NUMBER() OVER (PARTITION BY Measure ORDER BY ID) AS Grp

FROM dbo.SomeMeasurement

)

,GroupOrders

AS

(

SELECT *

,ROW_NUMBER() OVER (PARTITION BY Measure, Grp...

I think LEAD has been in Oracle for sometime.

Something like:

SELECT *

,LEAD(SMN_DATEC, 1) OVER (PARTITION BY DET_NUMBERA ORDER BY SMN_DATEC) - 1 AS EndDate

FROM CHRISCS_EMSAL

ORDER BY DET_NUMBERA, SMN_DATEC;

I suspect 18GBytes for the maximum memory would be a better place to start although heuristics for this tend to vary quite a bit.

I have only ever used trial and...

This looks remarkably similar to:

https://www.simple-talk.com/sql/performance/set-based-speed-phreakery-the-fifo-stock-inventory-sql-problem/