Viewing 15 posts - 5,686 through 5,700 (of 22,211 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....
August 13, 2015 at 11:38 am
SimonH (8/13/2015)
The Data Factory, looks like somewhere to start, looks interesting an were going...
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...
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...
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...
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...
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...
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....
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...
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?
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...
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...
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 =...
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...
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...
August 13, 2015 at 5:45 am
Viewing 15 posts - 5,686 through 5,700 (of 22,211 total)