27,164 reputation
54890
bio website tstringer.azurewebsites.net
location In the Ocean somewhere...
age
visits member for 3 years, 9 months
seen 1 hour ago

SQL Server Support Escalation Engineer at Microsoft.

Twitter: @SQLife
Blog: http://tstringer.azurewebsites.net
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.


Apr
18
revised Reducing Log Impact During Re-Indexing
edited title
Apr
17
comment Migrating from SQL Server 2005 to SQL Server 2008 R2 on a different box
+1 Great info. I personally revert to the SSIS solution. Between it's simplicity (it is extremely simple, even if you never work with SSIS), options, error handling, and reusability. Handles more than just logins and jobs for server-object migration. Thought worth mentioning. Again great answer, Aaron, as I've used to this process many times without a single issue.
Apr
17
comment Querying number of subscription to each publication
Is MSmerge_subscriptions what you're looking for? msdn.microsoft.com/en-us/library/ms188905(v=sql.110).aspx
Apr
17
comment Unique Constraint with multiple null columns
That's by design (msdn.microsoft.com/en-us/library/ms191166(v=SQL.105).aspx). What's your question?
Apr
16
revised Find application password expiration date
edited tags
Apr
16
answered Find application password expiration date
Apr
16
comment SQL Server 2012, Network for: AlwaysOn Availability Group with AlwaysOn AlwaysOn Failover Cluster Instances
@ElijahW.Gagne No that's not correct. If your driver doesn't support MultiSubnetFailover then you just need to set RegisterAllProvidersIP to 0 in your cluster so that only the online IP address is registered to prevent connection latency/timeouts.
Apr
15
revised Linked server performace issue?
edited title
Apr
12
comment How do I optimize large table so queries that target only recent data perform optimaly?
Also, if you could post your query(ies) that you're trying to optimize, that would be helpful.
Apr
12
revised How do I optimize large table so queries that target only recent data perform optimaly?
edited tags; edited title
Apr
12
comment How do I optimize large table so queries that target only recent data perform optimaly?
Can you post the DDL of the table, as well as any accompanying indexes? Are you basically seeing scans on this table/CI?
Apr
12
comment What is the best permissions to set for only creating and managing own databases?
@SamS. Glad that worked for you!
Apr
12
comment What is the best permissions to set for only creating and managing own databases?
@SamS. How about granting CREATE ANY DATABASE to the login?
Apr
12
comment What is the best permissions to set for only creating and managing own databases?
I don't recommend that. Straight out of BOL: "Members of the dbcreator fixed server role can create, alter, drop, and restore any database." It doesn't look like the OP is wanting that login to have those extensive permissions.
Apr
11
comment dead lock when updating
Do you have the deadlock graph (XML) to post?
Apr
10
comment Database locked
What does this query return? select state_desc from sys.databases where name = 'Your Database Name'; Where 'Your Database Name' is your database name.
Apr
10
revised Database user permissions: GRANT VIEW DEFINITION but DENY on some object types
added 8 characters in body
Apr
8
reviewed Approve Moving model database
Apr
4
comment Slow SSRS Report in production
Before you jump into blaming concurrency, first find out what the report's query is waiting on. Can you execute the query manually? If so, do a few things while this is happening: Grab the execution plan and what it is waiting on (via sys.dm_os_waiting_tasks). Post that information if you can and we can further troubleshoot.
Apr
3
revised How to add additional hard drive(s) to existing database
deleted 2 characters in body