Viewing 15 posts - 14,671 through 14,685 (of 22,219 total)
ibzmiller (7/13/2010)
Yes plenty of testing ahead. No I don't think there are any clustered indexes. It has just been a matter of, theres a table. No consideration on how...
"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
July 13, 2010 at 5:50 am
Novicejatt (7/12/2010)
I do not want to use SSIS yet. I'm only working with SQL queries. Say I have a table with fixed no. of columns. I want to schedule a...
"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
July 13, 2010 at 5:26 am
Novicejatt (7/12/2010)
Since the file name and the columns changes everytime, So it will only run for one time. So how do I load multiple files each...
"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
July 12, 2010 at 12:30 pm
Yep, not a problem. SQL Agent is the built in scheduling tool for SQL Server. Create a job there, you can create one or more schedules for the job 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
July 12, 2010 at 12:03 pm
ANSI_NULL and the rest are connection settings. If you want procedure properties you can look at the system view, sys.procedures.
"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
July 12, 2010 at 11:30 am
Microsoft frequently will give you limited time access to a server online for training purposes. Go here and check 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
July 12, 2010 at 11:27 am
GilaMonster (7/12/2010)
If the query is blocked, you could kill the blocking connection, but something still has to die.
Yeah, I was going to say, killl all the other connections so 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
July 12, 2010 at 11:26 am
shayy (7/12/2010)
column, then an index on that column can help.
Thanks a lot for...
"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
July 12, 2010 at 7:15 am
Another consideration, adding PK's means you're adding an index, clustered or nonclustered, to a table where none previously existed. That will affect performance, probably positively, but possibly negatively.
You have tons...
"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
July 12, 2010 at 7:11 am
Mike01 (7/12/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
July 12, 2010 at 7:08 am
That's a final approach to logical deletes. I'd just keep an eye on performance because, presumably, you're filtering on that bit, which won't index well, so you could see some...
"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
July 12, 2010 at 7:07 am
You're way off in your use of @@RowCount. Every time something is referenced or updated, you're going to get a change in @@RowCount. If you want to use it, 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
July 12, 2010 at 7:04 am
shayy (7/12/2010)
1. As i mentioned, i only have one query (maybe 2) which takes the data ordered by ProjectName
2. about using the WHERE, what...
"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
July 12, 2010 at 6:56 am
If you're building a custom string every time you execute, that's why you're seeing thousands of execution plans. You simply can't do that. Very, very small changes to the text...
"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
July 12, 2010 at 6:47 am
KeyurGohel (7/12/2010)
table: EmpMst
id empcod empname Sdate ...
"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
July 12, 2010 at 6:43 am
Viewing 15 posts - 14,671 through 14,685 (of 22,219 total)