Bob Duffy's Blobby Blog - All Comments

re: Problems with Virtual machine Bus in Hyper-V

Tim — Sun, 07 Oct 2012 01:42:23 GMT

And if I have not this option "Detect HAL" there?

re: A domain controller could not be contacted for the domain that contains an account for this computer

Dave — Tue, 13 Dec 2011 22:21:53 GMT

Amazing find. I wasn't able to remove AD from my 2008 R2 server because of that same error message. I added the computer$ account into that Default Domain Controller Policy and suddenly it worked. If it wasn't for this post, I'd still be banging my head against the desk.

THANK YOU!

re: The Gemini/PowerPivot Gallery View

pgilli — Sat, 03 Dec 2011 01:23:46 GMT

Could you please let me know which service account and on which box any farm server or to any specific server....? Appreciated

re: The Gemini/PowerPivot Gallery View

pgilli — Sat, 03 Dec 2011 01:20:53 GMT

do we need to log into the server where powerpivot for SharePoint installed...?

re: Data Connection Libraries missing in SharePoint 2010

Soni, Amar — Fri, 07 Oct 2011 11:17:46 GMT

Data Connection Libraries is feature of SharePoint 2010 Enterprise edition it's not available in SharePoint Foundation and SharePoint Standard Edition

re: Smart Indexing Part II - Conditional Rebuilding

Bob Duffy — Tue, 04 Oct 2011 19:14:38 GMT

Hi Gert,

I'm not working for MS anymore - blogging over at http://blogs.prodata.ie/bob

I didn't maintain this script as Ola Hallengren has invested a lot of time in making some more comprehensive scripts available that cover the likes of LOB compaction. http://ola.hallengren.com/

If you are using this to help roll your own, then STATISTICS_NORECOMPUTE = ON should also be STATISTICS_NORECOMPUTE = OFF in nearly all cases as turning off stats updates is very much an

re: Smart Indexing Part II - Conditional Rebuilding

Gert — Tue, 27 Sep 2011 08:28:55 GMT

Hi.

Just wondered if the existing version of the script has been updated with the re-org for LOB indexes?

re: Smart Indexing Part II - Conditional Rebuilding

Lxocram — Mon, 01 Aug 2011 10:38:11 GMT

line 89 : SELECT @command = 'ALTER INDEX ' + QUOTENAME(@indexname,'[') +' ON ' + QUOTENAME(@schemaname,'[') + '.' +QUOTENAME(@objectname,'[') + ' REBUILD'

re: JDBC: When Good Prepared Statements go Bad

Oleg — Mon, 28 Mar 2011 17:40:38 GMT

Erm, you didn't actually test the difference in performance, did you? You might want to do that. You might find that in this case this is more about a pet peeve than about the difference between "good" and "bad" - which in this case is negligible.

re: JDBC: When Good Prepared Statements go Bad

jose nadim — Sat, 30 Oct 2010 01:19:51 GMT

Gracias esto me ayudo en un gran problema con JDBC