22,750 reputation
33979
bio website blogs.msdn.com/b/sql_pfe_blog
location In the Ocean somewhere...
age
visits member for 3 years
seen 2 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.


Jan
31
answered SQL Database automatic back up
Jan
30
revised Index Key Column Order
added 159 characters in body
Jan
30
comment Index Key Column Order
@Wojteq They are undocumented. See here: blogs.msdn.com/b/sqlserverstorageengine/archive/2006/12/13/…
Jan
30
revised Index Key Column Order
deleted 2 characters in body; edited title
Jan
30
answered Non-Clustered-Index on a temporary table
Jan
30
revised Index Key Column Order
added 699 characters in body
Jan
30
answered Index Key Column Order
Jan
30
comment Transactional Replication Over Domain
Also take a look at this: support.microsoft.com/kb/321822
Jan
30
comment Transactional Replication Over Domain
The account that the Distribution Agent runs under needs to be a member of the db_owner fixed database role in the subscription database. Can you confirm whether or not this is the case? Is that the agent you were talking about in your question? Hard to tell without clarification. Also, see if anything is logged in the subscriber's error log.
Jan
29
comment Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
+1 great information!
Jan
29
comment Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
+1 great answer and interesting information, Paul.
Jan
28
comment How to get a list of global temporary tables in the current database?
I agree with @AaronBertrand on this topic. There has to be a very strict and explicit requirement for global temp tables.
Jan
28
comment How to recover data around corrupted data in table?
What exactly is corrupted on your table? Is it the clustered index (or heap) or a nonclustered index? Are you able to put the DBCC CHECKDB output in your question?
Jan
27
revised Why did my transaction log grow so much?
added 133 characters in body
Jan
27
answered Why did my transaction log grow so much?
Jan
25
revised Transaction log for SQL Server is too big
added 167 characters in body
Jan
25
revised Transaction log for SQL Server is too big
edited body; edited tags
Jan
25
answered Transaction log for SQL Server is too big
Jan
25
comment How much disk space needed for 100GB of DBs?
It all depends on how often you plan on taking transaction log backups combined with how many logged transactions are happening between backups.
Jan
25
revised Can I retrieve all database objects owned by a particular user?
edited tags