GilaMonster (8/29/2012)

---

In most cases,...

Looks like a problem with a nonclustered index, id = 22. Try dropping and recreating this index.

This:

declare @TimeStr time = '16:40:27',

@SecondsAtStatus int = 734;

select @TimeStr, dateadd(ss, @SecondsAtStatus, @TimeStr);

celayne (8/29/2012)

---

I have a field that contains a time (i.e. 16:40:27) and I have a field of "SecondsAtStatus" (i.e. 734).

I need to add the "SecoundsAtStatus" to the Time field to...

Make it easier for others:

http://news.yahoo.com/blogs/lookout/school-asks-deaf-preschooler-change-sign-language-name-191629255.html

At this point, there really isn't enough information to make any educated quesses, just shots in the dark. Have you looked at other aspects regarding server performance; disks, network,...

That is a backward compatibility view, and it is now in...

djackson 22568 (8/29/2012)

---

Lynn Pettis (8/29/2012)

---

I find as I get older I tire more quickly of the constant cursing of others. Don't get me wrong, I can curse with the...

One suggestion I have is to set up a server side trace and see what is running when this occurs.

Looks like Greg beat me this time.

Here is my solution.

CREATE TABLE #Test

(

NAME VARCHAR(10),

DT_START DATETIME,

DT_END DATETIME,

LOCATION VARCHAR(10)

);

INSERT #Test

SELECT 'Jack','1997-12-18','1998-12-08','BANGALORE'

UNION ALL SELECT 'Jack','1998-12-09','1999-10-13','BANGALORE'

UNION ALL SELECT 'Jack','1999-10-14','2000-07-26','BANGALORE'

UNION ALL SELECT 'Jack','2000-07-27','2001-03-26','BANGALORE'

UNION ALL SELECT 'Jack','2001-03-27','2002-07-01','CHENNAI'

UNION ALL SELECT 'Jack','2002-07-02','2003-01-29','CHENNAI'

UNION ALL SELECT 'Jack','2003-01-30','2003-04-30','MUMBAI'

UNION...

Sean Lange (8/29/2012)

---

Luis Cazares (8/29/2012)

---

I tested my last solution and won't give the exact results.

Try this instead:

;with MyRank (col1)

as

(

select 6 union all

select 5 union all

select 4 union all

select 3 union...

I find as I get older I tire more quickly of the constant cursing of others. Don't get me wrong, I can curse with the best of them just...

Does this have anything to do with your restore database thread?

Could there be something going on between these?

8/19/2012 9:51 spid17s CHECKDB for database 'NSMRulestat' finished without errors on 2009-09-20 18:00:09.840 (local time). This is an informational message only; no user action is required.

8/19/2012 9:51 spid11s CHECKDB for...