Viewing 15 posts - 5,701 through 5,715 (of 22,219 total)
You also can increase or decrease the service level on demand. There's geo-duplication, all kinds of stuff. Azure SQL Database is very much a viable option for lots of databases....
"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
August 13, 2015 at 9:41 am
Generally what's going to happen is that a recompile event will occur after the stats are updated. You won't see a recompile occur during the statistics update and use 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
August 13, 2015 at 9:38 am
WayneS (8/13/2015)
Crystal Ball, report to Aisle 5
I'm sure that a large part of this is English as a second language. But lordy, can the questions be worded more vaguely?
"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
August 13, 2015 at 9:21 am
Lynn Pettis (8/13/2015)
Ed Wagner (8/13/2015)
I've worked in both environments and really prefer case-insensitive. As a habit, though, I try to write everything as case-sensitive.
Having been working in case sensitive...
"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
August 13, 2015 at 9:19 am
I'm sorry. I'm still not understanding. Now you're saying that you need to automate access to the databases. First you said you needed to automate sending the data. I'd like...
"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
August 13, 2015 at 8:38 am
The INSERT statements look pretty benign. As for the rest of it, you're doing a lot of duplicate processing. For example:
IF EXISTS(SELECT * FROM global.tblInsurers WHERE InsurerName= @Insurer)
BEGIN
SET @InsurerId =...
"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
August 13, 2015 at 5:54 am
I also lean towards putting it into a single database. The one question I have there is will you be violating a license agreement. Some vendors get quite put-out if...
"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
August 13, 2015 at 5:48 am
You need to provide a little more detail. It sounds like you said that you want to send a copy of all the data on all the servers to all...
"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
August 13, 2015 at 5:45 am
It's also possible that in addition to the client not keeping up, the client is asking for too much data. In addition to looking to the client coding, 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
August 13, 2015 at 5:41 am
Hello,
Disclosure: I work for Redgate
Thanks for the kind words.
We have a web site that has a ton of articles on how to automate your deployments using our tools. The samples...
"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
August 13, 2015 at 5:39 am
caojunhe24 (8/12/2015)
#temp is much more useful than @temp
Really? What about in the case of recompiles?
"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
August 13, 2015 at 5:13 am
Here's an example of a Powershell script that will do this. You should probably still plan on exporting to a file first and then import from that file for 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
August 12, 2015 at 11:05 am
mlorek (8/12/2015)
"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
August 12, 2015 at 10:58 am
Hard to say. I've driven my career by interest and opportunity. What am I interested in and what do I have the opportunities to do. So far, that's by and...
"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
August 12, 2015 at 9:37 am
Brandie Tarvin (8/12/2015)
YAY! The forums are back!I was worried they'd be down all day.
Me too. I sent an email to RG support. Maybe someone did something.
"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
August 12, 2015 at 5:53 am
Viewing 15 posts - 5,701 through 5,715 (of 22,219 total)