sunnyepgc (8/31/2015)

---

Hi, Could any one help me to resolve the issue. We have around 5 SP’s which are inserting data into Table A,and these will run in parallel.From the temp...

balasach82 (8/30/2015)

---

Its a new Win 2008 R2 box with 128 GB ram. SQL is allocated about 4 GB (min) max (61 GB). Thsi configuratin is much higher than what we...

balasach82 (8/30/2015)

---

An Stored proc which was running in SQL 2008 for 6hrs, after upgrade to 2012 takes 12 to 13hrs to complete.

Inside the proc, an cursor is created and 300K...

alessandro.feltrin (8/29/2015)

---

[font="Arial"]

Hello. I need to implement a Lab environment and in order to do this i have installed a new Virtual Machine with the same configuration and Software releases.

I've performed...

Spent several days once debugging a system and the bug turned out tobe caused by nolock hints.

😎

Thank you for this interesting question Hugo.

😎

Slightly taken aback seeing the overall results though

Correct answers:6%

Incorrect answers:94%

The site is once again very slow, up to 90sec between clicks :sick: and images particularly slow!

😎

Quick test

Quick thought, the description of the logic does not fit the expected results, can you please amend either or both?

😎

Quick question, can you post the code for the procedure Abc.DBO.aspRoleFCUD?

😎

Quick questions, what are the memory specs (hardw.,vm,provisioning)? What are the sql server's mem configs?

😎

For completeness, the order by does not work with the over clause prior to 2012

😎

WITH SampleData (PERSON,TRANSACTDATE, STARTDATE, END_DATE, IN_PUNCH,OUT_PUNCH,HOURS) AS

(

SELECT 1234,'08/03/2015','08/03/2015','08/03/2015', '06:00','09:00','3' ...

Limoncello

Quick question, is this a named instance?

😎

Further on Phil's fine answer, recommend adding a POC (Partition, Order, Covering) index on the table, makes a huge difference if the set is large, here is a quick example.

:cool:...

To get the desired result set, we only need to do minor changes to the query, note that there is one "FOR XM" for each nesting level in the output.

😎

SELECT

...