Viewing 15 posts - 1 through 15 (of 16 total)
I'm checking into the SLA. They are a SaaS vendor, but our main liason with the vendor agrees that we should be notified. Unfortunately it's a matter of changing their...
August 18, 2011 at 2:08 pm
Jack Corbett (8/17/2011)
An HDHP + HSA isn't a bad deal right now.
Great topic.
My company has been largely insulated from the overall effects of the US economy, thanks in part to...
August 17, 2011 at 10:36 am
Great question. There was a recent SSC article by Prashant Pandey[/url] that did an excellent job explaining the differences. So glad I read that!
August 17, 2011 at 9:58 am
I think easiest way can depend on personal preference. Personally I would create an SSIS package and schedule that using SQL Agent in a job.
August 12, 2011 at 10:57 am
Britt Cluff (8/12/2011)
Darn, missed this one. Couldn't remeber if it was 2008 or 2008 R2 and guessed wrong. Thanks for the question.
Ditto on this. Would love to see more SSRS...
August 12, 2011 at 10:03 am
Jason, thanks much for the help. I had tried something similar but didn't remember to remove the GROUP BY. Stupid me.
August 3, 2011 at 9:08 am
I think the experts would say "It Depends"[/url]. I found this article by The Dixie Flatline to be extremely informative.
August 1, 2011 at 4:10 pm
Nevyn (7/29/2011)
July 29, 2011 at 2:38 pm
I've always wanted to get into Doctor Who, but haven't found the time yet. My spouse and I recently caught up on Fringe, can't wait for the next season. Lately...
July 29, 2011 at 1:55 pm
Craig Farrell (6/30/2011)
The Running Totals issue in SQL is that it's really a presentation layer thing, not a SQL thing, which is why it causes such issues.
Craig, would you...
June 30, 2011 at 3:23 pm
Terry Low-350996 (6/16/2011)
"Databases only like two words....ALWAYS and NEVER"
I think I will borrow that for the future. I've had a lot of "sometimes" requests for...
June 17, 2011 at 9:37 am
Something like below?
CREATE TABLE #table1
(
name varchar(10),
dd int
)
INSERT INTO #table1
SELECT 'Rack', 2 UNION ALL
SELECT 'Rack', 4 UNION ALL
SELECT 'Rack', 1 UNION ALL
SELECT 'Rack', 33 UNION ALL
SELECT 'Rack', 44
INSERT INTO #table1
SELECT 'Jenny',...
June 10, 2011 at 12:47 pm
Pity. Well thanks for the confirmation. This just means I get to go back to the third party and push them to add proper indexes and whatnot to their DB....
June 7, 2011 at 2:44 pm
Hi ricer. Yes, I did. But because RPC is not enabled, it does not work.
Msg 7411, Level 16, State 1, Line 1
Server [linkedservername] is not configured for RPC.
Edited to remove...
June 7, 2011 at 2:34 pm
Great solution, it works well. It's taking me a bit to thoroughly understand how the join on c2.RN-1 works. At first I thought that would be an issue where no...
May 25, 2011 at 3:52 pm
Viewing 15 posts - 1 through 15 (of 16 total)