Viewing 15 posts - 1,486 through 1,500 (of 5,843 total)
a4apple (7/8/2015)
1) local variables just shift parameter sniffing to a different form of problem
2) remove local variables and use the sproc parameters and then try option recompile (preferably on just...
July 9, 2015 at 12:21 am
Innerise (7/8/2015)
July 8, 2015 at 8:42 am
Innerise (7/7/2015)
We have a 2-node SQL Server 2012 AlwaysOn setup, in synchronous mode with readable replica databases. We have a particular reporting query that we're running against one of...
July 7, 2015 at 11:08 am
Her process is patently ridiculous. Period. She should be working to find/correct the "cause" of the "huge" tlogs. But if they get large for a given reason that is valid...
July 7, 2015 at 5:19 am
a4apple (7/6/2015)
I have a stored procedure which is nested. I have local variables defined to avoid parameter sniffing in both the procedures too.
Proc A calls PROC B, PROC C,...
July 7, 2015 at 5:16 am
Check the table trigger(s)
July 5, 2015 at 9:53 am
We will be much more willing to help you if you script create table statements and inserts for us that set the data up the way you show it. That...
July 4, 2015 at 11:28 am
You have functions around columns in the WHERE clause. No matter what else, you can't efficient until those are removed.
June 26, 2015 at 9:54 am
Very odd situation, but this script will create login scripts from existing logins in ACTUAL master. The only question is can you access the tables the script hits from a...
June 18, 2015 at 11:31 am
A secondary cannot possibly have a 14-byte pointer for reading data (NULL or populated) without the primary first having such alteration made to the row. The primary MUST reflect the...
June 11, 2015 at 10:22 am
snuthalapati (6/10/2015)
If we have more than 100 databases on...
June 11, 2015 at 6:37 am
I think you missed a VERY important type of test in your examples: 1M row inserts at a time, in discreet transactions. Please try that (primarily for the insert to...
June 9, 2015 at 7:54 am
sql_novice_2007 (6/8/2015)
I have a delete trigger on one table. When I delete a single row in this table that deleted record will be recorded to a history table.
But sometimes my...
June 8, 2015 at 8:23 pm
Never thought of this way of doing it. Absolutely clever - this one goes into my bag of tricks. Love this forum - learn something new every day.
Glad you liked...
June 2, 2015 at 8:56 am
Viewing 15 posts - 1,486 through 1,500 (of 5,843 total)