Viewing 15 posts - 14,671 through 14,685 (of 22,227 total)
brandon_ledbetter (7/13/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 13, 2010 at 9:37 am
brandon_ledbetter (7/13/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 13, 2010 at 9:11 am
thinknight (7/13/2010)
How could i know just restore succeeded?According to this code:
declare
@qStr varchar(512),
@i int
set @qStr = 'RESTORE DATABASE ...'
EXEC @i = sp_executesql @qStr
PRINT @i
Fails....
You're not using standard syntax for 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 13, 2010 at 8:12 am
You need to do three more things. First, you should also monitor the wait states and queues on the system so you know what is causing things to slow down....
"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 8:10 am
shivanee.chikhalikar (7/13/2010)
I am adding the foreign key using the following query
ALTER TABLE RepairCategoryDetail
ADD CONSTRAINT FK_RepairCategoryDetail FOREIGN KEY (CategoryId)
REFERENCES RepairCategoryMaster(CategoryId);
But it is giving me an following error
There are...
"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 6:26 am
It completely depends on what events and columns the trace is collecting. Most people are running very benign traces capturing RPC & Batch Completes with only 8-12 columns of data....
"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 6:23 am
Jason Shadonix (7/13/2010)
Now, helpful bit out of the way, I'm not going to laugh at the network engineer getting stuck with the DBA job, that happens, but I will laugh...
"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 6:16 am
phil.cooper.2 (7/12/2010)
I am a LAN/WAN/desktop network engineer. The company I presently work for seems to think that database work falls under that scope.
Go ahead- I'll wait for the jeering, laughing,...
"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 6:02 am
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
Viewing 15 posts - 14,671 through 14,685 (of 22,227 total)