Forum Replies Created
Viewing 15 posts - 3,046 through 3,060 (of 22,224 total)
-
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 TuningRE: Separate DB, log and Temp drives ?
mark 52160 - Wednesday, August 8, 2018 7:16 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: MS16-136 Update & recommended patch order for SQL Server 2014 SP2 onwards?
The Cumulative Updates are cumulative. So you only need to install the SP2 and the latest CU.
"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: DB Autogrowth
tmmutsetse - Wednesday, August 8, 2018 2:24 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,224 total)
If someone wants uniqueness...