Viewing 15 posts - 6,616 through 6,630 (of 6,676 total)
I wouldn't bother with a trigger, or some function in a trigger. This can easily be handled using an indexed view and a unique clustered index on the indexed...
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 11, 2008 at 11:52 am
How are you connecting to this other system? Are you trying to use Windows Authentication? If so, then that will use the SQL Agent account to try 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
May 11, 2008 at 11:15 am
No - you need to install litespeed on the other server. If this is a one time process, you can install litespeed in demo mode to perform the restore.
If...
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 10, 2008 at 8:49 pm
Just curious - but how often are you running transaction log backups? If you are only running once a day (to shrink), then consider changing the system from full...
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, 2008 at 5:11 pm
Try running: sp_change_users_login 'Report' in the database where you are trying to add the user. If you find any users in the list, you need to run this procedure...
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, 2008 at 9:34 pm
Maybe by giving you an example for two SAN's I work with:
HP EVA 5000
Disk Group 1 has 104 72GB/15K drives
Disk Group 2 has 24 300GB/10K drives
When I need a LUN...
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 7, 2008 at 2:36 pm
Jeff Moden (5/4/2008)
jeff.williams3188 (5/4/2008)
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, 2008 at 9:48 pm
It is never a good idea to shrink either the database or the transaction log on a production system. You manage the size of the transaction log by running...
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 4, 2008 at 3:08 pm
Here is an idea that might work for you. Take a look at Powershell and SMO. With Powershell, you can easily create a script to loop through a...
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 4, 2008 at 10:44 am
Jeff Moden (5/4/2008)
peace2007 (5/3/2008)
Did you go buy the number of processors and create a files for each i.e if have 4 processors do you have 4 files for tempdb ..just...
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 4, 2008 at 10:14 am
Another thing to keep in mind is that on SQL Server 2005, sp_updatestats has been modified to only update statistics on tables that need it. If you use 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 1, 2008 at 8:59 pm
Lubo Petrov (4/27/2008)
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
April 27, 2008 at 4:51 pm
To restore to a point in time, you have to restore all transaction log backups from the backup you are restoring from to the point in time you are restoring...
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
April 27, 2008 at 11:56 am
Some clarification:
Are you using SQL Agent Job or SSMS Maintenenance Plan? It sounds like you are using both - so, correct me if I am wrong here.
I am guessing...
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
April 26, 2008 at 8:45 pm
Are you running Enterprise Edition? If not, locking pages in memory won't do anything either - since Standard Edition cannot use it.
For your problem, what is the minimum memory...
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
April 26, 2008 at 8:24 pm
Viewing 15 posts - 6,616 through 6,630 (of 6,676 total)