69,386 reputation
990177
bio website sqlsentry.com
location Rhode Island
age 40
visits member for 3 years, 9 months
seen 24 mins ago

Senior Consultant at SQL Sentry, SQL Server MVP, @AaronBertrand on twitter, blogger at sqlperformance.com, blogs.sqlsentry.com, and sqlblog.com, Mac user, volleyball player, curler, hockey/football/tennis fan, big-time loser at fantasy football, proud father of two beautiful girls, and a Canadian, eh?


6h
comment SPExecuteSQL;1 keeps executing internally
Have you run a server-side trace to see what is being executed and where it's coming from? You can't stop something if you don't know what it is. Also how exactly do you know that this is the cause for your high CPU?
1d
comment Trigger For prevent inserting data
This question appears to be off-topic because it was also posted to Stack Overflow where it is getting more attention.
1d
comment Oracle - Slow queries without prepending schema name or providing hint
Please edit additional information about the question into the question, not as a separate answer.
1d
revised Trigger For prevent inserting data
Please format code as code, not as a numbered list.
1d
answered Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?
1d
revised Retrieving n rows per group
added 848 characters in body
2d
comment Aggregation Operations on View Ignores Index
A non-indexed view doesn't store any data, and you can't index a view with subqueries, unions, etc. I think you need to consider materializing the data in a different way, such as splitting that view up into two views and then querying against them, or bypassing the view altogether.
Dec
24
comment How to modify an existing AlwaysOn Availability Group IP
So you have AGs on top of an FCI on top of a WSFC which sits on top of an ESX cluster?
Dec
24
comment How to modify an existing AlwaysOn Availability Group IP
Doesn't DNS take care of this for you? I really don't think you're going to need to uninstall and reinstall SQL Server or start the AG configuration all over again.
Dec
24
answered Index that mimics full-text-index
Dec
24
comment Please explain log-shipping delta
Other than the definitions in the documentation I already pointed out?
Dec
24
comment Reasons for avoiding large ID values
@rumtscho Tell your boss that a surrogate number is just a meaningless number ("size" of the number is irrelevant) and that gaps in a sequence are natural and largely unavoidable.
Dec
24
comment Please explain log-shipping delta
Well, which delta? What are your monitoring alerts actually checking for, and at what threshold do they panic? We have no idea what you're monitoring for or why they are deeming this to be alert-worthy, so you have more answers to your questions right now than we do.
Dec
24
comment Please explain log-shipping delta
That tells me absolutely nothing.
Dec
24
comment Please explain log-shipping delta
I am seeing delta increases - where are you seeing this?
Dec
24
comment Usage of temporary tables in my tempdb database on sql server 2005
1. It's very odd to have an odd number of data files. Why aren't there 4 data files and 1 log file? 2. Yes, you should try and isolate tempdb I/O from other I/O as much as possible. Easiest would probably be to drop the two additional data files, then re-create all 4 in a better location, making sure that they all have the same file size and growth rate. Also consider setting global trace flags 1117 and 1118.
Dec
24
comment Index that mimics full-text-index
Sorry, no idea. What made you switch to Compact in the first place? How long ago did you do it? How much has your database really changed since then?
Dec
24
comment SQL Server : scheduled JOB issue
You are solving the wrong problem the wrong way. Please read this post in its entirety.
Dec
24
comment Index that mimics full-text-index
You know Compact Edition is deprecated, right? Have you considered using Express with Advanced Services, which includes full-text search?
Dec
24
comment How to modify an existing AlwaysOn Availability Group IP
Are you just trying to add a listener? Did you read the documentation?