Viewing 15 posts - 5,701 through 5,715 (of 22,226 total)
Luis Cazares (8/13/2015)
GilaMonster (8/13/2015)
Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.
That reminds me of a job posting I recently received on the mail....
"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 11:38 am
SimonH (8/13/2015)
The Data Factory, looks like somewhere to start, looks interesting an were going...
"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 11:36 am
Capture the plan when it's gone bad and when it's good. Look at the Properties for the first operator. You'll see the compile time values used. That should let you...
"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 11:35 am
SQLRNNR (8/13/2015)
Grant Fritchey (8/13/2015)
caojunhe24 (8/12/2015)
#temp is much more useful than @tempReally? What about in the case of recompiles?
Or a user-defined table type?
Better yet...
A user defined memory optimized table type?
What about...
"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 11:33 am
If they don't have an SLA that prevents, then I'm all for going into the single database for stuff that belongs in that database for all the reasons you list.
I...
"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 11:31 am
Sean Lange (8/13/2015)
Grant Fritchey (8/13/2015)
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...
"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:44 am
Luis Cazares (8/13/2015)
Eirikur Eiriksson (8/13/2015)
Grant Fritchey (8/13/2015)
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...
"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:43 am
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
Viewing 15 posts - 5,701 through 5,715 (of 22,226 total)