Viewing 15 posts - 4,246 through 4,260 (of 22,224 total)
Beatrix Kiddo (11/9/2016)
There is absolutely nothing when working on an SQL Server that requires RDP to the server
Not quite true- if you work in a bank or other high security...
"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
November 9, 2016 at 10:30 am
To a degree this is just piling on, but this is an important question.
You are much better off not using SSMS on the server for a number of reasons. Most...
"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
November 9, 2016 at 9:57 am
I agree with Eirikur (I type that a lot).
You can easily script this install. It's quite small. My one addition to what has already been said is that you should...
"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
November 9, 2016 at 9:01 am
xsevensinzx (11/8/2016)
"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
November 8, 2016 at 6:24 am
Query hints? NOLOCK?
"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
November 7, 2016 at 6:30 pm
Whoa!
I'm with Gail. That brings up a WHOLE different discussion. First, you need all the information she has brought up.
For loading an Azure SQL Data Warehouse, currently, the...
"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
November 7, 2016 at 3:28 pm
I've been using DreamHost for several years now. It's been a very solid experience.
"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
November 7, 2016 at 2:24 pm
Chad Crawford (11/7/2016)
"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
November 7, 2016 at 1:58 pm
I agree with Eirikur. Just a restore will get the job done. If you need it near real time, I'd suggest looking at Availability Groups.
"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
November 7, 2016 at 6:28 am
I'm at the MVP Summit, so my responses are going to be slow & short for the rest of the week.
Sounds like real improvements have been made. Exploring the new...
"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
November 7, 2016 at 6:22 am
Oh cross database? I didn't even notice that. Sorry. That's what happens when you don't drill down and pay careful attention. Yeah, no cross-database foreign keys.
You might, might, see 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
November 6, 2016 at 10:04 am
Get in touch if you have questions. Hopefully the book is helpful.
I do think you're looking at the variable causing average values instead of specific ones to get a less...
"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
November 6, 2016 at 3:14 am
Are the DatabaseID columns enforced as foreign key constraints, or are they just indexes? Since they are being used as foreign keys, you want to ensure that they are enforced....
"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
November 5, 2016 at 4:45 pm
That's a gigantically open-ended question. To answer it faithfully you have to know if we're changing the data as well as moving it. Are there transformations to the structure or...
"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
November 5, 2016 at 4:40 am
There isn't a perfect way to get this done. I'd suggest looking at SQLCop[/url]. It does a decent, but not great, job at this. I don't know of a tool...
"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
November 5, 2016 at 4:36 am
Viewing 15 posts - 4,246 through 4,260 (of 22,224 total)