Viewing 15 posts - 46 through 60 (of 67 total)
Thanks 😀
The Fastest Methods aren't always the Quickest Methods
July 18, 2011 at 4:50 am
Thanks 😀
The Fastest Methods aren't always the Quickest Methods
July 15, 2011 at 5:45 am
thanks, does the master key have to be the same on the other server?. Didn't see the link :-).
awesome got an example of this 2 work 😀
The Fastest Methods aren't always the Quickest Methods
July 14, 2011 at 7:18 am
ok 🙂
if I need the back up from the database to work on another server, do I just need the certificate and private key that the certificate was backed up...
The Fastest Methods aren't always the Quickest Methods
July 14, 2011 at 4:43 am
Thanks 🙂
The Fastest Methods aren't always the Quickest Methods
July 13, 2011 at 5:04 am
will do 😀
The Fastest Methods aren't always the Quickest Methods
July 11, 2011 at 9:17 am
old data is archeived every night to make sure this row count doesn't go much higher than that 🙂
The Fastest Methods aren't always the Quickest Methods
July 11, 2011 at 6:22 am
ok, thank you. The lots of data we have 🙂 there's over 5 mil rows, just need to make sure we use diff parameters each time
The Fastest Methods aren't always the Quickest Methods
July 11, 2011 at 6:14 am
The code in the stored procedure is
SELECT ISNULL(Vessels.Name, 'unknown') AS Name, AISPositionsCurrent.MMSI, AISPositionsCurrent.Position, ISNULL(VesselGroups.Description, 'Unknown')
...
The Fastest Methods aren't always the Quickest Methods
July 11, 2011 at 6:05 am
thanks guys 😀
The Fastest Methods aren't always the Quickest Methods
July 11, 2011 at 5:49 am
I understand that no filter will be applied what I'm trying to find out is if the first part of and is true would the second part still run?
I have...
The Fastest Methods aren't always the Quickest Methods
July 11, 2011 at 5:28 am
thank you 🙂
The Fastest Methods aren't always the Quickest Methods
May 19, 2011 at 8:07 am
reading through that link now 🙂
The Fastest Methods aren't always the Quickest Methods
May 19, 2011 at 8:01 am
will that give me the exact row or just the latest DateStamp? sorry I'm not the best at explaining things. Would the below work well?
SELECT GroupID,Name, Position
FROM MyTable
WHERE...
The Fastest Methods aren't always the Quickest Methods
May 19, 2011 at 7:58 am
by latest row I mean that it will look at the DateStamp and get only the row with the newest DateStamp for each group
The Fastest Methods aren't always the Quickest Methods
May 19, 2011 at 7:48 am
Viewing 15 posts - 46 through 60 (of 67 total)