Viewing 15 posts - 5,536 through 5,550 (of 6,676 total)
steve dassin (3/22/2009)
--------------------------------------------------------------------------------
I'm not saying sql is flawed. I'm saying sql is flawed when it comes to application development.
I hear this from lots of people and I ask them 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
March 22, 2009 at 7:30 pm
JamesNZ (3/22/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
March 22, 2009 at 6:43 pm
In addition to what Mohit has stated, each server you have open in Object Explorer will be a connection in Activity Monitor.
You also will get a connection if you 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
March 22, 2009 at 6:22 pm
Did you change the server name?
Do you backup to a network share that is no longer available?
Can you open the maintenance plans and verify the connection and setup for each...
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
March 22, 2009 at 2:33 pm
You can provide the default connection information:
ssms -S.\InstanceName -E {filename}
But, I don't know of any way to open a file disconnected unless you use the functionality available in SSMS to...
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
March 22, 2009 at 2:21 pm
Attaching a SQL Server 2000 database to 2005 does not change tables from user to system. How are you determining that your tables are now marked as system tables?
Run...
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
March 20, 2009 at 5:21 pm
Are you aware of the fact that all of the SQL Server specific perfmon counters are already available from SQL Server?
SELECT *
FROM sys.dm_os_performance_counters;
If you need to be...
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
March 20, 2009 at 5:13 pm
Unfortunately, you are going to have to recreate the plans. BTW - do you realize that you have probably already spent more time on trying to fix these than...
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
March 18, 2009 at 7:46 pm
Okay - I have to ask, but have you restarted the server since adding the switch to the boot.ini? Have you put the server under enough load to use...
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
March 18, 2009 at 7:43 pm
dave b (3/18/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
March 18, 2009 at 5:04 pm
INSERT INTO Category (CategoryTypeID, ParentID, Description, HasRelation)
SELECT DISTINCT
1 As CategoryTypeID
,Category.GenCategoryID Ad ParentID
...
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
March 17, 2009 at 4:26 pm
It is much easier to recreate the plans, but - there is one option that I know of that may fix the problem.
Open BIDS and create a new Integration Services...
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
March 16, 2009 at 5:32 pm
Michael Valentine Jones (3/16/2009)
Are you completely reloading the table each time, or just adding new rows to existing data?
Dangit - should have thought about that question myself. 🙂
However, I...
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
March 16, 2009 at 4:12 pm
I'd say that is the best way to go, drop and recreate. The key is doing it in the correct order. When dropping the indexes, drop all 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
March 16, 2009 at 3:36 pm
Would you want the same level of performance if you had to fail over to the mirror?
How long do you expect to be running on the mirror in a failover...
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
March 16, 2009 at 2:25 pm
Viewing 15 posts - 5,536 through 5,550 (of 6,676 total)