Forum Replies Created
Viewing 15 posts - 3,196 through 3,210 (of 22,224 total)
-
RE: New to SQL Administration
The missing indexes are, at best, suggestions. Be very cautious in simply implementing them.
As to the connections, step through it as granular as possible. What login do...
"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: SQL 2016 Optimization ...
More than one drive and more than one drive controller would be better. SQL Server is IO intensive.
"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: Upgrade linked server from 2008 R2 to 2016 SQL server - compatibility issue
Part of the upgrade process should be testing. You should be moving the database or databases in question in a non-production environment where you can validate whether or not your...
"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?
Sean Lange - Friday, April 27, 2018 7:38 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: Convert varchar to datetime
And change the data types so that you're storing date and time as date and time. Same thing goes for any other data type.
"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: 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 TuningViewing 15 posts - 3,196 through 3,210 (of 22,224 total)
