Reputation
447
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 9
Newest
 Enlightened
Impact
~62k people reached

Mar
24
awarded  Enlightened
Mar
24
awarded  Nice Answer
May
7
awarded  Excavator
May
7
revised What can user do with VIEW SERVER STATE permissions?
improved formatting
May
7
suggested approved 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?