Viewing 15 posts - 6,496 through 6,510 (of 22,229 total)
It's only 238 lines. That's what, two printed pages, maybe three. We don't start talking about how evil a query is until it breaks at least 10 printed pages.
So, we...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 4:12 pm
I don't know of any way to query the hypervisor from within T-SQL. Not directly. Assuming the login your SQL Server instance operates under has permission to the hypervisor, it's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 3:55 pm
Still ought to see some sort of error. Maybe you're just getting a timeout while it waits for a lock to clear? What's calling the truncate statement?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 3:53 pm
Definitely set the max memory.
How big is your database? How many people are accessing it at the same time?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 11:31 am
Yeah, all those table scans are not doing you any favors whatsoever.
The query plan is timing out too, which means it's unstable. Run it on another day when there's a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 11:12 am
SQLRNNR (4/1/2015)
Who remembered to do an April Fools post today?
No inspiration for one this time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 9:15 am
Perry Whittle (4/1/2015)
Ratheesh.K.Nair (4/1/2015)
Remove the primary database from Availability Group. Shrink the DB and then add it back.
This is the last thing you should do and you'd be well advised...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 9:14 am
jellybean (4/1/2015)
0. On the *separate* target box install Sql Server 2014
1. Upgrade to Sql Server 2005 SP4 if not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 9:13 am
Arjun SreeVastsva (4/1/2015)
I have tried to shirnk the database also below error I am getting
The transaction log for database 'New' is full due to 'AVAILABILITY_REPLICA'. (Microsoft SQL Server, Error:...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 5:50 am
To begin to get an understanding of what is needed to help out, I'd like to suggest getting a copy of the book "Troubleshooting for the Accidental DBA." It's free...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 5:49 am
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Wow. "Here's a screen shot that says the same thing I already typed. That should clear up everything."
Frightening.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 5:46 am
Perry Whittle (4/1/2015)
Grant Fritchey (3/30/2015)
Although, ideally, you'd store them all in a central location so they're available immediately...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2015 at 4:18 am
A common table expression is just a derived table (except when we're talking about recursion). So you can just treat it as another table in the query:
WITH myCTE AS
(SELECT *...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 31, 2015 at 4:59 pm
Could you capture the execution plan? There's just too much to walk through there. If we can see what the optimizer is doing, it'll be easier.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 31, 2015 at 3:36 pm
Are all the properties on each of the operators in the plan exactly the same?
On a guess, I'd be inclined to suggest differences in the ANSI settings possibly causing differences...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 31, 2015 at 3:34 pm
Viewing 15 posts - 6,496 through 6,510 (of 22,229 total)