stuart.hemming (5/9/2013)

---

Hello,

I'm hoping someone can help me with a SQL query I'm trying to write; I'm relatively new to SQL so please bear with me if this is a numpty...

Here is an interesting solution that could be more efficient (didn't test that):

select

DT,

CAST(dt AS decimal(29,15))*86400 AS decdtsec2,

SecondsSince_19000101 =

-- seconds for whole days

(datediff(dd,0,a.DT)*000000000086400)+

-- seconds since start of day

datediff(ss,dateadd(dd,datediff(dd,0,a.DT),0),a.DT)

from

(...

I would probably make sure I have installed all .NET Framework patches and especially upgrade my tools install to SQL 2012 SP1 CU(latest).

See anything in the Windows Application Error log?

1) install a copy of SQL 2012 Books Online. It is an INCREDIBLE, FREE resource. In this case it is really perfect for you because it has a...

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note there are 2 additional parts to this blog series.

There is also several Profiler Events under the Locks category that can show detailed information about deadlocks.

This is from my Common TSQL Mistakes SQL Saturday session, which I have presented over 50 times now at various venues. Hopefully you can adapt it to your needs...

Yeah - sp_whoisactive is THE tool for monitoring current activity on a sql box. Here is a link to a 30-day blog post series he did on all the...

You do work in the second query which doesn't happen in the first. I see no reason to expect the second query to not be some (microseconds?) slower than the...

Sean Lange (5/1/2013)

---

Are you sure you even need a cursor? Given that...

There are quite a number of things that could be at fault here, especially given the clustering setup you have. I would review every error log you can get...

GilaMonster (5/1/2013)

---

Same thing. The only difference is in one you specify the PK name, in the other you get an automatically generated name. In all other aspects those two statements...

JimS-Indy (4/30/2013)

---

Kevin, the table build scripts for these four tables are probably 200 lines long, containing columns and foreign keys that are not relevant, and may be confidential. I know...

we cannot make use of a picture of a schema to build a query from. I asked you specifically to supply what would enable us to help you. ...

How...