Viewing 15 posts - 3,961 through 3,975 (of 5,678 total)
niall.baird (2/17/2011)
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
Public Sub Main()
Dim app As Application = New Application()
...
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
February 17, 2011 at 2:34 pm
Jole84 (2/17/2011)
Craig Farrell (2/17/2011)
Weeks work by weeknumber based off the calendar days, it's not a straight 14 day count. Instead of wk, -2, try using dd, -14.
Yes, I try...
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
February 17, 2011 at 2:28 pm
tacy.highland (2/17/2011)
(what/where does #MyTable come from?)
Look back at Greg's post, it's a temp table that's built previous to this process.
Anyone else out there have any ideas of how to solve...
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
February 17, 2011 at 2:25 pm
striker-baba (2/17/2011)
I am using a sql login to execute this package.
When I run this package,...
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
February 17, 2011 at 2:20 pm
GSquared (2/17/2011)
LutzM (2/17/2011)
GSquared (2/17/2011)
...Yes, at camelsexchange.com. :w00t:
Must be a pain for the camel. (They still use bricks for it, right?) :pinch::crying:
Sledgehammers. Or dynamite if you're in a hurry.
Isn't 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
February 17, 2011 at 2:16 pm
Jole84 (2/17/2011)
select * from #cdata where cDate >= DATEADD( hour, -1, getdate())
...
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
February 17, 2011 at 1:55 pm
ehlinger (2/17/2011)
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
February 17, 2011 at 1:54 pm
thepotplants (2/17/2011)
Wow, that is fantastic.Thank you very much Craig.
My pleasure.
Understood... This is for a one off (until next time 😉 ) analysis exercise, in a safe environment. Performance...
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
February 17, 2011 at 1:27 pm
GSquared (2/17/2011)
Alvin Ramard (2/17/2011)
They exchange camels too??Yes, at camelsexchange.com. :w00t:
Daddy, why's that boy camel wearing pink? Don't worry, son, he's just confused. There's a website for that.
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
February 17, 2011 at 12:41 pm
ehlinger (2/17/2011)
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
February 17, 2011 at 12:37 pm
GSquared (2/17/2011)
CirquedeSQLeil (2/17/2011)
Stefan Krzywicki (2/17/2011)
Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify 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
February 17, 2011 at 11:52 am
Another method of doing delta checks, which I've been investigating recently, is a computed checksum() by primary key check to determine delta, and then doing a comparison between the target...
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
February 17, 2011 at 11:43 am
Brandie Tarvin (2/17/2011)
The table already uses CoverageKey and Effective (both ASC) as it's clustered index. Include only works...
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
February 17, 2011 at 11:35 am
GilaMonster (2/17/2011)
Craig Farrell (2/17/2011)
Isn't the RID and the "uniquifier" pretty much equivalent from an overhead standpoint, being a 4 byte identifier?
No. To start with, the RID's not 4 bytes.
The RID...
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
February 17, 2011 at 11:28 am
GilaMonster (2/17/2011)
Wildcat (2/17/2011)
(if the clustered index is not unique, it must have the RID attached for the uniqueness).
Nope. The only time the RID is used in a nonclustered index...
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
February 17, 2011 at 11:04 am
Viewing 15 posts - 3,961 through 3,975 (of 5,678 total)