Forum Replies Created
Viewing 15 posts - 3,031 through 3,045 (of 22,219 total)
-
RE: Index Usage Statistics report
Another possibility is to query the plan cache to see which indexes are in execution plans there. That approach is dependent on the plan being in cache though.
"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: Index Usage Statistics report
First, on 2016, don't use profiler, use extended events. They are much more light weight than profiler and safer for your system.
I don't know of a way to...
"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
Jeff Moden - Wednesday, August 22, 2018 12:21 PM"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: 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?
Nkl - Wednesday, August 22, 2018 12:05 PM"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: Checking my knowledge
john_laspada - Wednesday, August 22, 2018 10:48 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: Checking my knowledge
john_laspada - Wednesday, August 22, 2018 9:12 AMGrant Fritchey - Wednesday, August 22, 2018 8:36 AMRE: Checking my knowledge
You can simply add files to existing file groups and you can specify storage of an object to a file. However, management is a lot easier through filegroups, so yeah,...
"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: 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 TuningRE: 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 TuningRE: 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 TuningRE: 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 TuningRE: 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 TuningViewing 15 posts - 3,031 through 3,045 (of 22,219 total)
If someone wants uniqueness...