Viewing 15 posts - 2,341 through 2,355 (of 22,219 total)
What the heck is a FULLZ? Are dead FULLZ better than live FULLZ? Inquiring minds.
"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 27, 2019 at 1:47 pm
Even if we do a virtual SQLSaturday, I'm positive the local events would continue. While a lot of people want to have big events with a host of international speakers,...
"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 27, 2019 at 1:44 pm
PASS hosts a whole bunch of different virtual events year round, 24 Hours of PASS and the PASS Marathons. Plus there are the virtual chapters that meet...
"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 27, 2019 at 1:40 pm
Hopefully today was better. That last one is one of my big fears, loosing my keys, along with loosing phone or wallet. Had something similar happen to a friend...
"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 26, 2019 at 8:17 pm
Don't forget about statistics. The reason to do an index rebuild is, in theory, to reduce fragmentation. However, as a side benefit, you get rebuilt statistics. It's entirely possible 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 26, 2019 at 12:28 pm
All it takes is one person within your company who is authorized, let's say to see the credit card data, but not the PII of individuals, accidentally, not even 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 25, 2019 at 1:47 pm
I don't have an answer to your question, but please let me point out another issue.
You're getting ready to hop the 2014 Cardinality Estimation Engine upgrade gap. The new CE...
"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, 2019 at 1:41 pm
SSMS is a separate install, too.
YAY!!!
"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, 2019 at 1:35 pm
Do you have a limit on the number of processors in use on the server? You really should, but if it's set to 0, then SQL Server is making 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
September 25, 2019 at 1:34 pm
I think there's a Stairway series on them here on SSC.
"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, 2019 at 5:11 pm
Fill factor determines the amount of free space in a page. Generally, this alone, isn't determining query performance. You may be seeing additional I/O because you have a very low...
"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, 2019 at 10:29 am
Replication is a viable for this situation. However, I shy away from replication very hard because it has received zero love from Microsoft for well over a decade. It's 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
September 24, 2019 at 10:25 am
Determining the cost threshold can be hard. However, I have a blog post that uses your own queries as a mechanism for making that choice. Suffice to say, 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
September 24, 2019 at 10:20 am
Grant: "The other is the need to filter after the XML is put together."
Do you mean that it materializes the ENTIRE resultset into one giant XML construct, and then...
"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 13, 2019 at 12:19 pm
Fingers crossed, this adds a little light and no more heat...
From a strictly performance oriented approach, I'm 100% with Gail. Integers are better. Period. Therefore, when performance really counts, 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
September 13, 2019 at 12:17 pm
Viewing 15 posts - 2,341 through 2,355 (of 22,219 total)