21,430 reputation
33573
bio website blogs.msdn.com/b/sql_pfe_blog
location In the Ocean somewhere...
age
visits member for 2 years, 9 months
seen 8 mins 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
4
revised ASPState Log file growing tremendously - SQL Server 2008
added 240 characters in body
Dec
4
answered ASPState Log file growing tremendously - SQL Server 2008
Dec
4
comment Uninitialized Merge replication subscription
Open up the Replication Monitor and take a look at the agents. You should be able to see the errors that correspond to your issue.
Dec
4
comment Join tables on a partial string match
What exactly are you trying to do? It seems like you're taking a procedural-based approach when this can be done set-based.
Dec
4
revised Performance effects of database file size and available space
added 2 characters in body
Dec
4
answered Performance effects of database file size and available space
Dec
3
comment Identify why a user can drop a database
Look at which permissions are required (msdn.microsoft.com/en-us/library/ms178613.aspx) and reverse engineer it.
Dec
3
revised Only a single WITH MOVE clause should be specified for any logical file name
added 51 characters in body
Dec
3
answered Only a single WITH MOVE clause should be specified for any logical file name
Dec
2
comment Agent job will not run
Look in the SQL Server Agent's error log for any peculiar and indicative messages.
Nov
30
comment How to force the use of row locks?
+1 great information, Paul
Nov
28
revised Renaming SQL Server Agent operator
added 282 characters in body
Nov
28
answered Renaming SQL Server Agent operator
Nov
28
comment Divide by Zero Causing Error transaction to fail with Arthimetic Abort and ANSI WARNINGS FALSE after upgrade
Can you post the code that is causing the error?
Nov
25
comment Execution plan shows expensive CONVERT_IMPLICIT operation. Can I fix this with indexing or do I need to change the table?
Wow, great information here. I +1'd it but I wish I could give it +1000000.
Nov
25
revised When To Update Statistics?
added 41 characters in body
Nov
24
comment Running queries against multiple servers
Another possibility is to write a PowerShell script and using SMO do all of this logic, then just call the script from a SQL Server Agent job.
Nov
24
comment Running queries against multiple servers
@PeteCarter I'm with Aaron on this one. Why can't you create linked servers??
Nov
24
answered Running queries against multiple servers
Nov
23
answered Why Do Replication Deletes Require sysadmin Access