Table Space updated again

Categories: News, Professional, Scripts, SSC
Comments: 2 Comments
Published on: March 28, 2014

Today we have another update for an age old script on this site.  You can find the last update to the script here.

This time we have a bit of a bug update.  The details of that bug are in the notes for the script.

Alternatively, you can download the script from here (in case a plugin update breaks the script again).

page 1 of 1








Calendar
March 2014
M T W T F S S
« Feb   Apr »
 12
3456789
10111213141516
17181920212223
24252627282930
31  
Content
SQLHelp

SQLHelp

  • @SQLAmerica: The IIF function (introduced in 2012) doesn't seem to work in SQL Server versions 2008, 2012 and 2014.Do I need something enabled? #SQLHelp
  • @SQLSoldier: @dev_b That was an optimization added in (I think) SQL 2012. But don't think that means its free. It still takes a lock, etc. #sqlhelp
  • @dev_b: #SQLHelp Looking at fn_dblog, LOP_DELETE_ROWS is invoked only when the column value changes? 2/2
  • @dev_b: #SQLHelp ORM updates all columns with the existing values, is SQLserver is smart to ignore those or will it updates all columns in a row?1/2
  • @Kevin3NF: @buddingeek @bflippin If they try to get you to use one service for all SQL on all servers,tell them one hack takes down the farm #SQLHelp
  • @skreebydba: @SQLSoldier Okay, thanks. #sqlhelp is the best thing going because of folks like you.
  • @SQLSoldier: @skreebydba Look at, yes. Be able to read them, no. They're not in a readable format and the format is not documented. #sqlhelp
  • @buddingeek: @bflippin have already asked my windows team to create a dedicated domain service account for sql agent jobs . #sqlhelp
  • @skreebydba: @SQLSoldier Robert, thanks for the rapid response. Is there a way to look at the contents? fn_dblog() etc... #sqlhelp
  • @SQLSoldier: @skreebydba The commands needed to revert the rollback the database to the point before it recovered the db to bring it online. #sqlhelp

Welcome , today is Thursday, September 29, 2016