Viewing 15 posts - 6,361 through 6,375 (of 6,676 total)
No, sorry - those options will not get you real time (or even near real time). The closest you are going to get to real-time is transactional replication.
I have...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 14, 2008 at 3:25 pm
Glad I could help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 14, 2008 at 3:22 pm
Yeah, see that now - missed it the first time.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2008 at 6:28 pm
Ken Simmons (7/13/2008)
Select Buyer_ID,Order_ID
FROM (
select order_id, buyer_id,
RANK() OVER (partition BY buyer_id Order by order_id)...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2008 at 6:00 pm
rbarryyoung (7/13/2008)
Whenever you get this message, immediately...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2008 at 5:51 pm
levsha_z (7/13/2008)
INSERT INTO BUYERS VALUES (1, 32, 8)
INSERT INTO BUYERS VALUES (1, 31, 2)
INSERT INTO BUYERS VALUES (1, 12, 3)
INSERT INTO...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2008 at 5:25 pm
Please read the following article:
Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you follow the above, someone here will be able to help you solve your problem - probably very quickly.
Off the top of my...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2008 at 12:28 pm
obarahmeh (7/13/2008)
Thanks for all ur replies.
I found out the error cause, it is not an error in the query. I suddenly found some values in the column DayTransTime (Decimal(6,0))...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2008 at 12:00 pm
Without further information, this is just a WAG on my part. I would guess that you have setup parameters in your report and one or more of your parameters...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 12, 2008 at 10:57 am
Steve Jones - Editor (7/11/2008)
How current do the reports need to be? Database mirroring and snapshots (if you have enterprise) can help here. Or replication to a second server.
Since this...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 11, 2008 at 12:48 pm
Well, I don't envy you this task - it is not going to be easy. Any way you can convince the user that the old database should be moved...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2008 at 8:03 pm
The first thing you need to be able to do is identify the data to be appended. But, what about existing data that has been changed in database1? ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2008 at 2:21 pm
slava davidchuk (7/10/2008)
Resource Group ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2008 at 1:43 pm
Are you running out of space for the data file? Or, is your log file growing too large?
We have seen a lot of posts recently about the transaction log...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2008 at 5:26 pm
If you can't get it to work with the changes GSquared has outlined, I would rethink this approach. Based upon what you have shown to this point, it appears...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2008 at 2:48 pm
Viewing 15 posts - 6,361 through 6,375 (of 6,676 total)