What data type is the ScheduledDateTime column in your database?

John

smitty-1088185 (3/7/2016)

---

Could you provide an example? When I run the following command no text shows for the SQL_TEXT

SELECT

spid

,sp.STATUS

...

Interesting. I had assumed that NULL is always listed first in an ORDER BY. Indeed it is, if you order ascending. But if you add DESC to...

franky.Piferoen (3/10/2016)

---

Hi,

I forgot in the previous reply to mention the error from the errorlog

Login failed for user 'SomeUser'. Reason: Could not find a login matching the name provided

Thx for the...

Use proper date arithmetic instead of messing around with character conversions:

SET @Start =CASE WHEN DATEPART(mi,@Date) IN (0,15,30,45)

THEN DATEADD(mi,DATEDIFF(mi,0,DATEADD(mi,-15,@Date)),0) -- subtracts 15 minutes and strips off s and ms

END

SELECT @Start

John

Brandie

I'm guessing you've set up mirroring on the server?

SELECT

l.name AS LoginName

,e.name AS EndpointName

FROM sys.server_permissions p

JOIN sys.server_principals l ON p.grantor_principal_id = l.principal_id

JOIN sys.endpoints e ON p.major_id = e.endpoint_id

WHERE p.class_desc = 'ENDPOINT'

John

The fact that the seed value wasn't stated led me to the answer. If "1" had been one of the options, it would have been more difficult, since that's...

Frank Cazabon (3/10/2016)

---

Be careful - you don't (necessarily) want to turn off parallelism on the whole server....

The error message returned to a user whose login has failed is, by design, not very detailed. You can find out more about the reason for the login failure...

Yes, and you might also try the LEAD and LAG functions if you have access to SQL Server 2012 or higher.

John

Six seconds doesn't sound unreasonable for that lot on a table that size. What maintenance do you do on your indexes? Have you tried running the queries without...

Surely a "recovery expert" wouldn't have the backups on the same drive as the database files - or have I...

Gabriel P (3/8/2016)

---

If you know referential integrity is being enforced, why query the Departments table at all if you're not returning any data from it? If you are not returning...

SELECT

ID

, Info

, Detail

, ...

sys.dm_exec_requests has a column called blocking_session_id. Do a self join on session_id = blocking_session_id and a second CROSS APPLY to get the text itself.

John