Viewing 15 posts - 5,491 through 5,505 (of 22,219 total)
Kristen-173977 (9/29/2015)
tshad (9/28/2015)
in the same order as in the query.
Order is not important. I would recommend that you change the call to your SProc from:
EXEC R01OrderForm @Region, @District, ...
to
EXEC...
"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 29, 2015 at 4:32 am
Also capture the data from sys.dm_os_wait_stats before and after the period of slowness to understand what the server is waiting on.
"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 29, 2015 at 4:29 am
If you're really spending time and effort learning SQL Server and you intend on making this a profession, the $50 to purchase the Developer Edition is worth every penny.
"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 29, 2015 at 4:27 am
jasona.work (9/25/2015)
Grant Fritchey (9/25/2015)
jasona.work (9/25/2015)
Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow...
"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 25, 2015 at 6:42 am
jasona.work (9/25/2015)
Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer?...
"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 25, 2015 at 6:26 am
SQL_Kills (9/24/2015)
So my current script i have cannot be amended to work pon what I have on there now?
Pretty much.
"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 24, 2015 at 8:50 pm
Tac11 (9/24/2015)
@Grant. I had posted my questions, I am not looking for Powershell script.
Powershell isn't run from the command line?
OK.
"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 24, 2015 at 8:49 pm
Shortest possible answer:
Yes.
"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 24, 2015 at 11:44 am
This:
Set @CntNow= ('Select COUNT(*) From ') +@Path
You're attempting to set the @CntNow value, which is defined as an integer in your variable declaration, to a string value. If you're attempting...
"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 24, 2015 at 11:43 am
squvi.87 (9/24/2015)
Im have a situation to insert data from multiple sources to a single table.
ie., multiple and concurrent insert on same table
will it lead to dead lock at...
"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 24, 2015 at 11:38 am
Tac11 (9/24/2015)
Wow. Just asked simple questions, no answer but too much noise!!!!
Not sure what you're looking for? The link I posted shows how to call stored procedures from the command...
"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 24, 2015 at 9:40 am
Hibernate, nHibernate, Entity Framework and Lynq are just a few of the Object Relational Mapping tools you're going to see more of. They actually can work very well for most...
"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 24, 2015 at 7:23 am
You can simply use the SQL Server command object from Powershell to make these calls. It's easy. Here are some examples.
"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 24, 2015 at 7:14 am
Captain Scarlet has it nailed. Each differential backup is going to take longer and longer because they are cumulative since the last full backup. I'm not sure I'd bother taking...
"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 24, 2015 at 7:09 am
The positive impact when you already have SSDs is probably going to be less, but it will still be there. Primarily because we're talking not about accessing your database files,...
"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 24, 2015 at 7:05 am
Viewing 15 posts - 5,491 through 5,505 (of 22,219 total)