Viewing 15 posts - 841 through 855 (of 879 total)
Ed Wagner (10/23/2015)
djj (10/23/2015)
whereisSQL? (10/23/2015)
Ed Wagner (10/23/2015)
DonlSimpson (10/23/2015)
djj (10/23/2015)
Ed Wagner (10/23/2015)
happygeek (10/23/2015)
whereisSQL? (10/23/2015)
Ed Wagner (10/23/2015)
djj (10/23/2015)
Eirikur Eiriksson (10/23/2015)
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
djj (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/22/2015)
MathSchool
Study
Invest
Risk
Assessment
Process
Inflation
Tire
Wear
Tear
RIP
Tombstone
Limestone
Marble
Granite
Counter-top
Kitchen
Cooking
Spices
October 23, 2015 at 1:27 pm
GilaMonster is right, look at recovery mode and whether it has changed, lack of Tlog backup restricts your options.
October 23, 2015 at 10:01 am
whereisSQL? (10/23/2015)
Ed Wagner (10/23/2015)
djj (10/23/2015)
Eirikur Eiriksson (10/23/2015)
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
djj (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/22/2015)
MathSchool
Study
Invest
Risk
Assessment
Process
Inflation
Tire
Wear
Tear
RIP
October 23, 2015 at 9:47 am
As a thought you could have explained why use Count_Big rather than just Count and included a link.
But there again you could have used Count, and included another option; an...
October 22, 2015 at 11:38 am
Good question, had to pause for thought and do a bit of math!
October 21, 2015 at 11:03 pm
DonlSimpson (10/21/2015)
crookj (10/21/2015)
Ed Wagner (10/21/2015)
djj (10/21/2015)
Ed Wagner (10/21/2015)
crookj (10/21/2015)
Ed Wagner (10/21/2015)
BL0B_EATER (10/21/2015)
happygeek (10/20/2015)
PhoneLine
Wire
Tap
Keg
Jug
Head
Honcho
Jefe
Sherrif
October 21, 2015 at 1:23 pm
Iwas Bornready (10/21/2015)
We actually use CROSS APPLY quite a bit for retrieving addresses.
That is a good call for getting all client contact details, hadn't thought of that one actually so...
October 21, 2015 at 11:51 am
Very, very, good question, had to think about that for a while! Keep these challenges coming.
October 21, 2015 at 7:02 am
TSM could be the issue if it is running the backup at the same time as your scheduled job as part of a disk backup, although I never found it...
October 20, 2015 at 11:25 pm
It is unclear what you are trying to do, your seem to be trying to drop local temporary tables, why not simply close the session?
Looks like homework to me!
October 20, 2015 at 1:57 pm
I have done this in the past using a temporary table to create the required dataset for the dynamic mail list and then used either HTML mail or DbMail to...
October 20, 2015 at 1:44 pm
Cheers for that, it seems I can still do math!!! 🙂
October 20, 2015 at 1:36 pm
Thanks GilaMonster, will do. Do you think Steve or someone would rename it BarRoom or add it to a forum called BarRoom, wonderful idea, somewhere to thrash things out 🙂
October 18, 2015 at 8:06 am
Viewing 15 posts - 841 through 855 (of 879 total)