Viewing 15 posts - 901 through 915 (of 962 total)
Nice question.
Can to the conclusion it wouldn't with with offset, then it was a case of old datetime types vs new or all?
I guessed wrong. But one to put in...
July 3, 2012 at 2:49 am
Sean,
I'm so glad I wasn't drinking when I just read your reply - Lynndrome, definantly a SOM moment!
Just had to restore a DB from this mornings backup. Been waiting since...
June 22, 2012 at 8:42 am
Wow finally caught up with the Thread.
Lost my way a few months ago, moved didn't have full internet, etc... Was going to try and say something witty about all that...
June 22, 2012 at 3:03 am
Yes unfortunantly I am also waiting on more details.
Hopefully more on Monday!
June 15, 2012 at 6:19 am
Thanks Gail,
I either forgot that filestream and Mirroing don't mix, or it's never come up.
So it's VARBINARY(MAX)
and mirroring then?
I think a test environment is required here.
Cheers,
Rodders...
June 15, 2012 at 5:39 am
Some more info...
8 million rows per year.
40kb per BLOB on average.
Makes me think mirroring is a good option?
June 15, 2012 at 5:05 am
Well I'm currently looking so I'm very much in touch with the market at the moment!
Before I started looking I maybe checked every three 3 months or so. But didn't...
July 21, 2011 at 7:49 am
Jeff, the late congrats for Lynn was, indeed, for the news of becoming a grand parent!
There was talk of a new job, but I hadn't caught up with that yet,...
July 20, 2011 at 3:38 am
Another vote from me!
Congrats Jeff - I know it's been said before but I've certainly learn a lot from you over the years so many thanks.
As well as learning from...
July 19, 2011 at 11:14 am
The number of times I fall for the UNION for UNION ALL in questions...
Must remember to have had caffine before answering QOD!
July 11, 2011 at 5:45 am
Good question Lynn.
Just a pity even after one cup of coffee it was still to early for me to see the bit about Tuesday's full backup being corrupt.
Cheers,
Rodders...
April 30, 2010 at 1:45 am
Hi ackrite55,
I think I have sorted it out.
You can't do this with the same recordset variable
Set Rank = Rank.NextRecordset
What you have to do is this:
Dim Rank2 As ADODB.Recordset
Set Rank2 =...
February 2, 2010 at 2:19 am
Hi ackrite55,
I haven't done this for a while, but there is a nextrecordset option in ADO.
So you shoul dbe able to do somthing like:
Dim Nextrs as ADODB.Recordset
SET Nextrs = rs.NextRecordset
And...
February 1, 2010 at 7:38 am
Roy Ernest (6/16/2009)
Roy, have you been keeping up with it? Or is 20-20 not your thing?
I have been keeping up with it. Seems like Sri Lanka and South Africa are...
June 16, 2009 at 9:59 am
tosscrosby (6/16/2009)
Kit G (6/16/2009)
Cubs? I don't follow football... or it is baseball? :hehe:
Sometimes we're not sure! 😛
I'm not either that's why I'm following the Twenty20 World Cup in Cricket!
Roy,...
June 16, 2009 at 8:22 am
Viewing 15 posts - 901 through 915 (of 962 total)