meta user
network profile
| bio | website | straightpathsql.com |
|---|---|---|
| location | New Hampshire | |
| age | 34 | |
| visits | member for | 1 year, 7 months |
| seen | yesterday | |
| stats | profile views | 159 |
Mike is a partner, Database Wellness expert and coach with the SQL Server consultancy Linchpin People. He is an experienced SQL Server professional and has worked with every version of SQL Server since version 6.5. He has been in the role of DBA, Developer, Architect and Performance Lead but always leans on his DBA and performance tuning experience. He loves providing training and coaching to clients and colleagues and has been recognized as a SQL Server MVP by Microsoft for two years in a row. He speaks at national and regional conferences and SQL Server events on DBA, Performance Tuning and Professional Development topics and he blogs regularly on SQL Server topics.
|
17h |
awarded | Enlightened |
|
17h |
awarded | Nice Answer |
|
May 9 |
awarded | Nice Answer |
|
May 1 |
awarded | Popular Question |
|
Apr 24 |
awarded | Notable Question |
|
Apr 22 |
awarded | Nice Question |
|
Mar 20 |
comment |
READ_COMMITTED_SNAPSHOT support in SQL Server 2005 Express You took all the money from petty cash for the swear jar, I thought? :) |
|
Mar 20 |
reviewed | Close How to recover data around corrupted data in table? |
|
Mar 20 |
reviewed | Close SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs |
|
Mar 19 |
comment |
READ_COMMITTED_SNAPSHOT support in SQL Server 2005 Express Good point @JonSeigel - not quite how I meant it when I typed it. I agree the Snapshot Isolation levels are a good way to think - and agree it is the default in Azure. It sure beats nolock hints everywhere and it is a good place to start if the infrastructure and TempDB are good to go for row versioning. I just tend to see it in the "box" with concurrency caused issues in busier apps (or reporting workloads against prod) and was asking about the use of Express. Looking back I guess I was somehow subconsciously knocking Express an that was wrong :-) |
|
Mar 19 |
comment |
Execute sp_WhoIsActive as a query Actually this proc needs to be run in Master. |
|
Mar 19 |
comment |
Execute sp_WhoIsActive as a query If you look at the Stored Procedure creation you can see what it does. You can also see the DMVs it uses. It is quite complex and Adam put a lot of time into it - it really works best as a Stored Procedure as you'll see but if you look at what it does you can learn how to query the DMVs necessary to find what you need.. I would suggest you find out more about why they won't allow it installed and point them to Adam's blog about the procedure or all of the reviews, awards, and blog posts about it. |
|
Mar 19 |
reviewed | Approve suggested edit on mysql table very large size although it doesn't have a lot of records |
|
Mar 19 |
comment |
READ_COMMITTED_SNAPSHOT support in SQL Server 2005 Express Cool - then yes this is a good solution for you and it does work. |
|
Mar 19 |
answered | READ_COMMITTED_SNAPSHOT support in SQL Server 2005 Express |
|
Mar 19 |
reviewed | Close Update a table field with another table field |
|
Mar 19 |
reviewed | Close Ms-Access 2007-2010 SQL - from single row record how to create multiple rows |
|
Mar 19 |
reviewed | Close where can I get mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz? |
|
Mar 19 |
reviewed | Close SQL Query to replace character based on join |
|
Mar 19 |
reviewed | Close SQL Server cluster questions please |
