Viewing 15 posts - 796 through 810 (of 2,038 total)
Hi Wayne
Glad that we could help!
Flo
May 25, 2009 at 4:53 am
Maybe it depends on my English but I find neither a apologize nor anything rude.
May 24, 2009 at 12:31 pm
Allister Reid (5/24/2009)
Have been thinking about dynamic custom data types via CLR for user defined forms, I take it you have to implement access functions for each type... maybe you...
May 24, 2009 at 12:25 pm
Allister Reid (5/24/2009)
heh-he... and i wrote the group by solution in me first post as well as the distinct 😉
:w00t:
I didn't see the group by. Really. So I have to...
May 24, 2009 at 11:36 am
Allister Reid (5/24/2009)
shouldn't have left the distinct query in the middle of my solution!
For reference it finally finished running after 23:53... indexed GROUP BY took 00:10.
The CLR route...
May 24, 2009 at 11:16 am
Jeff Moden (5/24/2009)
Florian Reischl (5/24/2009)
Jeff Moden (5/23/2009)
Florian Reischl (5/23/2009)
Maybe it's time for your 5 bugs 😀
Ok... I'll bite. What do you mean here? I blame it on failing...
May 24, 2009 at 11:10 am
Heh... After about half an hour testing I figured it out. The answer is as simple that I didn't think about.
@Allister: Thanks for the test data!
I took Allister's test data...
May 24, 2009 at 10:26 am
Jeff Moden (5/23/2009)
Most flavors of a SAN come with "snapshot" capabilites that solve these types of problems.
SAN? Since the OP wrote that the database "backup" will be send by email...
May 24, 2009 at 9:16 am
I think what you are looking for is an INTERSECT query. This "join" returns only the rows matching in all columns:
[font="Courier New"]DECLARE @t1 TABLE (Id INT, SomeInt INT)
DECLARE @t2 TABLE...
May 24, 2009 at 9:14 am
Jeff Moden (5/23/2009)
Florian Reischl (5/23/2009)
Maybe it's time for your 5 bugs 😀
Ok... I'll bite. What do you mean here? I blame it on failing memory and I'm not...
May 24, 2009 at 9:08 am
Jeff Moden (5/23/2009)
Very cool, Flo. We're getting all of the running total methods out in the open.
Yep. You know I always like to compare all solutions. Just like you.
Care...
May 24, 2009 at 9:03 am
There is no NATURAL join available in SQL Server.
May 23, 2009 at 4:30 pm
Great job Jeff!! I didn't think about a quirky update in this case. Also very clean to use an tab-lock and an index hint to ensure the order!
Maybe it's time...
May 23, 2009 at 3:11 pm
Jan Van der Eecken (5/23/2009)
...
Moral of the story? For one, stop your replication BEFORE you rename a server and don't even bother setting...
May 23, 2009 at 2:18 pm
Viewing 15 posts - 796 through 810 (of 2,038 total)