Hope you don't mind but here is my suggestion; check all the possible bottlenecks and possible points of failure, this may not even be a db issue. It only takes...

Jeff Moden (3/31/2014)

---

While some of the methods posted are ok, there's still the fundamental problem...

... of not knowing what...

Luis Cazares (3/31/2014)

---

Here are 2 other options.

WITH Contacts AS(

SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME, CNT.CAPACITY,

ROW_NUMBER() OVER( PARTITION BY INS.INSPNO ORDER BY CASE WHEN Capacity = 'Contractor' THEN -1 ELSE INS.INSPNO END DESC)...

One way of simplifying this is to use the NCHAR() function;

EXEC ( ' Select CHARINDEX(NCHAR(41), @Ref) ')

This can be done using sub-query

Using TOP

DECLARE @BATCH_SIZE INT = 10;

DELETE X

FROM (

SELECT TOP (@BATCH_SIZE) [COLUMN]

FROM [TABLE_NAME] M

ORDER BY [COLUMN] DESC

) AS X

Using OFFSET-FETCH (2012)

DECLARE @BATCH_SIZE INT = 10;

DELETE X

FROM...

This is a case of premature exclusion, nothing to worry about 😀

USE tempdb;

GO

DECLARE @inspection TABLE

(

INSPNO INT NULL

,StartDateDATE...

Could you supply a DDL with a sample records and the expected results?

Quick note, be careful not to use reserved keywords in this manner, that is the...

Came across this, thought it might help

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5ae34e9d-f0b2-4d32-90fa-a4faa0087889/accidentally-set-sql-server-max-memory-too-low?forum=sqldatabaseengine

dwain.c (3/27/2014)

---

You also get my seal of approval. 🙂

Tally Tables in T-SQL[/url]

Reference and link at...

Several ways to do this, options include using SSIS package, an OPENROWSET from destination, downgraded SQL Server import then upgrade and few more. Without more knowledge of the schema, constraints...

Jeff Moden (3/29/2014)

---

You should write another article, Eirikur. One on the very techniques that you've exposed in this thread. I was pretty sure that problem in the original...

This might help;

USE tempdb;

GO

CREATE TABLE dbo.TBL_XML_DOC

( XML_DOC_ID int identity(1,1) primary key clustered not null

,XML_DOCUMENT xml);

GO

INSERT INTO dbo.TBL_XML_DOC(XML_DOCUMENT)

SELECT * FROM OPENROWSET(

BULK 'C:\Download\sdn.xml',

SINGLE_BLOB) AS x;

;WITH...

Prakash Heda (3/29/2014)

---

having issue sorting this data last date for every minute of data, while last date for min is coming fine, cant make last bid qty using same method,...

I have 2008R2, 2012 and 2014 on the same W7, all named instances, no problem 🙂