Viewing 15 posts - 5,656 through 5,670 (of 6,676 total)
Well, I am not familiar with DTS and only have limited knowledge and capability with SSIS. I still think using SQL Server Express is your best option and 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
January 26, 2009 at 4:14 pm
You really should be looking at using SQL Server Express and replication. That would be the better option all around and would be my recommendation.
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
January 26, 2009 at 4:00 pm
All of the other posts have directed you to a dynamic pivot\cross-tab solution. I would like to point out that most (if not all) reporting tools available will not...
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
January 26, 2009 at 3:50 pm
You have to install new instances. A new instance is a completely separate set of binaries and database files on that host. You cannot install a new instance...
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
January 26, 2009 at 3:26 pm
kevinsql7 (1/26/2009)
I would like to know if this query (I guess it is a distributed query) would affect performance on ServerA (Prod)?
Yes - this is going to have an affect...
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
January 26, 2009 at 3:06 pm
Please include the number of pages for each index\table. If these are small tables they will never be defragmented fully.
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
January 26, 2009 at 2:57 pm
You can't modify the calendar control, so - you modify the parameter in the SQL statement. The general formula is to zero out the time portion of the date...
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
January 22, 2009 at 5:24 pm
It would really help if you would read the article I link to in my signature. It will help you format your question so we can help you better.
The...
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
January 22, 2009 at 2:02 pm
FWIW - the second option would be the better option if it works. However, it will not work the way it has been presented here.
SELECT [BlockMaterialsID],BM.[MaterialsId],BMC.[BlockMaterialCategoriesId]
FROM [dbo].[BlockMaterials] AS BM
INNER...
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
January 21, 2009 at 2:17 pm
Dennis D. Allen (1/21/2009)
Yes that does work and is a fine workaround.
I want to understand why this does not work as it should work correctly and the...
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
January 21, 2009 at 2:06 pm
You probably cannot shrink the log because the active portion of the log file is near the end. You need to setup and run frequent transaction log backups (every...
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
January 21, 2009 at 10:46 am
ChrisMoix (1/20/2009)
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
January 20, 2009 at 5:15 pm
ryp (1/20/2009)
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
January 20, 2009 at 1:47 pm
Based upon what you have stated, then you need to have the Product table joined three times.
I don't think your problems with the query are due to the multiple joins....
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
January 20, 2009 at 1:42 pm
That is exactly the reason why we perform full backups, differentials and transaction log backups. The more frequent the transaction log backups - the less data loss.
You could always...
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
January 20, 2009 at 1:27 pm
Viewing 15 posts - 5,656 through 5,670 (of 6,676 total)