Viewing 15 posts - 5,431 through 5,445 (of 22,219 total)
Rod at work (10/8/2015)
Grant Fritchey (10/8/2015)
"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
October 8, 2015 at 8:43 am
The problem as you've described it is very unlikely to be solved using queries. The only thing you could look to would be something like SOUNDEX. That will help...
"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
October 8, 2015 at 8:38 am
balasach82 (10/8/2015)
To confirm, Encryption (using master certificate) is only for protecting/securing the data, but it does not obfuscate it i.e, changing the values from AAA to BBB.
That's right. Encryption of...
"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
October 8, 2015 at 8:28 am
In general, look up the INSERT ... SELECT syntax. That's your buddy when dealing with stuff like this. Your current structure, as everyone else has already said, is broken.
"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
October 8, 2015 at 7:10 am
I would love to see the execution plan for this query.
I suspect that you're trying to add the columns by referencing the table name when you need to be using...
"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
October 8, 2015 at 7:05 am
There will be a way to do this in SQL Server 2016 (and it's already there in Azure SQL Database). Otherwise, no, it's write update statements or look to 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
October 8, 2015 at 7:01 am
While SQL Server can store XML, it's not great at it. You might want to consider looking at one of the ID/Value databases that's meant to cope with this type...
"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
October 8, 2015 at 7:00 am
I'm not crazy about that configuration. I'd rather see the CPUs available for use instead of a MAXDOP of 1. Just make sure to change the cost threshold for parallelism...
"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
October 8, 2015 at 5:01 am
They're both running this query:
(@p0 int,@p1 bigint)DELETE FROM ManifestExportRecord WHERE Id = @p0 AND VersionNumber = @p1
Deadlocks are usually multi-statement issues involving access across multiple resources, not a single...
"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
October 8, 2015 at 4:56 am
Anthony Perkins (10/7/2015)
Jeff/Grant,I wonder if you guys noticed that the question is not about SQL Server, but rather APS? If you did not would your answers be any different?
Anthony
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
October 7, 2015 at 3:55 pm
If you don't have something like Extended Events already capturing your data, then you're completely dependent on what is currently in cache accessed through the Dynamic Management Views (DMVs). The...
"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
October 7, 2015 at 3:44 pm
Absolute agreement with Chris. We'd need to see the query, the function and the execution plan to make an assessment.
If it's a multi-statement, table-valued, user-defined function, that's problematic right there.
"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
October 7, 2015 at 6:38 am
There are also a number of ways to simply call the SSIS package directly.
"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
October 7, 2015 at 6:36 am
GilaMonster (10/7/2015)
Grant Fritchey (10/7/2015)
You're already capturing deadlock information in the system_health extended event session.On 2008?
Yep.
No gui, but it works.
"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
October 7, 2015 at 6:33 am
You might have it. Check your system_health extended event session. You can use this query [/url]to take a look.
"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
October 7, 2015 at 3:18 am
Viewing 15 posts - 5,431 through 5,445 (of 22,219 total)