| 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... |