Viewing 15 posts - 2,641 through 2,655 (of 22,219 total)
How about people that just implement missing index recommendations that create a nonclustered index that is a covering index and recreates the entire table? Yes, I found one in...
"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
April 11, 2019 at 11:31 am
BINGO!! I would guess over 90% of the people who come to this site are not on a mobile device. So why do we cater to such 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
April 10, 2019 at 4:09 pm
And this thread just keeps on keeping on... This is a pure rant, so read at your own risk. I have been involved in the interview process for 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
April 10, 2019 at 3:42 pm
One of my experiences, though, is it does seem the SQL Server community is much friendlier than the Oracle community. Not to say there aren't helpful people out 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
April 10, 2019 at 1:16 pm
It's been a while, but I'm pretty sure that NOLOCK was only a table hint in 2005, not a query hint. That means you can't use it in plan guide...
"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
April 10, 2019 at 1:12 pm
It is "safe". However, sometimes, I have had issues uninstalling older versions. 99% of the time, it'll just uninstall and you'll be good. Go for it. Just... if you hit...
"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
April 10, 2019 at 1:07 pm
I am not an RDS expert. However, according to their documentation and a web search, you can. Use this command and change the database name:
exec msdb.dbo.rds_restore_database...
"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
April 10, 2019 at 1:04 pm
I just installed the SQL Server 2019 Developer Edition on my personal laptop. It shows that ssdt version 16 is present within the visual studio Suite but I cannot...
"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
April 10, 2019 at 12:56 pm
A view is just a query, not a table (except in the case of indexed views, but you can't add data to them directly). No data is stored in...
"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
April 10, 2019 at 12:53 pm
First page that comes up in a search for "sql server backup" is this one. It includes this quote:
If you restore an older version database to SQL Server 2017,...
"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
April 10, 2019 at 12:49 pm
I'd rephrase that question, "Is SQL Server the best RDBMS for the job at hand?"
The fact is, SQL Server is faster than Oracle and supports larger databases... depending on how...
"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
April 9, 2019 at 12:08 pm
Please don't post the same question in multiple forums. It leads to all sorts of confusion. I've answered your question over here. I'd suggest we focus all the conversation...
"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
April 9, 2019 at 11:59 am
No, don't change the storage to have multiple values. That will cause a million and one problems. You're talking about just a display issue in the results. That is best...
"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
April 9, 2019 at 11:56 am
Steve Jones - SSC Editor wrote:Well, with the new leaderboard (https://www.sqlservercentral.com/contributors), we have our first millionaire.
Yay. Um, so what are those points redeemable for again? 🙂
Everlasting Glory!
"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
April 8, 2019 at 4:35 pm
Grant, well said... Having worked with cloud and SQL DBA work, I found learning Powershell is a must. Anyone deals with cloud and managing different flavors 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
April 5, 2019 at 10:29 am
Viewing 15 posts - 2,641 through 2,655 (of 22,219 total)