Viewing 15 posts - 17,371 through 17,385 (of 22,226 total)
Then you can probably get what you need by querying the DMV'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
May 27, 2009 at 12:20 pm
Yep. I just tried the update. It didn't seem to affect things at all. It sure sounds like the PK was not defined as the script you supplied. I can't...
"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
May 27, 2009 at 11:53 am
I agree. First option would be to query the DMV's to see what has been run. However, if you wanted to know what was run yesterday or last week, 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
May 27, 2009 at 11:12 am
Jeffrey Williams (5/27/2009)
If...
"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
May 27, 2009 at 11:05 am
Tom Brown (5/27/2009)
Bob Hovious (5/27/2009)
What's an index?We have a working title!
Chapter headings anyone?
And evidently a volunteer for the head author position. Well done.
"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
May 27, 2009 at 8:19 am
Alvin Ramard (5/27/2009)
Bob Hovious (5/27/2009)
What's an index?It's one of your fingers.
Oh, I thought that was a digit. All this computer-ese is so confusing.
"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
May 27, 2009 at 8:16 am
Roy Ernest (5/27/2009)
Hey Grant, I did not know that you brew your own beer... :w00t:
Actually, I haven't for about a year and a half. I miss it, but between writing...
"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
May 27, 2009 at 8:07 am
GilaMonster (5/27/2009)
"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
May 27, 2009 at 8:06 am
GilaMonster (5/27/2009)
"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
May 27, 2009 at 7:50 am
Gail has a couple of articles on performance tuning[/url] over at Simple Talk. You might want to check them out. I have an introductory article[/url] on execution plans that might...
"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
May 27, 2009 at 7:44 am
You could set it this way, not that I'd want to:
DECLARE @myval varchar(max)
SET @myval = '(''5'',''4'',''3'',''2'')'
The two single quotes will turn into one inside the variable.
But, the real question is,...
"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
May 27, 2009 at 7:42 am
Something else must be going on in your code. I copied these two lines:
CREATE TABLE OverallStatus (ID BIGINT IDENTITY(1,1) PRIMARY KEY, YP_code VARCHAR(15), datum DATETIME, Description VARCHAR(5000))
INSERT INTO OverallStatus (YP_code,...
"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
May 27, 2009 at 7:35 am
Doc (5/27/2009)
Roy have you forgot about the books from Grant Fritchey - "SQL Server 2008 Query Performance Tuning Distilled" and "Dissecting SQL Server Execution Plans"
Gail was still right. There is...
"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
May 27, 2009 at 7:31 am
This is opinion, but no. I'd say 2008 is more of an upgrade than 7 to 2000 was. Not by a lot, but more. However, knowledge learned of 2005 is...
"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
May 27, 2009 at 7:14 am
I worked for a dot com that had almost a tb on SQL 7. I'm working now for an insurance company and we don't have any databases over 100gb (yet,...
"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
May 27, 2009 at 7:12 am
Viewing 15 posts - 17,371 through 17,385 (of 22,226 total)