Viewing 15 posts - 8,566 through 8,580 (of 22,224 total)
That's what a reporting tool is for. SQL Server and T-SQL are a horrible place to do that kind of formatting.
"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
March 25, 2014 at 12:00 pm
Caruncles (3/25/2014)
"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
March 25, 2014 at 8:41 am
Default values are extremely low cost. I'm not even sure if you can measure that. You pass a NULL value and something else is used instead. When you said constraints...
"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
March 25, 2014 at 7:46 am
SQLSACT (3/25/2014)
ThanksCould a literal possibly be:
select column from table where column = 'literal'.
Yep. That's 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
March 25, 2014 at 6:22 am
I'd suggest double checking the data in the column. It sounds like you may have text data mixed in with the numbers.
"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
March 25, 2014 at 5:55 am
A literal is a string or number used within the query, not a variable or a parameter, but a literal value.
Then, the plan isn't cached. Period. It's not inside or...
"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
March 25, 2014 at 5:49 am
Try running the query without the WHERE clause. You'll note that there are tons of plans right there in the cache that are larger. If there is a literal within...
"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
March 25, 2014 at 4:24 am
It completely depends on how the constraints are defined. The primary pain points, if any, will be on inserts and updates. It won't affect selects at all. The best answer...
"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
March 25, 2014 at 3:52 am
We're going to need you to come in this weekend to work on those TPS reports, mmmkay?
"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
March 24, 2014 at 4:09 pm
GilaMonster (3/24/2014)
Ed Wagner (3/24/2014)
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.
WOW! Now that's enough to scare anyone. Just think...he has access to 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
March 24, 2014 at 3:20 pm
You could put in a start up procedure that sends you an email each time the server comes online. That wouldn't tell you it was going down, but it would...
"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
March 24, 2014 at 3:18 pm
There isn't a single path to the goal. You actually sound like you're already doing a lot of what many DBAs do for their entire career, set up servers, set...
"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
March 24, 2014 at 3:14 pm
The query is the better approach.
The index is fragmented. It's just not very fragmented. 34% is fairly light. As for scripts, just search for the names that I provided. You'll...
"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
March 24, 2014 at 12:02 pm
mrupperman (3/24/2014)
Grant Fritchey (3/24/2014)
Nope. I keep getting errors in the XML when I try to open it. Did you edit the plan?
No, I just created the plan and saved 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
March 24, 2014 at 11:59 am
Nope. I keep getting errors in the XML when I try to open it. Did you edit the plan?
"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
March 24, 2014 at 11:31 am
Viewing 15 posts - 8,566 through 8,580 (of 22,224 total)