Forum Replies Created
Viewing 15 posts - 8,881 through 8,895 (of 22,232 total)
-
RE: Understanding Graphical Execution Plans - Part 1: Explaining the Plan
rchantler (2/18/2014)
"If an object in the query does not exist, the validation fails and no estimated plan is created"Is something executed in this case, i.e. is there an actual execution...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Downstream query recompile when index is drop and re-created.
Happy to help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Downstream query recompile when index is drop and re-created.
Test it:
CREATE TABLE dbo.LetsRecompile(
ID INT IDENTITY(1, 1),
MyVal VARCHAR(50)
);
GO
CREATE INDEX WhatHappens ON dbo.LetsRecompile...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Database security
Sure. Go read this book by Denny Cherry.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
wolfkillj (2/19/2014)
Fixed that for you.SQLRNNR (2/19/2014)
Yay - I'mfinallyinsane!!! :hehe::w00t:I was wondering who was going to break it to him.
Congrats Jason.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: mdf / ndf backup confusion
You can always look at the backup files themselves to understand the structure of the database that was backed up. I have an article on that on Simple-Talk[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
SQLRNNR (2/19/2014)
Grant Fritchey (2/19/2014)
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason, not sure about...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: MIGRATION FROM SQL 2005 TO SQL 2012 (SP_MAKEWEBTASK)
I've never used this, so I don't have a good answer for you. The suggested Microsoft answer is to switch to using SSRS to generate HTML. They don't have a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: whats in the buffer pages
Server-side trace, not Profiler, please. The Profiler gui can have serious negative impacts on performance and really shouldn't be used against production systems.
Further, since you're on 2008, you could look...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION otions
And just using snapshot isolation, as opposed to read committed snapshot, requires changes to the code which people are usually not prepared to make. I'd just recommend using read_committed_snapshot as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL server 2008 R2 - CXpacket wait type
I'd be interested in seeing the execution plan to better understand how things are resolving, but, this alone will lead to scans of the temporary table:
ON CAST(Machine.MachineKey AS VARCHAR(50)) COLLATE...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Dumb interview answers
Gazareth (2/19/2014)
Grant Fritchey (2/18/2014)
"I can't believe you're asking me all these product specific questions. You shouldn't be writing your queries using product specific language because that eliminates the ability to..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Dumb interview answers
"I can't believe you're asking me all these product specific questions. You shouldn't be writing your queries using product specific language because that eliminates the ability to quickly and easily...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Poor performance using linked servers for cluster-to-cluster communication
The first server on both systems has pretty similar waits. It's the second servers where things get different, especially with the async_network_io, which doesn't usually indicate network problems. Normally 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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 8,881 through 8,895 (of 22,232 total)