Forum Replies Created
Viewing 15 posts - 3,196 through 3,210 (of 22,219 total)
-
RE: SQL Server Profiler 2017 - How to stop "save as" once it has started
Not a clue how to address your specific issue, but, one HUGE point.
The GUI for Profiler has a different memory management mechanism within SQL Server than the server-side...
"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: Are the posted questions getting worse?
Steve Jones - SSC Editor - Thursday, April 26, 2018 8:57 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 Tuning -
RE: Last Execute Procedure
You can only get that information if you are gathering query metrics in some fashion. Since you're posting in a 2008 forum, the general method for this is to use...
"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: designing portal so we don't run into performance issues.
When thinking about performance of the database, two things should drive your processes. First, you only get one clustered index and it defines data storage. Therefore, the most common path...
"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: Normalization
Lynn Pettis - Wednesday, April 25, 2018 2:17 PM[/quote]
I...
"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: Synonyms and performance
willspurgeon - Tuesday, April 24, 2018 1:25 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 Tuning -
RE: Find dialog box too small
Here's the fix I used. Seems to work well.
Partly joking of course. Partly.
"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: Normalization
Lynn Pettis - Tuesday, April 24, 2018 9:02 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 Tuning -
RE: Normalization
Lynn Pettis - Monday, April 23, 2018 8:11 PMScottPletcher - Monday, April 23, 2018 4:34 PMRE: Transactional Replication has poor Plan
dwilliscp - Monday, April 23, 2018 8:02 AM
For some reason we are getting a real poor plan on our...
"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: Suggestions for managing multi-tenant SQL Azure database (esp.restore)
Personally, I think I'd look to split the customers by database rather than try to put them all in one. You've hit the real issue that's going to be brutally...
"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: Refreshing lower environments with prod copy
Without using log shipping or replication or availability groups (all of which you've dismissed), I don't know of any way you can easily move only the data that has changed...
"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: Desperation on the Forums
Steve Jones - SSC Editor - Wednesday, April 18, 2018 9:42 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: Are the posted questions getting worse?
Lynn Pettis - Tuesday, April 17, 2018 10:26 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: Azure Automation
kishoremania - Tuesday, April 17, 2018 5:09 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 TuningViewing 15 posts - 3,196 through 3,210 (of 22,219 total)
