Brandie Tarvin (1/27/2015)

---

venoym (1/27/2015)

---

BrainDonor (1/27/2015)

---

Sean Lange (1/23/2015)

---

Oh the cursors are unbelievably stuipd. They are used to count!!!

set @Counter = 1

while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin

...

I believe that causes it to recompile on each execution. Just like putting the option a query does.

Not sure but maybe something like this?

WITH ParsedXML AS

(

select y.[desc].value('@letter','varchar (230)') as letter

,x.[desc].value('@desc[1]','varchar (230)') as [desc]

,y.[desc].value('@path','varchar (230)') as [path]

,y.[desc].value('@label','varchar (230)') as Label

,x.[desc].value('@changed','varchar (230)') as [Last Changed]

,z.[desc].value('@bool','varchar(10)') as condition

,z.[desc].value('@name','varchar(1000)') as Username

from...

Do you mean this?

WITH ProcessTable (PK, processid, status) AS

(

SELECT 1, 1, 1

UNION ALL SELECT 2, 1, 2

UNION ALL SELECT 3, 2, 1

UNION ALL SELECT 4, 3, 1

),

...

TheSQLGuru (1/26/2015)

---

That's quite interesting Dwain! I will have to set aside some time to break it down, and also modify it to work with the typical "UserID did something"...

The INSTEAD OF TRIGGER is probably what you want.

You can write a DATABASE TRIGGER to remind you when you ALTER the table and add a new column.

This article has an...

After more than a little frustration with the development team that seemed unable to resolve this, I started Googling and I came up with a suggestion that might offer a...

ScottPletcher (1/26/2015)

---

It's much better to code it as:

(a.processStatus is null...

Brandie Tarvin (1/26/2015)

---

EDIT: Is Crystal running on the same exact server as SQL Server? If not, what else is on the server that Crystal runs? And if so, what else...

CREATE TABLE #Table

(

ID INT IDENTITY

,x INT

);

SET IDENTITY_INSERT #Table ON;

INSERT INTO #Table (ID, x)

SELECT 0, 0 UNION ALL SELECT 0,...

KGJ-Dev (1/25/2015)

---

Finally Quick update,

My assumption helped me little.

I ran dwain's sugestion on my production box and it ran in 10 sec.

Tried my logic as well and it took 11 sec.

The...

Calendar Tables or Calendar Functions, name your poison!

http://dwaincsql.com/2014/03/30/calendar-tables-in-t-sql/

IBG does have some great articles on intervals for sure, but I don't think anything particularly fancy is needed here.

WITH SampleData (OpDate, sessionStartTime, sessionCloseTime) AS

(

SELECT CAST('2015-01-20' AS DATE), CAST('2015-01-20 14:32:59.130'...

According to the Execution Plan, the following INDEX would help the second query in my batch.

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]

ON [dbo].[User_bank] ([UserId])

INCLUDE ([IDUserBank],[Amount_Pend],[Amount_Available])

Edit: But in fact with...

I think this does basically the same thing but runs in about 6 seconds on my SQL 2012 box.

Declare @CompID int = 1050

,@ProcessingDate DATETIME = GETDATE();

BEGIN

--...