Viewing 15 posts - 1,576 through 1,590 (of 1,988 total)
I'm a firm believer in the Scotty Principle of giving estimates. Or as I explained it to someone I used to work with, if something will take an hour,...
September 1, 2015 at 8:43 am
Just out of curiosity, it seems like a lot of people are putting a lot of faith in foreign key constraints I'm wondering why? Compared to a primary key...
August 31, 2015 at 8:07 pm
Are you looking for something more like this in the where clause?
WHERE
(@LoanNumber IS NOT NULL AND C.loannumber = @LoanNumber) OR
(@LoanNumber IS NULL AND @DealershipName IS NOT NULL AND CH.NameLong LIKE...
August 31, 2015 at 3:06 pm
whereisSQL? (8/31/2015)
DonlSimpson (8/31/2015)
Ed Wagner (8/31/2015)
Luis Cazares (8/31/2015)
whereisSQL? (8/31/2015)
djj (8/31/2015)
Ed Wagner (8/28/2015)
whereisSQL? (8/28/2015)
Luis Cazares (8/28/2015)
Ed Wagner (8/28/2015)
DonlSimpson (8/28/2015)
SQLRNNR (8/28/2015)
'tater saladRon White
White Potatoes
black beans
Burrito
Steak
Cow
Milk
Chocolate
Roast
Toast
Tea
Crumpets
August 31, 2015 at 2:54 pm
Steve Jones - SSC Editor (8/31/2015)
Ed Wagner (8/31/2015)
SQLRNNR (8/31/2015)
Luis Cazares (8/31/2015)
Brandie Tarvin (8/31/2015)
I am planning to upgrade at least one of my machines. Haven't decided if it'll be the 8.1...
August 31, 2015 at 2:07 pm
Hmm.... primary keys(or at least unique constraints) are very important as duplicates are a pretty big issue and if they're derived from natural keys are a very good way to...
August 31, 2015 at 7:52 am
xsevensinzx (8/29/2015)
Ed Wagner (8/28/2015)
August 29, 2015 at 8:39 am
Hmm... from the what was described it sounds like the end users already have access to reporting features through their application but aren't super happy with it. Without knowing...
August 28, 2015 at 10:03 am
Jeff Moden (8/27/2015)
August 28, 2015 at 7:50 am
whereisSQL? (8/27/2015)
Ed Wagner (8/27/2015)
whereisSQL? (8/27/2015)
Ed Wagner (8/27/2015)
Revenant (8/27/2015)
Ed Wagner (8/27/2015)
whereisSQL? (8/27/2015)
Ed Wagner (8/27/2015)
ZZartin (8/27/2015)
djj (8/27/2015)
Ed Wagner (8/26/2015)
Luis Cazares (8/26/2015)
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
Food
Hunger
Hamburger
Cheeseburger
Fries
Onion Rings
Tower
Babel
Hebrew
Greek
Yogurt
Frozen
August 27, 2015 at 1:42 pm
djj (8/27/2015)
Ed Wagner (8/26/2015)
Luis Cazares (8/26/2015)
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
Food
Hunger
Hamburger
August 27, 2015 at 8:59 am
Well the point of an SCD is to see data that is not what is currently available 🙂
But if you really need those populated instantly and available in the same...
August 27, 2015 at 8:11 am
Of course end users want everything available instantly 🙂
Unfortunately that kind of defeats the purpose of an SCD if it becomes an audit log, for example say someone goes into...
August 26, 2015 at 12:47 pm
schleep (8/26/2015)
Although to be honest, I can't really see how they differ... tables have valid-from and...
August 26, 2015 at 9:53 am
Viewing 15 posts - 1,576 through 1,590 (of 1,988 total)