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/

I would look at the basics first.

1. Is there anything else other than your SQL2008R2 instance on the server?

2. Is the server a VM?

3. Does the maximum memory in your...

A test harness with DDL etc would be useful.

As this is a database why not create:

CREATE TABLE Entities

(

[Group] char(3) NOT NULL

,[Type] char(3) NOT NULL

CONSTRAINT PK_Entities PRIMARY KEY ([Group], [Type])

);

INSERT INTO...

I would start by learning RMAN as backup and restore is fundamental to the job of a DBA.

SQLDeveloper, being java based, is relatively easy to install on a Windows machine....

I have just found this link.

http://www.nomad.ee/btrieve/files/

You may be able to use some of the utilities to export from the Btrieve files without the need for Pervasive SQL.

(I presume you will...

luhar.mitul (11/5/2015)

---

Hello all experts,

Greetings !

I need your help. I work on data-migration projects and I am responsible from getting data from legacy systems to SQL Server Database.

Presently, I am...

Other things to look at are to:

1. increase the frequency of the log backups to at least every 15 minutes and automate moving the log backups to another server. This...

Looking at this again, you could also try changing:

CONVERT(DATETIME,'2015-06-05T09:29:43',126)

to

'20150605 09:29:43'

I suspect the problem is to do with the datetime column RequestDate. About 3 years ago we had some problems moving a 1990's third party program, designed to work with...

It looks as though you have precedence:

CASE

WHEN Opportunity IS NOT NULL THEN Opportunity

WHEN Campaign IS NOT NULL THEN Campaign

ELSE Account

END

Edit: Did not notice Phil's reply. His is probably better.

Manic Star (9/17/2015)

---

The other day developer asked me to create a new table that had a FK constraint to an existing largish table on the largish table's primary key.

When...

This seems to produce the required results:

WITH NameGroups

AS

(

SELECT Name, Year, Sales

,(ROW_NUMBER() OVER (PARTITION BY Name ORDER BY year) - 1)/4 + 1 AS Grp

FROM #test

)

SELECT Name, Year, Sales

,DENSE_RANK() OVER (ORDER...

You may also want to look at tranactional replication.