Getting up and Running with Crescent on CTP 3

The sharepoint requirement for Crescent is a bit of a show stopper if Sharepoint isn’t your day job. The following is an excellent step by step guide to getting up and running with a crescent demo. The following will be enough to get the Picnic Demo up and running. If you want to go on…

0

WindDbg – setting up symbols

I don’t do this often enough, so Rob Martin just dictated this to me over my shoulder: .sympath srv*c:\windows\symbols*http://msdl.microsoft.com/download/symbols !sym noisy .reload /f I’m good to go with !dumpheap -stat – job done   Original post by Ryan Simpson on 26/05/11 here: http://rionisimpsoni.wordpress.com/2011/05/26/winddbg-setting-up-symbols/

0

Partition limit increased to 15,000 in Sql 2008 R2 SP1

Just been going over the whitepaper ‘Support for 15,000 partitions in Sql 2008 SP2′ which is now updated to be ‘and Sql 2008 R2 SP1′ – which is fortunate because: 1) it was updated in March this year, and 2) has a concrete reference to Sql 2008 R2 sp1 (we’re currently at CU #6, released…

0

Query Tuning Quick wins: Bookmark lookups – Kill Bill

Frequently a quick win in query tuning is to remove a bookmark, or key lookup. A key lookup occurs when we have to resolve another column that wasn’t part of the index used to satisfy the query. Frequently, Sql will avoid calling a bookmark lookup and just brute force its way down the clustered index…

0

Changing the User Account for Reporting Services 2008 (not R2) in SharePoint 2010 in Integrated Mode

It looks like the R2 documentation is either wrong, or simply doesn’t apply when you’re trying to change the account for reporting services Sql 2008. I also found the online docs for 2008 didn’t match what I was seeing (detailed here:http://technet.microsoft.com/en-us/library/bb326213(SQL.100).aspx). After changing the account in the configuration manager, the give away message was in…

0

DateTime as BigInt

Been looking at writing RML utilities for Analysis services, and having some success, however, the function that kept coming up was generating the datetime as a bigint -> all I really need is the number of zeros for each value. For my own sanity here is the current datetime down to the nearest second expressed…

0

My new favourite diagnostic query for CPU

So, what do you do when you’ve been running a stress test, Sql CPU has been maxing out, and you’ve not been running profiler (to analyze in RML Utils) so have got no record of what happened – ans, provided te DMVs haven’t been cleared by the time you get to the box, the following…

0

Cross Join Crazies and Scalar Value Function Optimization

Just on a flight out to TechReady, and took some time to finally pull this article together. And I apologise right now – I did promise my next post was going to be an MDX primer, but this one has been kicking around in my head now for a while. I’ll also add that this…

0

Sql Tools I use in the UK ADC Scalability Lab

As part of the ADC offering, we have a full scalability lab, which allows us to work with our customers by lifting their application into Thames Valley Park, and stress it – either for the purposes of performance tuning, or just seeing where it breaks. Often it could just be PoC work for an architecture…

0

Getting started with WinDbg and Sos.dll

I wrote this largely to get the commands right in my own head – as a result, this is more a list of commands and some semblance of a sequence you can run them in. If you’ve never used these tools before this will get you out of the gate on WinDbg and the debugger…

0