22,790 reputation
33979
bio website blogs.msdn.com/b/sql_pfe_blog
location In the Ocean somewhere...
age
visits member for 3 years
seen 3 hours ago

SQL Server Premier Field Engineer at Microsoft.

Twitter: @SQLife
Blog: http://blogs.msdn.com/b/sql_pfe_blog/
Email: sqlsalt [at] outlook [dot] com

Disclaimer
The views expressed on my posts on this site are mine alone and do not reflect the views of my company. All posts of mine are provided "AS IS" with no warranties, and confers no rights.

The following disclaimer applies to all code, scripts and demos available on my posts:

This Sample Code is provided for the purpose of illustration only and is not intended to be used in a production environment. THIS SAMPLE CODE AND ANY RELATED INFORMATION ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. We grant You a nonexclusive, royalty-free right to use and modify the Sample Code and to reproduce and distribute the object code form of the Sample Code, provided that You agree: (i) to not use Our name, logo, or trademarks to market Your software product in which the Sample Code is embedded; (ii) to include a valid copyright notice on Your software product in which the Sample Code is embedded; and (iii) to indemnify, hold harmless, and defend Us and Our suppliers from and against any claims or lawsuits, including attorneys’ fees, that arise or result from the use or distribution of the Sample Code.


Dec
31
answered Does this mean the 'public' has full select, insert, update, and delete access?
Dec
29
reviewed Approve suggested edit on Restore .mdf data file for a File Group in SQL Server
Dec
28
comment Sql server update query locking stages?
What do you mean, "scan"? I think you might be thinking procedurally here. Can you explain what you perceive to be happening?
Dec
28
comment Proper Index for WHERE X <> 1 AND Y <> 1 ORDER BY Z
Take a look at some investigation on sorting here: dba.stackexchange.com/questions/29985/…. I'm with Martin on this, can you show the create table and the index DDL as well?
Dec
26
comment Powershell to dump database schema to text file
This looks like what you're looking for: blogs.technet.com/b/heyscriptingguy/archive/2010/11/04/…
Dec
26
answered Sql server update query locking stages?
Dec
24
comment Sql server update query locking stages?
An update lock will be taken for the first portion of the search operation. Then if/when data needs to be updated the update lock will be converted into an exclusive lock. Take a look at here to get more info on the update lock (sqlblog.com/blogs/kalen_delaney/archive/2009/11/13/…).
Dec
19
comment Get disk space percentage free with SQL Server 2005?
@AaronBertrand I agree wholeheartedly, and I have noted that as well.
Dec
19
revised Get disk space percentage free with SQL Server 2005?
added 279 characters in body
Dec
19
answered Get disk space percentage free with SQL Server 2005?
Dec
19
revised Bulk Data Loading and Transaction Log
edited tags
Dec
19
answered Bulk Data Loading and Transaction Log
Dec
17
revised Does firing off an indefinite WAITFOR increase the log file size?
edited title
Dec
17
revised Track access to database
added 60 characters in body
Dec
17
answered Track access to database
Dec
13
comment DELETE vs TRUNCATE
+1 great and thorough answer, Paul!
Dec
13
answered How to store lots of small text in a SQL Server database?
Dec
12
comment SQL Server Profiler behavior?
See the SQL Trace Architecture (technet.microsoft.com/en-us/library/ms187933(v=SQL.105).aspx).
Dec
12
revised How do Availability Groups work with cheduled jobs and SSIS packages?
added 6 characters in body
Dec
12
comment Transactional Replication Snapshots causing serious locking after 2012 upgrade
What are the waits? What resource(s)? Is the snapshot process longer duration now?