changing the owner for object or jobs are just  object level schema lock; no instance wide affects. if someone is connecting or updating , you might have to wait for...

i was thinking of recovering table space, typically tied up in indexes or in heaps.
 and not reserved space for the whole database.

AS Jeff mentioned,you have to shrink...

if you run the query below in a given database, it will check the index statistics and tell you the last time a table was read/updated since the last time...

minor annoyance: the email link for old vs new forum posts: new posts have a direct link to unsubscripbe.
old posts have the generic link to all the items you've...

Over the weekend, I saw a huge flood of the same kind of spam we were getting in the old forum software; mostly links to current events like football games...

each database has a system view named sys.database_role_members, which is just ID's associated ot roles; you have to join that against database_principals to get what you are after.
you'll need...

After a large delete, you'll need to rebuild the indexes on the table.
the deleted items still take up the pages they used to occupy, and reindexing rearranges and deletes...

I managed to break the javascript in a post, so I cannot edit the post, nor use the mini "Explore "menu in the upper right that typically has a link...

i have this saved from something i built off of an msdn, does this help?

left join ReportSchedule rs on Sch.ScheduleID = rs.ScheduleID
  left join...

I tried slapping a full example together, but i find it pretty annoying that Format-Table is leaving extra whitespace.
there a line in the  beginning where  a header would be...

no problem with asking for another look, I'm glad to help.

yeah you could potentially be seeing new logins being created after your delete, so they show up in your query;...