Viewing 15 posts - 3,961 through 3,975 (of 5,685 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()
...
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...
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...
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,...
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...
February 17, 2011 at 2:16 pm
Jole84 (2/17/2011)
select * from #cdata where cDate >= DATEADD( hour, -1, getdate())
...
February 17, 2011 at 1:55 pm
ehlinger (2/17/2011)
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...
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.
February 17, 2011 at 12:41 pm
ehlinger (2/17/2011)
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...
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...
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...
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...
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...
February 17, 2011 at 11:04 am
Viewing 15 posts - 3,961 through 3,975 (of 5,685 total)