Viewing 15 posts - 766 through 780 (of 5,685 total)
In this case Sean, since he's looking more for tuning help than code help, I'd request something a bit different.
As mentioned, we want to see the DDL for the source...
March 21, 2013 at 2:44 pm
majorbloodnock (3/19/2013)
First of all, Craig, thanks very much for the compliment; I do my best.
My pleasure, I assure you.
Regarding your question, I'm embarrassed to say I'm not entirely clear what...
March 19, 2013 at 5:22 am
Gary Varga (3/19/2013)
March 19, 2013 at 5:00 am
bitbucket-25253 (3/18/2013)
My one hundreth QOD has been accepted for publication on 20 Mar -21 Mar 2013
Rock on, my man. Rock on.
March 19, 2013 at 4:27 am
majorbloodnock (3/19/2013)Utterly agree. The more experience I gain (for that, read "the older I get" 😉 ) the more I see the technologies I work with purely as tools, and...
March 19, 2013 at 4:24 am
Lynn Pettis (3/18/2013)
Jeff Moden (3/18/2013)
Evil Kraig F (3/18/2013)
Alright, let's start with the basics. You said you've read up...
March 19, 2013 at 4:11 am
All security in SQL Server is cumulative unless an explicity DENY in one group overrides a setting from another. That includes both internal (SQL) and external (AD) group associations....
March 18, 2013 at 6:52 pm
LSAdvantage (3/18/2013)
Thank you for the very detailed explanation Craig! That is exactly what I need. That pivot query was very, VERY helpful.
If it makes you feel any better,...
March 18, 2013 at 5:49 pm
Ahhh, bitvector (bitmask, bitwise operators, combined flags, flagfield, etc...), my old friend.
Alright, let's start with the basics. You said you've read up on it but some of your difficulty...
March 18, 2013 at 4:45 pm
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
Hi, My name is Lynn and...
March 18, 2013 at 2:32 pm
Unfortunately, I agree with Lowell here. When you start trying to bombproof (I like that term) Excel importations, you're looking at VBA code which will open its own connection...
March 18, 2013 at 2:23 pm
Phil Parkin (3/14/2013)
...unless you're using 2012, in which case the result set definition moves to the Execute SQL task.
Haven't gotten my hands on 2012 yet, but does that include OLEDB...
March 15, 2013 at 1:33 pm
Phil Factor (3/14/2013)
March 15, 2013 at 1:29 pm
Phil, in some ways I agree with you. If a VERY small company doesn't have the infrastructure to support their business model, and they don't have the throughput that...
March 13, 2013 at 1:05 pm
Viewing 15 posts - 766 through 780 (of 5,685 total)