Forum Replies Created
Viewing 15 posts - 3,931 through 3,945 (of 22,224 total)
-
RE: Upgrade SQL 2008 R2 Express to SQL 2014 Standard..How?
Do you want both versions of the software running on the system? If so, install 2014 and provide a named instance (which is generally considered a good practice...
"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 SQL 2008 R2 Express to SQL 2014 Standard..How?
I'm not completely sure I understand the set up or the question.
If you're asking how to upgrade your databases from 2008 to 2014, the best approach is to...
"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: Recomended Hyper-V Memory Settings
SQL Server within the VM is going to claim all the memory it can (as usual) and it won't release any. So it's not a surprise that you get 90%...
"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: Need to update Price based on partial comparison of one column vs another ?
Add another column to your table that strips the leading zero and the trailing digit and use that for comparisons. That way you can index it and get decent performance....
"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?
SQLRNNR - Tuesday, April 4, 2017 11:38 AMSo, in other news and because somebody is too quiet on the topic.This happened:
"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: Management Studio freezing after writing a few lines of code
richardmgreen1 - Tuesday, April 4, 2017 8:59 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: Management Studio freezing after writing a few lines of code
By size in this case, I should have been more clear, how many objects?
If it's freezing on other databases, it's possibly Apex (don't intend to throw rocks here).
"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: Management Studio freezing after writing a few lines of code
How big is the database?
I don't know Apex, but I know Redgate SQL Prompt. We sometimes have trouble when the database is very large. Same thing...
"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?
ThomasRushton - Tuesday, April 4, 2017 3:32 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: Does backupset table also include third party tool backups?
John Mitchell-245523 - Tuesday, April 4, 2017 3:31 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: Some questions related to the Interview
I haven't had to interview for quite a while, but prior to showing up for an interview at Company X, I'd go by their web site. What do they 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 TuningRE: Does backupset table also include third party tool backups?
Speaking as a 3rd party backup tool vendor, ours sure does.
Most of the 3rd party backup tools are, to one degree or another, using native backups. So yes,...
"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: High Usage of tempdb
Differences in the server settings? Differences on database settings? Differences on query plans being generated? It's so hard to say for certain without a lot more knowledge that it's absolutely...
"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: Query on locks taken in a Deadlock
Gavin Whittaker - Monday, April 3, 2017 2:52 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: High Usage of tempdb
You allocated 800mb for tempdb, but you left the growth on. How much space is on the drive? It's going to attempt to grow to fill the space needed to...
"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,931 through 3,945 (of 22,224 total)