Viewing 15 posts - 14,371 through 14,385 (of 22,219 total)
WayneS (9/7/2010)
Steve Jones - Editor (9/7/2010)
WayneS (9/7/2010)
Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.
Actually I picture Lutz as Wayne'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
September 8, 2010 at 6:27 am
Tom.Thomson (9/7/2010)
Grant Fritchey (9/7/2010)
"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
September 7, 2010 at 10:17 am
ranjith.Ileni (9/7/2010)
select ename,sal AS maxsal,deptid
from employees
where sal in(select max(sala)
...
"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
September 7, 2010 at 7:00 am
You can use ALTER INDEX for a nonclustered index to disable it. If you do this for a clustered index, it makes the data inaccessible.
ALTER INDEX myIndexName ON myTable DISABLE
"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
September 7, 2010 at 6:27 am
Homework? Please show what you've tried and is not working.
Key words you might want to check out are GROUP BY and MAX.
"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
September 7, 2010 at 6:24 am
Place your stored procedures, indeed, your entire database, into source control. Subversion is a great opensource product. Microsoft's Team Foundation Server (TFS) is fantastic as well. There are a number...
"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
September 7, 2010 at 5:42 am
I agree with Tom, but I'll go a little further, I wouldn't call it "bad", but I would do whatever I could to avoid that kind of circular reference. 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
September 7, 2010 at 5:27 am
Just to emphasize, except for circumstances where the system is under extreme load, you should be able to run database and log backups without interfering with the users. Even in...
"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
September 7, 2010 at 5:20 am
dustin.mueller (9/3/2010)
"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
September 3, 2010 at 1:32 pm
Then it sounds messed up. I suspect you may have some poor performance in some areas because of 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
September 3, 2010 at 1:20 pm
Oooh, rereading it that came across a little bad.
I meant pointless for the people trying to save space.
Not the test. The test was great!
"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
September 3, 2010 at 1:18 pm
george sibbald (9/3/2010)
this is the output from msdb..backupset. a full backup was taken followed by 3 tranlog backups. Nothing changed between the full...
"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
September 3, 2010 at 1:17 pm
Sorry, I've been in meetings all day.
Steve already nailed it. Thanks Steve.
"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
September 3, 2010 at 1:12 pm
Thanks.
"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
September 3, 2010 at 7:48 am
I'm confused. You mean he only used views in queries inside of stored procedures? It sounds like you're saying he created views using stored procedures, which is weird.
In general, I'd...
"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
September 3, 2010 at 7:45 am
Viewing 15 posts - 14,371 through 14,385 (of 22,219 total)