Hi Matthew,

I'm guessing that the proc pace_master.dbo.GetUpLdNextInstance only works on one row at a time?

Unless that can be changed you're stuck with the cursor, or a while loop, which won't...

Cool 🙂

It can sometimes take 2 log backups before the space will free up. Not usually a situation I'd associate with simple recovery mode though.

Looks like the space is free internally...

Can you copy the files to the remote server & then restore? Or restore successfully on Server A?

Sounds like a network problem rather than a SQL issue - can you...

What's the value for your database from:

select name, log_reuse_wait_desc from sys.databases ?

Nice question Hugo, thanks.

Got 3 of the 4 - knew bitmap indexes were available on other DB software, thought it might have been introduced with 2012.

Thought 260 columns for columnstore...

It's an active MS Connect issue (from SQL 2005 no less!), so I guess it's not an option...

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=127152

Prime suspect for me would be the order by clause - as it acts after the main execution, on the result set which I guess has to be stored somewhere...

BaldingLoopMan (8/24/2012)

---

Theoretically if a plan is cached badly for whatever reason one day, is it safe to assume that the size of cached plan in bytes will grow relative to...

BaldingLoopMan (8/24/2012)

---

But how come i get some records who are obviously running a stored procedure as u can tell by the Full_statement column yet they're not getting returned from...

No problem. Hadn't realised there was a sql_handle field in sysprocesses as well. Probably comes from the same place under the covers in any case!

I use something like this, any good to you?

Cheers

USE master

GO

SELECT sp.kpid as thread,

r.session_id, s.login_name, s.nt_user_name, s.host_name, r.open_transaction_count,

r.start_time, r.status, r.command, DB_NAME(r.database_id) AS [Database], r.blocking_session_id, r.wait_type, r.wait_time,

r.total_elapsed_time, r.cpu_time, r.reads, r.logical_reads,...

Don't they all run within the context of that one spid? (Assuming you mean SQL paralellism rather than from an application that is multi-threaded).

Assuming you're using the DATE datatype, any of these:

WHERE YEAR(DateField) IN (2011, 2012)

WHERE YEAR(DateField) BETWEEN 2011 AND 2012

WHERE DateField BETWEEN '20110101' AND '20121231'

If there's an index on the DateField, the...

Bear in mind First & Last are based on the sort order of the data rather than the values.

Don't know Min/Max aren't working - what are you getting?

Thanks