Viewing 15 posts - 4,126 through 4,140 (of 22,219 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 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
Probably the easiest way is to set up a scheduled check for the existence of the file. If it's there, fire off the load process. If it's not there, wait...
"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:45 am
Everything everyone else has already said, plus, to help troubleshoot, you can look at sys.dm_os_wait_stats before and after running the restore to understand where the slow downs are occurring. You...
"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:42 am
I'm going to try to work up a blog post on this over the next couple of days. If I get it done I'll come back here & post a...
"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 4, 2017 at 3:40 pm
It is. I don't have an example handy.
"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 4, 2017 at 11:48 am
Since you're on SQL Server 2012, instead of using Profiler, I'd strongly recommend you use Extended Events. They have a much more lightweight footprint than Trace Events (you wouldn't want...
"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 4, 2017 at 11:15 am
Viewing 15 posts - 4,126 through 4,140 (of 22,219 total)