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 🙂

Jeff Moden (3/29/2014)

---

I notice that you did (what I think is) a nifty trick in the HRI(CT) CROSS APPLY that greatly simplified what I thought one might have to do...

elfresco1 (3/26/2014)

---

I am having problem trying to parse an XML field in a table because it is too complex for me. I need to get the data from the <HighRiskIndicators>,...

Here is a method that I have used for one off...

GilaMonster (3/28/2014)

---

INT has a higher precedence than string, the string will convert to int, so if that is an int column (which we don't know), then the query will be...

GilaMonster (3/28/2014)

---

All the predicates in that query are SARGable. They're...

Apart from not being SARGable, this query puzzles me, would you ever have a SalesID value...

Ranzz (5/26/2011)

---

Below is the script for creating index and how can I change the script to create index onlie?

what are benfits and disadvangates of online and offile?

CREATE NONCLUSTERED INDEX [_dta_index_dClientCode_16_437576597__K7_K3_1]...

tlunsf (3/28/2014)

---

It is comments like this that...