Viewing 15 posts - 4,186 through 4,200 (of 22,219 total)
You would have to make a call to xp_cmdshell. It's going to be more than a little sloppy. Why not reverse it. Create a Powershell command that calls to 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
December 1, 2016 at 5:43 am
joeroshan (12/1/2016)
Bruce-12445 (11/30/2016)
"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
December 1, 2016 at 5:27 am
Everything Lowell says, plus check the system_health extended event session. It captures a whole bunch of behaviors, errors, etc., that aren't normally in the log. It could help identify 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
November 30, 2016 at 10:37 am
Just so you know, we're hosting SQL in the City as a streamed, live event this year. Check out my intro.
"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
November 30, 2016 at 10:35 am
John Mitchell-245523 (11/30/2016)
Grant Fritchey (11/30/2016)
I don't see any protection against SQL injection with this approach. I'd be a bit cautious about it. You don't want to meet Bobby Tables[/url].
There's no...
"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
November 30, 2016 at 7:26 am
I don't see any protection against SQL injection with this approach. I'd be a bit cautious about it. You don't want to meet Bobby Tables[/url].
"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
November 30, 2016 at 6:07 am
All the tool vendors will do this for you.
I work for Redgate software. I like our tool, SQL Monitor[/url]. It does all of what you're asking for and more. It...
"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
November 30, 2016 at 6:04 am
Both queries went to Full optimization which is good. No timeouts. You have several scans and a key lookup on [DB1].[dbo].[ASSET_ATTR]. Those are my concerns. It means that the WHERE...
"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
November 30, 2016 at 6:00 am
Ah, I didn't see the second post there, sorry. So, the correlated queries are running faster? Hmmm.... I'd want to see both execution plans to understand why.
"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
November 29, 2016 at 8:42 pm
Oh wow, it's a muck table[/url]. If you ever get a shot at redesign... this should be public enemy #1.
The first query is the preferred method. Not the second. It'll...
"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
November 29, 2016 at 8:41 pm
Sqlsavy (11/29/2016)
Is it possible to estimate database capacity based on following details?Volume of records held in the database- 18000000
Rows, not records. And who cares. 300,000,000 rows at 2k/row is 585,937.5...
"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
November 29, 2016 at 7:21 am
rodjkidd (11/29/2016)
Grant Fritchey (11/29/2016)
rodjkidd (11/29/2016)
Steve Jones - SSC Editor (11/25/2016)
Another day off for me, so I'm enjoying...
"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
November 29, 2016 at 6:26 am
joeroshan (11/29/2016)
"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
November 29, 2016 at 6:02 am
Be very cautious in what you're doing. From my reading of it, you're creating a view that does a whole series of JOIN operations (and a JOIN is the better...
"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
November 29, 2016 at 6:00 am
rodjkidd (11/29/2016)
Steve Jones - SSC Editor (11/25/2016)
Another day off for me, so I'm enjoying it after 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
November 29, 2016 at 5:46 am
Viewing 15 posts - 4,186 through 4,200 (of 22,219 total)