Viewing 15 posts - 14,371 through 14,385 (of 22,224 total)
Alvin Ramard (9/9/2010)
Jeff Moden (9/9/2010)
Alvin Ramard (9/9/2010)
Trey Staker (9/9/2010)
Steve Jones - Editor (9/9/2010)
You can sign up and...
"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 10, 2010 at 5:42 am
The best way to do this would be to have two queries, one that just selects everything, without a WHERE clause, and one that selects based on the WHERE clause....
"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 9, 2010 at 7:56 am
GilaMonster (9/8/2010)
Now here's an interesting question...Which is going to reach 20 000 posts first, me or the Thread?
Looking at the counts.... I'd put my money on you pulling away.
"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 8:17 am
For detailed answers, please do as Gail requested.
For a quick answer, I'd look at this:
and so_ref not like '% VS'
That will lead to serious slow performance since the only...
"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 7:04 am
Not knowing exactly what you need, this might be off, but what about loading the update into a MySql instance and then using SSIS to migrate the data?
If it's structures...
"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 7:00 am
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
Viewing 15 posts - 14,371 through 14,385 (of 22,224 total)