Viewing 15 posts - 5,476 through 5,490 (of 22,219 total)
The install ought to be pretty straight forward. The hard part is getting the configuration right. Make sure you change a few defaults. For example, Set a Max Memory to...
"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
October 2, 2015 at 4:25 am
I would have expected to see something in the text column yes. But, maybe because it errored out there was an issue with what was stored in cache.
"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
October 2, 2015 at 4:21 am
Don't forget about all the "Stairways" series of articles listing over on the left of this screen.
"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
October 2, 2015 at 4:18 am
WayneS (10/1/2015)
Grant Fritchey (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
However, Maple Whiskey... YUM! Specifically though, when you use...
"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
October 1, 2015 at 8:38 am
In addition to the above, find out what the Recovery Time Objective and Recovery Point Objective is for each of the databases in production. I would also find out if...
"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
October 1, 2015 at 7:54 am
I'm not aware of any way to do this through DMVs. A number of other options present themselves, but all are going to be a lot more work than just...
"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
October 1, 2015 at 7:50 am
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
However, Maple Whiskey... YUM! Specifically though, when you use it in 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
October 1, 2015 at 6:08 am
You can try doing plan forcing through plan guides. But it's also subject to the issues around white space and value changes within the code. As long as the code...
"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 30, 2015 at 3:21 am
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
Viewing 15 posts - 5,476 through 5,490 (of 22,219 total)