Viewing 15 posts - 17,371 through 17,385 (of 22,219 total)
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
AShehzad (5/26/2009)
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
Are you sure? 😉
But since you shouldn't automatically rebuild all indexes all 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 7:08 am
If people are posting code on the net, it has to be with the expectation that it will be used by others. I know that's the assumption that I have...
"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 6:49 am
Tell them not to drop tables. In 2000 we couldn't revoke their privileges to create indexes. We had to tell them not to do it. Although, since we built our...
"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 5:33 am
Create a role that you're going to add your developers to. Then add ddl_admin and security_admin roles that role. Then deny CREATE TABLE to the role. That about does it....
"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 26, 2009 at 1:28 pm
David Burrows (5/26/2009)
...You could really mess with people's heads with this.
Well it obviously did with yours 😛
Yeah, but I'm a head case on the best days. I'm talking about...
"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 26, 2009 at 6:37 am
Good to know. Thanks for trying it 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
May 26, 2009 at 6:02 am
RBarryYoung (5/22/2009)
Grant Fritchey (5/22/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 23, 2009 at 2:13 pm
Viewing 15 posts - 17,371 through 17,385 (of 22,219 total)