Viewing 15 posts - 1,756 through 1,770 (of 22,224 total)
Hi,
A table contains approximately 6 billion rows. Now, if I ran a command like 'select count(*) from table;' to get the actual count. Will it slow down my system?...
"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
June 23, 2020 at 1:22 pm
Just to reinforce what @mr.briangale has already said, there is no magic number of indexes. If the indexes are being used and their maintenance is not causing you pain, whatever...
"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
June 23, 2020 at 1:16 pm
Regarding "the big party". I assume you all mean the Thursday party that for many years was a fixture of Summit?
That event was always hosted by Microsoft. It was never...
"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
June 23, 2020 at 11:31 am
Just so people know, we have contracts with convention centers and hotels. These contracts get negotiated starting 3-5 years away from the event. This is in order to keep 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
June 23, 2020 at 11:20 am
It could be that there's a proc that you need to execute. Maybe a table that logs the login. It's hard to know. You could monitor using Extended Events 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
June 19, 2020 at 9:17 pm
Sadly, at the moment, all I can say is the details are coming. I want them out yesterday. However, it looks like sometime next week.
"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
June 19, 2020 at 3:51 pm
In order to run a 330,000 member organization that does all the stuff we do, we have to have a management company. About 12 years ago we were with one...
"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
June 19, 2020 at 3:18 pm
Hey all!
In all likelihood, this will get me kicked from the board, however, I'd like to share something about my passion for this community and why PASS as an organization...
"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
June 19, 2020 at 11:20 am
The sponsors simply don't provide enough money to both put on Summit and keep the lights on the rest of the year.
Frankly, some people are going to get their wish....
"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
June 19, 2020 at 11:00 am
PAM!
Thanks for stopping by. That sure looks right to me.
"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
June 19, 2020 at 10:12 am
By the way, I wrote this about a week ago.
"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
June 18, 2020 at 7:19 pm
Hey everyone,
At this point, no comments. I just wanted to check in and let you know that I'm here and I'm watching and taking it all in.
Thanks for all 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
June 18, 2020 at 6:51 pm
Yeah, probably.
"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
June 18, 2020 at 3:48 pm
I've reached out to one of the Microsoft dev leads. I'll see what I can find. I pointed them back here. Hopefully someone will swing by.
"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
June 18, 2020 at 3:47 pm
You can combine the data. There are going to be differences. Each tool measures slightly different things in slightly different ways. You will see near parity on them though. I...
"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
June 18, 2020 at 3:44 pm
Viewing 15 posts - 1,756 through 1,770 (of 22,224 total)