822 reputation
311
bio website mitch-wheat.blogspot.com
location Perth, Australia
age
visits member for 3 years, 6 months
seen Jul 17 at 6:50

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
28
revised SQL performance issues with remote query across linked server
added 2 characters in body
May
7
comment Restore a backup from SQL Server 2008 R2 to SQL Server 2014
should be possible. you probably have a corrupt or partial file.
Feb
19
comment Trigger to restrict users from creating a new table in the database
Use permissions to "restrict any user from creating a new table in the database "
Feb
5
answered SQL Server 2008 R2 Resource Managment
Jan
19
awarded  Yearling
Jan
18
comment The memory usage of SQL Server keeps growing
RTM!?! Why? Just Why? RTM is not service pack 1. Which is it???? I doubt you will get any serious help on that old a version. Also I note that you are on a VM. what's the ballon manager settings? Memory reservation? In short, hire a local consultant!
Jan
18
comment The memory usage of SQL Server keeps growing
what version? (R2?) what service pack? What cumulative update?
Jan
18
comment The memory usage of SQL Server keeps growing
The symptom of SQL server using increasing memory is usually a red herring (that's how it is designed, and it will give it back if configured appropriately). More likely when you restart server some bad plans get flushed from plan cache....
Jan
18
comment The memory usage of SQL Server keeps growing
Out of all apps, SQL Server does an amazing job of memory management. Are you sure you have a memory problem, and not poor indexes/bad TSQL? And what Marc_s said... Also, can you explain "25k users " a bit more. Is that 25K+ connections at the same time?
Dec
17
comment How to find current roles available on a database
your supposed to know what roles you run a function, by definition.
Sep
24
comment Does ROLLBACK TRAN honor LOCK_TIMEOUT value?
ROLLBACK TRAN rolls back a transaction. That's it! Please clarify what you are asking
Sep
14
answered Restore failed for server (Microsoft.SqlServer.SmoExtended)
Sep
14
comment Restore failed for server (Microsoft.SqlServer.SmoExtended)
"RESTORE detected an error on page (44262:41495)" - what's hard to understand?
Sep
9
comment Better Indexing for MySQL?
this answer completely misses the point about covering indexes
Sep
9
comment Better Indexing for MySQL?
It depends....on your workload and whether you want to speed up particular queries
Aug
24
comment How to access a SQL Server database from other computer connected to the same workgroup?
try using the IP address for 'data source'
Aug
6
comment Whitelisting access to a single table
using roles and permissions
Jul
28
comment Can not find 'NT AUTHORITY\NETWORK SERVICE'. on Sql Server 2012
How does accepting an answer work?
Jul
28
answered Can not find 'NT AUTHORITY\NETWORK SERVICE'. on Sql Server 2012
May
25
comment Debugging SSAS Timeouts
Profiler?.......