Viewing 15 posts - 5,326 through 5,340 (of 22,219 total)
I agree with Jayanth, for specific advice, the query and the existing execution plan.
But, general advice, yes, a non-clustered index can be used in an UPDATE statement to help 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
December 10, 2015 at 3:45 am
A single SELECT statement without any kind of filtering offers very little in the way of query tuning. A scan is the best way to access the data in this...
"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
December 10, 2015 at 3:44 am
Take a look at the model database on the servers. I'm pretty sure that determines how things are set by default.
"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
December 10, 2015 at 3:41 am
That's a no-go here too. I set up the test like this:
CREATE PROC dbo.ExEventTest (@ID INT)
AS
SELECT *
FROM dbo.Test1 AS t
WHERE t.ID = @ID;
GO
CREATE PROC...
"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
December 9, 2015 at 8:56 am
SQL Guy 1 (12/9/2015)
Yes, it's for debugging. If it's impossible with trace, what other means can I use? Will extended events or reading transaction log give me these values?
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
December 9, 2015 at 7:33 am
SoHelpMeCod has already pointed out the issue. You don't have a defined primary key on the table.
We're all over the map here, bouncing from one thing to another. You need...
"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
December 9, 2015 at 4:45 am
Looks like that's being called from within another procedure. Unless you also capture that procedure, I don't know of a way to do this using trace.
"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
December 8, 2015 at 11:15 am
WhiteLotus (12/7/2015)
Hey Grant Fritchey,Can you please review the attached execution plan please ?
Many thanks
The one previously attached? I did look at them. You have a wild card search that will...
"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
December 8, 2015 at 4:18 am
Hi Nick,
Yeah, it's making that call on what calculation against the data is going to result in... anything.
For example, if you have two columns of data, KMean would let...
"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
December 7, 2015 at 8:18 pm
danechambrs (12/7/2015)
Once, I did all that, I got this error:
Error: Incompatible lengths for set aesthetics: colour, hjust, label
which is where I find myself stuck
I hit those errors with 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
December 7, 2015 at 6:57 pm
It really does depend on the organization.
Probably, you'll be in the on-call rotation. You'll probably have a second-tier person to back you up in case you get stuck. You'll...
"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
December 7, 2015 at 12:13 pm
Alan.B (12/7/2015)
"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
December 7, 2015 at 11:28 am
Ah, figured out that part of my problem is that I don't have the GGPLOT library. Off to track that down.
Seriously, thanks again for this. You've started me exploring exactly...
"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
December 7, 2015 at 6:45 am
I'm getting errors from this bit. It could be that I'm using RevolutionR, or it could be Steve's formatting:
# load GGPLOT library(ggplot2) plot.data <- data.frame(pca$x[, 1:2]) g <- ggplot(plot.data, aes(x=PC1,...
"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
December 7, 2015 at 6:28 am
Looks like this code was missing a set of quotes:
data <- read.csv("hotspots_data.csv)
Or am I wrong on that. I ran my local copy with closing quotes around the hotspots_data.csv file name...
"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
December 7, 2015 at 6:23 am
Viewing 15 posts - 5,326 through 5,340 (of 22,219 total)