Viewing 15 posts - 4,231 through 4,245 (of 6,676 total)
phil.curtis (1/26/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
January 26, 2010 at 2:17 pm
If you cannot use runas or ShellRunAs - then you are not going to be able to do what you are asking.
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, 2010 at 2:00 pm
Are you sure you are performing transaction log backups every 15 minutes? With a transaction log file that large, and the data file that small - it is hard...
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, 2010 at 1:30 pm
Because SQL Server has the SID - it can use that SID to perform an AD lookup of the username. It gets the actual name from AD and does...
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 25, 2010 at 9:46 pm
If you get a notification - one of the tasks in that job failed. You then view the history for the maintenance plan (not the agent job) - 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
January 25, 2010 at 7:12 pm
I will start my comment with the fact that you should change your process to either REINDEX or REORGANIZE - not both.
Now, the reason this plan does not work is...
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 25, 2010 at 2:17 pm
To select data based upon today's date, you can do the following:
SELECT {columns}
FROM {table}
WHERE YourDateColumn >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
AND YourDateColumn < DATEADD(day, DATEDIFF(day, 0, GETDATE()) + 1, 0);
This...
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 25, 2010 at 1:55 pm
Nope, sorry - still can't change the fact that you cannot use T-SQL to start SQL Server. You have even more problems though...
1) What are you going to do...
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 24, 2010 at 10:37 am
There is a standard report available called Disk Usage that will show the autogrowth events since the last restart of SQL Server.
Those events are stored in the default trace.
With that...
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 24, 2010 at 10:24 am
In order to be able to use xp_cmdshell - you have to connect to SQL Server. If SQL Server has been shut down, there is nothing for you 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
January 24, 2010 at 10:15 am
You can shutdown SQL Server using T-SQL, look up the SHUTDOWN command in Books Online. Once the service is stopped, you have no way of running any commands when...
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 23, 2010 at 8:10 pm
BSavoie (1/23/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
January 23, 2010 at 2:08 pm
L_avital (1/22/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
January 23, 2010 at 12:45 pm
Another thing to consider is what is meant by local storage. Local storage can be direct attached - in that box or a SAN. The SAN can 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
January 22, 2010 at 2:37 pm
Lynn Pettis (1/15/2010)
Ready to smack yourself on the forehead??
SET @start_dt = (SELECT dateadd(hh, 19, dateadd(day,datediff(day,0,GetDate())- 9,0)))
SET @end_dt = (SELECT dateadd(hh, 19, dateadd(day,datediff(day,0,GetDate())- 2,0)))
And, just to make things a bit simpler...
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 15, 2010 at 3:11 pm
Viewing 15 posts - 4,231 through 4,245 (of 6,676 total)