Viewing 15 posts - 1,231 through 1,245 (of 5,678 total)
Sergiy (8/28/2012)
GilaMonster (8/28/2012)
(query processor doesn't work with pages, just rows)Sure?
Ever heard of locks escalation?
*scratches his head* Out of curiousity, you realize these are other people you're talking to, not your...
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
August 28, 2012 at 3:37 pm
You need a way to identify the new records on the OLTP system so you can limit your 'pull' from that system.
Typical solutions:
1) A LateUpdateDatetime or a Timestamp which 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
August 28, 2012 at 3:16 pm
I'm with the others on this, Steve. Shadow IT is not the problem. The centralization of *all* IT is.
IT is still too heavily lumped together. Hang...
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
August 28, 2012 at 3:11 pm
ryetimothy (8/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
August 28, 2012 at 2:40 pm
I'm not entirely sure this is possible in SSRS. If it is, you'll have a few hoops to jump through to be able to keep the collapsability of the...
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
August 28, 2012 at 1:46 pm
Fell off the planet for a few days, RL stuff. The admin issue will be hard to troubleshoot over the net. As to the file disappearing, does the...
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
August 28, 2012 at 1:18 pm
I'm of the personal opinion that I work for money, my money. That's not what employers want to hear, however. So, as mentioned, there's a balance point. ...
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
August 24, 2012 at 3:21 pm
Fal (8/24/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
August 24, 2012 at 2:29 pm
saschup (8/23/2012)
Thank you! I'm both bummed and pleased you answered this so quickly. It was so easy for you and so hard for me.
I have more practice, no worries. 🙂
1)...
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
August 23, 2012 at 6:24 pm
Two things are going on here, and they're not entirely independent but a few questions.
I assume you originally built this package from your local system, but the server is 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
August 23, 2012 at 6:16 pm
Sample was nearly perfect, but didn't run out of the gates, was missing a parenthesis or two. I also modified it to be using #Temps instead of hard tables...
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
August 22, 2012 at 6:08 pm
SQL Kiwi (8/22/2012)
Evil Kraig F (8/22/2012)
I believe I have a query (or 10) to mark for modification once we get out of 2k5.
The NOT EXISTS...INTERSECT thing works in SQL Server...
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
August 22, 2012 at 6:00 pm
SQL Kiwi (8/22/2012)
There is a better, and easier way to do it using NOT EXISTS and INTERSECT. I describe the technique here: http://bit.ly/EqualityComparison
That. Is. AWESOME.
I stand humbly...
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
August 22, 2012 at 5:34 pm
Jeff Moden (8/22/2012)
I guess a question on my mind at this point is why anyone would need a 200GB TempDB.
It's unfortunately not hard to need it on an overly active...
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
August 22, 2012 at 4:25 pm
sqlfriends (8/22/2012)
If I simplize my question, any alternative to use <> to compare columns with null values?
Nope, compare them in a non-null version (using ISNULL), or build the incredibly...
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
August 22, 2012 at 3:59 pm
Viewing 15 posts - 1,231 through 1,245 (of 5,678 total)