Viewing 15 posts - 1 through 15 (of 15 total)
you could also do something like WHERE left(TableA.city,2) = TableB.city and TableA.city = 'Boston'
July 18, 2013 at 11:43 am
George,
I was finally able to get to my computer. Thank You for your help in this matter.
July 18, 2013 at 6:04 am
hey texting and driving is bad I didn't notice it was just me and you
July 17, 2013 at 4:12 pm
I am pretty sure I know the source except I have provided a status sp and their code is supposed to loop until the status changes...oh well...time for a meeting...
July 17, 2013 at 3:16 pm
hmm. by checking the log_shipping_monitor_error_detail I see an entry at 1AM that says:
Exclusive access could not be obtained because the database is in use. RESTORE LOG is terminating...
July 17, 2013 at 2:23 pm
Log backup has not been taken outside of the LS log dumps so my logs should be ok to go.
I am in a new position and at this point...
July 17, 2013 at 2:13 pm
oh well. I'll run a differential and apply it tonight to avoid loading so many logs at once. (this is an active 2TB database)
July 17, 2013 at 1:36 pm
still trying to figure this out why the logs would just not process all the files. Curiously the SQL Error Log has a gap between 1:08AM and 9:50AM
07/17/2013 09:50:54,spid594,Unknown,Zeroing completed...
July 17, 2013 at 12:24 pm
Last copied file: \\ServerB\logship\DatabaseA_20130717160001.trn
Last copied date: 2013-07-17 13:00:18.150
July 17, 2013 at 11:29 am
You're right and thank you. I checked and it seems that the last restored log file name was this morning at 1AM. The process started at midnight as it was...
July 17, 2013 at 11:27 am
... maybe I need to run update statistics on the source server's table ? I'm puzzled.
July 17, 2013 at 10:58 am
ok. so if they do repeat I really need to know how many times they repeat and somehow dynamically construct the statement? Otherwise it looks like hardcoding the number of...
September 28, 2012 at 9:55 am
great help. I really appreciate it.
What if the GPSFixes section does repeat? Will the query come automatically in two rows with the redundant information duplicated?
(;-) I think I...
September 28, 2012 at 9:43 am
one more question please. How do I get the value from the speed entries?
<Speed Type="Avg" Units="MPH">9</Speed>
<Speed Type="Inst" Units="MPH">16</Speed>
<Speed Type="Max" Units="MPH">16</Speed>
September 28, 2012 at 9:22 am
awesome. thanks for the tip on the convert(stripping of the header) and thank you for a great
example of the select statement.
September 28, 2012 at 9:07 am
Viewing 15 posts - 1 through 15 (of 15 total)