sgrimard (4/29/2015)

---

Good day,

Everytime I run my maintenance (daily at night), my SPROCs start to time out. If I run my SPROCs directly in Management Studio, they run fine since it...

Scott-144766 (4/29/2015)

---

SQL Server 2012 SP2 Enterprise Edition (11.0.5058.0) on Windows Server 2008 R2

At some point a few months ago we encountered an issue where we hit some size limit on...

mandirkumar 18293 (4/29/2015)

---

Hi,

For a sp which is causing dead lock,I replaced cursors ,so now it is causing time out some times only.

Fortunately this is happening in production only , not...

This pretty obviously homework. Did this structure come from your professor or did you design it? What is the actual assignment?

mm7861 (4/29/2015)

---

Hi all,

Our fiscal year starts on 2015-04-06, and I need to assign a week number that starts from this date. Any idea how I can achieve this?

This piece of...

sqlquery29 (4/29/2015)

---

Hi ...I got sample DDL's

CREATE TABLE Equipment(

[Equipment_ID] [bigint] NOT NULL,

[Version] [int] NOT NULL,

[Code] [nvarchar](50) NOT NULL,

[Description] [nvarchar](100) NOT NULL,

[IsActive] [bit] NOT NULL,

[TreeLevel] [smallint] NOT NULL,

[Parent_Id] [int] NULL,

CONSTRAINT [pk_Equipment] PRIMARY...

andrew gothard (4/29/2015)

---

Sean Lange (4/28/2015)

---

Lynn Pettis (4/28/2015)

---

The OP just PMed me with all the info that had been posted on the forum...

Lynn Pettis (4/28/2015)

---

The OP just PMed me with all the info that had been posted on the forum thread. Apparently he...

Phew!!! I got yours correct...

Table definitions and indexes would go a long way to helping you here. Can you post them?

Ed Wagner (4/28/2015)

---

With 87% getting it right at this point, that's encouraging. I guess I just took knowing that for granted and never gave it a second thought. ...

neeraj-344433 (4/27/2015)

---

@Sean Lange.

I certainly have no intention to ignore anybody who is trying to help me. If thats the message being conveyed, my apologies.

So lets start from beginning ...

neeraj-344433 (4/27/2015)

---

Will it help if I clustered index on the table by adding a identity column to it. As of now, its a heap because there is no index and...

Not sure what that means. It is acceptable that the query takes 32 minutes to load....

peterausger (4/27/2015)

---

------ create table

create table test222(sid bigint, scode nvarchar(50), parentid bigint, sname nvarchar(50))

insert into test222 values (1, '2323', 0, 'iam a boy')

insert...