Viewing 15 posts - 5,581 through 5,595 (of 22,219 total)
Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"
Nope. Just faked out the entire MSDN web site to pull 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
September 3, 2015 at 11:22 am
SQLRNNR (9/3/2015)
Lynn Pettis (9/3/2015)
Isn't it interesting how people think some things are bugs instead of not doing things right?Well not doing it right is a bug!!
If it doesn't do what...
"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 3, 2015 at 11:21 am
Yes. Click on the link. It's a dynamic management view (DMV) for tracking referenced objects from another object. It does at least part of what you need. The only issue...
"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 3, 2015 at 11:18 am
Not really. Certain parts of the language seem like a pain until you see all the possibilities for their use.
Let's take schemas. Most people, most of the time, use dbo...
"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 3, 2015 at 11:15 am
AAAAARRRRGGGHHHH!
The STUPID! It burns.
No, no links. Just needed to scream in agony for a moment. Go about your lives.
"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 3, 2015 at 10:41 am
Nope. If you change them to be owned by you, you have to give different sets of permissions to all the users. They won't even necessarily see them. Further, good...
"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 3, 2015 at 10:37 am
If what you're looking at says that SQL Server is consuming 24gb, that's what it's consuming, not 24 + 100. You're missing the point.
Also, while there is some OS memory...
"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 3, 2015 at 10:32 am
ZZartin (9/3/2015)
"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 3, 2015 at 10:29 am
jasona.work (9/3/2015)
Just make sure you read "The Thread" from beginning to end...There will be a quiz.
:hehe:
No. Don't do 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 3, 2015 at 10:25 am
bwhiteside (9/3/2015)
"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 3, 2015 at 10:24 am
Eric M Russell (9/3/2015)
bwhiteside (9/3/2015)
"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 3, 2015 at 10:23 am
SQL!$@w$0ME (9/3/2015)
Thanks Raj. File stream is not enabled. Also there are no ssis packages or other applications installed.
You're saying that the SQL Server executable is using more memory than you...
"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 3, 2015 at 7:00 am
RonKyle (9/3/2015)
Not to sound harsh, but have you ever done any real, complex database development work? It certainly sounds like you haven't.
I have done real, complex database development, both 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 3, 2015 at 6:59 am
There currently is no good way to handle this within SQL Server. Copy & paste is how most people do it. Now, you can make this work better, especially 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
September 3, 2015 at 6:56 am
Another vote for using Jeff's tally table method. It's going to work so much better.
"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 3, 2015 at 6:54 am
Viewing 15 posts - 5,581 through 5,595 (of 22,219 total)