Viewing 15 posts - 1,021 through 1,035 (of 5,678 total)
Initial reaction to any CXPacket problem on a global scale is that it's not the CXPacket's fault. Something is delaying one of the parallelism threads and that's the real...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 31, 2012 at 3:38 pm
charles99 (10/31/2012)
Thanks Craig. I know it was an open ended question...but I had to ask. 🙂
LOL, fair enough. There's possibly a couple of people around here who could give...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 31, 2012 at 3:07 pm
Can you expand on what you're looking for a little bit?
File storage is usually done in VARBINARY(MAX). Under most scenarios the front end should be delivering/retrieving these files, not...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 31, 2012 at 2:54 pm
Yeah, it's not horribly uncommon. An example of when I usually use it:
SUM( CASE WHEN x=y THEN 1 ELSE 0 END) AS FilteredCount
What kind of performance difference are you...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 31, 2012 at 2:51 pm
John8990 (10/23/2012)
Just curious, has anyone ever had to quit a job because they just can't keep you busy?:doze:
Quit? No. I use those downtimes to self-train, explore for new...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 31, 2012 at 1:42 pm
Got family all over NY/NJ. Still trying to reach one of them, though I know the power was going down so my guess is her cell simply perma-died. ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 31, 2012 at 1:36 pm
charles99 (10/30/2012)
Great Thanks! Clearly I am not understanding partitioning all that well then.
Don't feel bad. I've been working with it off and on for the last 2-3 years and...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 6:56 pm
No.
For starters, you want to go here:
http://msdn.microsoft.com/en-us/library/ms188783(v=sql.105).aspx
In particular:
Up to 16 columns can be combined into a single composite index key. All the columns in a composite index key must be...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 6:19 pm
ChrisM@home (10/28/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 6:14 pm
Partitioning, in general, is an administrative tool and not a development or optimization tool. While you do need to make sure your partitioning is included in optimization of existing...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 6:10 pm
I did a bit of testing on this a while ago, and could probably recreate the scenarios, but here's where I ended up.
SELECT INTO #tmp
and
CREATE TABLE #Tmp INSERT...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 6:03 pm
I was recently assaulted in a dark alley by some Ransomware, Tom, so I feel your pain. It took me a few bouts of safe mode and random timing...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 5:56 pm
Andy Leonard (10/30/2012)
Can you send me one of the offending packages? My email address is my firstname.lastname *at* gmail.
Email sent. Thanks for looking at this for me Andy.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 5:50 pm
bkatoch (10/30/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 4:13 pm
Checked the XML on the source file. First I removed the data source entirely (though two of my other configurations are relying on it) and checked the XML.
I can...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 30, 2012 at 4:00 pm
Viewing 15 posts - 1,021 through 1,035 (of 5,678 total)