Thursday, October 30, 2014

c# threading questions


  • does a blocked thread use CPU resources?

Tuesday, September 30, 2014

object_id with table created by mistake with schema name

OBJECT_ID(N'blah.[blah.boo]')


brackets around the whole name worked

Monday, September 22, 2014

Wednesday, September 17, 2014

asynchronous <> multithreaded

here

changing recovery plan

I coudnt do it with the graphical tools because the log was full

this worked

ALTER DATABASE blah set recovery simple