418 reputation
28
bio website mitch-wheat.blogspot.com
location Perth, Australia
age
visits member for 5 years, 2 months
seen Aug 11 at 0:22

Software Developer (predominately C#, but not exclusively)

Interested in writing clear, concise code and performance tuning (code and SQL) and pretty much anything SQL Server related. My blog is here.


I coordinated the Perth .NET user group, in Western Australia for 5 years.


May
7
awarded  Excavator
May
7
revised What can user do with VIEW SERVER STATE permissions?
improved formatting
May
7
suggested suggested edit on What can user do with VIEW SERVER STATE permissions?
Jan
30
comment SQL Server to sql server linked server setup
+1 Great answer.
Jan
8
awarded  Citizen Patrol
Mar
13
comment Setting up Ola Hallengren's sql jobs
+1. Good answer. Should probably be migrated to dba.stackexchange ?
Feb
16
comment Fast storage for a server
what kind of usage patterns? i.e. is it lots of small searches, or just a few massive searches? Read/write ratio?
Feb
8
awarded  Yearling
Jun
16
awarded  Critic
Jun
3
comment Electricity gone off while shrinking database, how can I recover my database?
BTW, 25GB is not very huge. It's not even large.
Apr
30
comment Data file size - SQL Server 2008
deleting records does not reclaim space (with the default settings). Also, check TLog. Also, off-topic.
Mar
27
comment Memory Usage of SQL Server
not entirely sure what you are asking here....Are the servers set up identically? Do the sql server instnaces have the same config values?
Feb
4
comment Critical Virus infection with PHP website. What are the options to remove Virus?
"I can post the malicious script here" - No Thanks!
Oct
14
comment How does SQL Server handle simulataneous read/write requests?
I think you'll find very few things are ideal when talking to a real-world server...
Oct
14
comment How does SQL Server handle simulataneous read/write requests?
again: it depends: If boths queries hit the same table and hold locks it might be as high as A + B (or at least higher than MAX(A,B) )
Oct
14
comment How does SQL Server handle simulataneous read/write requests?
"two queries that take A + B when executed serially will take MAX(A, B) when executed simultaneously." - that's an optimistic view. Things are often more complicated on an active server
Oct
14
comment How does SQL Server handle simulataneous read/write requests?
"a single SCSI drive" - well there's your problem right there!
Oct
14
comment How does SQL Server handle simulataneous read/write requests?
have you benchmarked your I/O subsystem? where are your files placed? what are the relevant RAID arays?
Aug
3
comment When to / not to you index and table compression in mssql server
"save you allot of time benchmarking things that need not be bench marked" - almost everything needs to be benchmarked. If you don't, how do you know when there's a problem?
Aug
3
comment When to / not to you index and table compression in mssql server
Benchmark for your particular situation.