Viewing 15 posts - 2,671 through 2,685 (of 6,676 total)
You also have to specify the full path and name of the file.
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 2, 2014 at 2:38 pm
How often are you updating statistics?
How often are you rebuilding your indexes?
Have you reviewed the 'slow' queries to see if they can be improved?
Just a few thoughts...
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
December 31, 2013 at 2:19 pm
You should not set min and max memory to the same value - that can cause additional problems, as in the instance not being able to start at all.
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
December 30, 2013 at 3:34 pm
There is a way to 'script' maintenance plans - but it takes a bit of effort.
Step1: build your maintenance plans
Step2: Import the maintenance plans to an SSIS package
Step3: Modify 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
December 26, 2013 at 1:05 pm
This error: Exclusive access could not be obtained because the database is in use.
Tells you that those services had open connections to the database being restored. When performing 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
December 24, 2013 at 12:05 pm
If you don't specify one of the options to fix corruption - CHKDSK runs in read only mode. As far as I know, this would not cause any issues...
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
November 26, 2013 at 12:49 pm
Please correct me if I am wrong - but setting AWE won't have any affect on this system because it only has 4GB of memory. To be able 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
November 11, 2013 at 1:03 pm
I believe you can also use BACKUP DATABASE ... WITH NORECOVERY; and it does the same thing. Very good for taking a last backup when migrating to a new...
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
November 7, 2013 at 12:13 pm
a20213 (11/5/2013)
can you try ?
update table set field=REPLACE(field, '@', '\')...
Won't work - as the OP is looking to change it from username@domain to domain\username.
You can do something like this:
UPDATE yourtable
...
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
November 5, 2013 at 12:10 pm
You cannot upgrade from 32-bit to 64-bit. It will be an uninstall/reinstall - unless you have a named instance or can use a named instance. In which case,...
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
November 5, 2013 at 11:59 am
Too bad you don't have access to the box itself...
If you did have access, and this is a one-time operation you could download and install a trial edition of Litespeed...
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
October 31, 2013 at 11:23 am
You cannot just execute sp_start_job - because all that does is starts the job and doesn't wait for the job to actually complete.
I would create a job on the 2012...
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
October 24, 2013 at 12:15 pm
Are you - by chance - running on an x86 platform?
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
October 22, 2013 at 1:31 pm
Sean Lange (10/22/2013)
polkadot (10/22/2013)
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
October 22, 2013 at 1:25 pm
The only way to get rid of the case expression would be to build a table that contains a cross-map of the values.
Then in your query you would join (outer...
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
October 22, 2013 at 1:11 pm
Viewing 15 posts - 2,671 through 2,685 (of 6,676 total)