Viewing 15 posts - 4,126 through 4,140 (of 22,224 total)
"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
January 13, 2017 at 8:04 am
Just modify the capture script to include a filter for the database. You can modify it in that fashion.
"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
January 13, 2017 at 7:45 am
Be sure that you have measurements of the I/O and execution time of the query from before adding that index. You don't want to tune just on whether or not...
"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
January 13, 2017 at 7:43 am
However, this conversion isn't preventing the use of statistics or the index. Fix it? Sure. But it's not causing you performance headaches.
"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
January 12, 2017 at 9:59 am
"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
January 12, 2017 at 6:37 am
"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
January 12, 2017 at 6:28 am
Brandie Tarvin (1/11/2017)
"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
January 11, 2017 at 6:27 am
Brandie Tarvin (1/11/2017)
BLOB EATER (1/11/2017)
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)you have my vote!
So someone tell me who those "Steve Jones" and "Grant Fritchey" characters...
"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
January 11, 2017 at 6:15 am
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)
DITTO!
(nudge, nudge, wink, wink).
"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
January 11, 2017 at 6:13 am
dave-L (1/5/2017)
I have a active, highly relational, OLTP database
combined with
There are almost no foreign-key constraints defined in the dB
Effectively means that your database is not relational.
but I do not...
"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
January 6, 2017 at 6:20 am
Ah, cool. I wouldn't even have thought to check 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
January 5, 2017 at 5:41 pm
They are certainly not making things easy. The "generic" approach is to use SQL Agent. I have never tried doing this without using Agent or a third party software.
If...
"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
January 5, 2017 at 4:14 pm
May be a recent change 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
January 5, 2017 at 4:02 pm
I also tested this in Azure SQL Database. It's showing two different values as well.
However, I checked in my version of 2016 SP1, and it also showed two different values.
"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
January 5, 2017 at 5:22 am
Not an SSIS expert by any means, but...
I assume you have a delimiter between the fields that translates to columns? If so, you should be able to map those out...
"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
January 5, 2017 at 5:15 am
Viewing 15 posts - 4,126 through 4,140 (of 22,224 total)