Viewing 15 posts - 3,841 through 3,855 (of 6,676 total)
How are the SSIS packages configured to run? Are they setup to use windows authentication?
If so, does the network account have a separate login to SQL Server with 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
May 9, 2010 at 9:39 pm
I answered this over on SQL Team also, so check back there for that response. Basically, your trigger is going to fail for multiple rows on this:
IF (SELECT Age...
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
May 9, 2010 at 1:53 pm
What account is running SQL Server?
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
May 9, 2010 at 11:11 am
Perry Whittle (5/8/2010)
specifically, ensure you run DBCC UPDATEUSAGE against the database.
And, you also want to make sure you run DBCC CHECKDB {database} WITH DATA_PURITY and get a clean result. ...
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
May 8, 2010 at 11:38 am
One you can use an update statement to update the data, the other you can't. 😉
If you need additional information, please specify exactly what issue you are having and...
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
May 8, 2010 at 11:34 am
Yes, you are right in assuming that views don't have cached plans. The queries that use the views will have a cached plan - but not the view itself.
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
May 6, 2010 at 10:00 pm
Probably neither - since the view will be expanded into the calling query there wouldn't be any difference in the actual execution plan.
I would create a view if the logic...
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
May 6, 2010 at 9:52 pm
craig-404139 (5/6/2010)
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
May 6, 2010 at 9:45 pm
Yes - the utilities in SQL Server to remove backup files will only remove actual SQL Server created files. You could try setting up the job to remove text...
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
May 6, 2010 at 2:11 pm
Grant Fritchey (5/5/2010)
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
May 5, 2010 at 7:35 pm
What is the full error message? It is not showing up in the title.
I suspect, based upon a quick google search that your problem is because you don't 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
May 5, 2010 at 7:26 pm
I've got to say that with that much memory and cpu's, with only a 28-30GB database, if you are still having performance issues then your problems are either IO related...
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
May 5, 2010 at 6:38 pm
Lynn Pettis (5/5/2010)
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
May 5, 2010 at 3:01 pm
You are correct in your thinking - if you lose the SAN completely, you'll lose the transaction log backups which would be required to restore to a point in time.
Copying...
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
May 5, 2010 at 2:59 pm
GilaMonster (5/5/2010)
Jason P. Burnett (5/4/2010)
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
May 5, 2010 at 2:54 pm
Viewing 15 posts - 3,841 through 3,855 (of 6,676 total)