637 reputation
211
bio website mitch-wheat.blogspot.com
location Perth, Australia
age
visits member for 2 years, 5 months
seen 15 hours ago
stats profile views 48

Developer (predominately C#, but not exclusively). Particularly interested in performance tuning and SQL Server. My blog is here.


May
25
comment Debugging SSAS Timeouts
Profiler?.......
May
18
accepted Visualiser for spatial query results
May
17
comment using CASE with ISNULL
+1. nice answer. :)
May
13
comment Mysql reliable with 1000 new entries / minute?
1000 per minute = 17 per second. Not very many. But ultimately it depends on your hardware and server load. Not a programming question as it stands.
May
12
comment Data dictionary best practices in SQL Server 2008 r2
"Every change to a database object requires an explanation of what the object is being used for or what they are fixing in that object " : isn't that normally termed "source code control"?
May
10
comment Get Maximum Value
what about ties?
May
5
comment How to tune mysql to be inmemory-like
der, of course! I'm stoopid!
May
3
comment Visualiser for spatial query results
Thanks, I'll look into this.
Apr
30
comment Denying direct remote access to SQL Server
use roles and windows groups and don't allow users ANY explicit access
Apr
27
asked Visualiser for spatial query results
Apr
15
comment sql server 2008 execution plan different on two production servers
Please post the query and the 2 query plans.
Apr
15
comment sql server 2008 execution plan different on two production servers
have you checked the server config? are you sure someone hasn't altered the parrallelism threhold?
Apr
15
comment sql server 2008 execution plan different on two production servers
maybe its just a poor query?
Apr
15
comment sql server 2008 execution plan different on two production servers
identical server config?
Apr
15
comment sql server 2008 execution plan different on two production servers
identical hardware?
Apr
15
comment sql server 2008 execution plan different on two production servers
same service pack and cumulative updates?
Mar
21
revised What are the differences between leaf and non-leaf pages?
deleted 18 characters in body
Mar
17
answered SQL Server update query on linked server causing remote scan
Mar
16
revised What are the differences between leaf and non-leaf pages?
added 159 characters in body
Mar
16
comment What are the differences between leaf and non-leaf pages?
will make clearer...