Viewing 15 posts - 8,356 through 8,370 (of 22,219 total)
Another way to do it is to use OPENQUERY. There are examples at the link.
"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 23, 2014 at 3:39 am
But triggers aren't read by the query optimizer, foreign key constraints are. You can actually get better execution plans because of enforced referential integrity.
"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 23, 2014 at 3:37 am
Yeah, hard to argue with you Kevin (like it's ever easy). 8gb of RAM for SQL Server is probably barely adequate. My local VMs running on my laptop get more...
"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 22, 2014 at 8:19 am
I'd say you have a critical I/O issue, but it looks like there are other things at play in there as well. The I/O issues start at 0200 and run...
"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 22, 2014 at 7:02 am
Only the output parameters are listed, but if you look at the values at the end, there are 7, same as the number of parameters you have defined within the...
"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 22, 2014 at 6:39 am
Ed Wagner (4/22/2014)
Thanks for posting the link to the article, Grant. I just learned something - I didn't know about LABELONLY. 🙂
Not a problem. That's why we're all out...
"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 22, 2014 at 6:28 am
SQL Swerver (4/22/2014)
"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 22, 2014 at 6:28 am
yuvipoy (4/21/2014)
most of my...
"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 22, 2014 at 6:24 am
andrew gothard (4/22/2014)
"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 22, 2014 at 6:22 am
SQL Swerver (4/22/2014)
GrantHow can the WASD Firewall be configured to allow Azure Weblications? They are internal to Azure with no external IP?
All the cloud services that I currently have (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 22, 2014 at 4:42 am
SQL Swerver (4/22/2014)
How would one configure the Azure SQL Database firewall to allow an Application hosted in Azure PaaS...
"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 22, 2014 at 4:39 am
Use correct data types. If you need a floating point number, use a float. If you're expecting an integer, use one of the integer data types, not the float.
"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 22, 2014 at 4:20 am
I'm with Yogeshwar Phull. Don't use show_contig any more. The dynamic management objects are so much better for this type of information.
"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 22, 2014 at 4:20 am
Deadlocks are fundamentally a performance issue. So, are the other databases the same size as the one that's getting the issue? Are the same indexes in place? Are the statistics...
"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 22, 2014 at 4:18 am
Here's the Books Online entry on DDL Triggers.
"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 22, 2014 at 4:13 am
Viewing 15 posts - 8,356 through 8,370 (of 22,219 total)