Have all statistics been updated? DBCC UPDATEUSAGE run?

Profiler or a trace for the audit logout event.

Or build a custom script which checks sys.dm_exec_sessions for a spid and username and run it every so oftern, when it appears...

Thats the QotD from Wednesday.

Have you answered the question yet? If so it tells you why you get no results.

What is the result of

DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS

Could you post the execution plan for the procedure?

Have you checked index fragmentation and statistics to ensure they are defragmented and updated.

If stuck please follow this link http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

The problem is with the offset, you would first need to convert the string to a offset then to a datetime

Like this

SELECT convert(datetime,convert(datetimeoffset, '2012-08-01T15:05:13.000-04:00'))

This will then add on the 4...

If your not installing SSRS anywhere then you dont need licenses, if your using the reportviewer controlls within VS and providing a rdlc file and not using the portal or...

No, if you want to use SSRS you need to have the correct SQL license, there is no way around it.

Your looking at around a minimum license cost of $7200...

Looking through the licensing datasheet, it doesn't mention hyperthreading.

Instead the area about how to license says

How to license

1. License all of the physical cores on the hardware

2. A minimum of...

All the numbers you have given SQL are whole numbers, so SQL will only return a whole number.

If you want the decimal point, you will need to change a value...

When you do a restore, it logs the backupset that was used in the restore into the backupset tables.

What you are seeing are the backupsets from the primary server Database1...

So this is going to be a new server for the engine and SSRS? If so make sure you take a backup of the reporting services encryption keys before...

Thanks Lynn for Chris's modified function.

Both that function and the one in the DB backup I provided both execute in the same amount of time.

There is a mistake in the view, I posted the correct line in an earlier post.

This...

Chris,

Just a simple execute the two views, the original came back in 12 seconds, yours was over 2 minutes.

Lynn,

No you where right on the mappings

Now to throw...