269 reputation
17
bio website preetsangha.blogspot.com
location Auckland, New Zealand
age 46
visits member for 1 year, 5 months
seen Jun 14 at 12:31
stats profile views 7

I'm a engineer who loves to solve really meaty problems - the ones where you usually end up frying your brains doing so.

I'm also available for consultancy - please feel free to check me out on careers or email me directly on preetsangha@gmail.com


Jun
10
accepted Strategies for organising SQL Server with large amount of RAM
Jun
10
accepted When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
Apr
12
comment When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
Thank you for your comment. I will see if that's possible in the given architecture.
Apr
12
comment When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
Yes about an hour
Apr
12
comment When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
@MaxVernon - i've edited the question.
Apr
12
revised When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
added 112 characters in body
Apr
12
comment When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
Thanks man. Please see my update. We've just repeated our test after moving the log. It still took 1 hour.
Apr
12
revised When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
added 195 characters in body
Apr
11
asked When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
Mar
13
comment Strategies for organising SQL Server with large amount of RAM
Wow thanks. That's a good starting point for my reading.
Mar
12
awarded  Yearling
Mar
12
revised Strategies for organising SQL Server with large amount of RAM
added 4 characters in body
Mar
12
revised Strategies for organising SQL Server with large amount of RAM
edited body
Mar
12
asked Strategies for organising SQL Server with large amount of RAM
Feb
18
awarded  Critic
Jan
29
comment Getting SQL Server query history
Good question, but I think this would be better answered by the dba gods on dbs.stackexchange.com
Jan
24
comment How should I configure these disks on a SQL Server for a BI configuration?
Thanks for you advice @MarkStorey-Smith
Jan
24
comment How should I configure these disks on a SQL Server for a BI configuration?
Thank you. This is a client's server so they will make the final decision but we accept that large fast redundant stripes are the best we should aim for. Our own servers use large SSD stripes.
Jan
23
accepted Splitting TempDB into multiples files equal to number of CPUs
Jan
23
comment Splitting TempDB into multiples files equal to number of CPUs
Thank for the links