Viewing 15 posts - 5,491 through 5,505 (of 22,226 total)
Huh. Cool. Always learning. That's the first time I've seen that.
"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:47 pm
I'm not aware of any way to do this. If you're attempting to insert data that violates a primary key, it's a very serious error.
"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 12:28 pm
There is no way. There is no requirement that you enter any kind of license when you install SQL Server.
"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 12:26 pm
Just know that forced parameterization is only going to be of limited use in getting plans to be reused. You're likely going to have to go to fully parameterized queries...
"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 11:41 am
I'd start yanking that developer's access to anything and everything I could keep them out of. Then, when they go to management, you go in with a set of documented...
"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 11:38 am
EasyBoy (9/29/2015)
My apology.Yes, it is duplicate post by mistake. Somehow, i am not able to delete that post. This issue persisting on SQL Server 2000.
This is a SQL Server 2008...
"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 10:14 am
For queries, execution time and the number of reads. I do use extended events for this all the time now. I've found that STATISTICS IO tends to mask changes 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 29, 2015 at 4:36 am
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
Viewing 15 posts - 5,491 through 5,505 (of 22,226 total)