Forum Replies Created
Viewing 15 posts - 3,046 through 3,060 (of 22,227 total)
-
RE: Rebuilding Indexes
And therein lies a philosophical debate.
After reading a lot of what Jeff Moden has to say on fragmentation, some testing, some research, I lean heavily towards setting an...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: repetitive sql code blocks
Don't run the query twice. Run it one time. SELECT whatever FROM wherever WHERE somesetofrestrictivefilteringthatusesanindexanddoesnthavecalculationsandfunctionsonit is the right way to do something like this. Trying to determine if there is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Different behavior between "alter table drop column if exist" (new syntax) and the legacy one "if exists() alter table drop column " : is this a bug?
Think of the IF EXISTS command like the WHERE clause in a query. Yes, your WHERE clause may eliminate all the data in a table/index, but the table/index was still...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Checking my knowledge
If it's some type of SAN, work with the admins there to get more space on the drives as Chris already suggested. Otherwise, yeah, you'll need to move some stuff...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Prevent duplicates in a table
RonKyle - Tuesday, August 21, 2018 7:31 AMGrant Fritchey - Tuesday, August 21, 2018 7:25 AMRE: Prevent duplicates in a table
RonKyle - Tuesday, August 21, 2018 7:08 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Prevent duplicates in a table
RonKyle - Monday, August 20, 2018 2:21 PMThe separation still sucks.
If someone wants uniqueness..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Partitioning An Existing Table With A Columnstore Index ?
Jeff Moden - Wednesday, August 15, 2018 8:44 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Deleted
chocthree - Tuesday, August 14, 2018 6:56 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: How much RAM required to server
Piling on.
Focus on gathering metrics right now. What are your wait statistics like? Is the server waiting on memory? Which queries are waiting? What is making those...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Partitioning An Existing Table With A Columnstore Index ?
Are you partitioning in order to take advantage of the data management aspects of partitioning (rolling windows, that sort of thing) or are you attempting to partition for performance. If...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: SQL Server 2016 - Catching Up Since SQL Server 2008R2
I don't know of a video along the lines of what you're looking for. However, I can make one huge recommendation. Learn Query Store. It's your best friend in the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Restoring over an offline database
coolchaitu - Monday, August 13, 2018 8:43 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: index join and index intersection
I have examples in my book.
It's actually hard to get these things. You won't see them very often, The optimizer almost seems to have a bias against...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Question: performance loss on update statistics after upgrade from SQL Server 2012
Resender - Wednesday, August 8, 2018 7:23 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningViewing 15 posts - 3,046 through 3,060 (of 22,227 total)
If someone wants uniqueness...