Viewing 15 posts - 2,641 through 2,655 (of 22,224 total)
Kubernetes!
There, now we all have to drink.
"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 12, 2019 at 1:27 pm
I can't see a name associated with this, so I really can't judge whether the content is likely to be good or not. My opinion, it's a gamble, but it's...
"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 12, 2019 at 1:26 pm
So, I'm not a design purist. If I were, I'd argue that ONLY the natural keys should ever be used. However, there are very valid performance and design reasons 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
April 12, 2019 at 1:19 pm
Let's start with the easy question first, output parameters. I've only used these in actual business work when I had the, very rare, circumstance that I was only returning 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 12, 2019 at 1:14 pm
Thom has nailed the core answer. I just want to add one suggestion for tooling. Get a copy of Azure Data Studio and try it out as well since...
"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 12, 2019 at 1:05 pm
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
Viewing 15 posts - 2,641 through 2,655 (of 22,224 total)