Viewing 15 posts - 6,631 through 6,645 (of 6,676 total)
And yet - you want to allow end users the ability to write ad-hoc queries? Even when you know you have a problem with developers (who should know better)...
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 18, 2008 at 11:07 pm
Sorry - but I have to jump in here.
What happens to your OLTP web based application when a user submits a resource intensive ad-hoc query that blocks access to one...
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 18, 2008 at 10:02 pm
Just a thought - but have you checked the SQL Agent service?
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 17, 2008 at 10:43 pm
Well, if you really want to roll your own - how about Powershell and SMO. Yes, you still need to install both Powershell and SMO - but they are...
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 17, 2008 at 10:14 pm
There are many ways to get this done - but, depending on where this is being done can have a performance impact.
One of the faster methods of getting...
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 12, 2008 at 9:43 pm
The process you are going to need to following to shrink the log file is:
1) Change recovery model to simple
ALTER...
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 9, 2008 at 11:25 am
Mike,
Since you are already looking at Red-Gate SQLBackup, try creating a new backup using SQLBackup and compression to create a smaller file. Try restoring that file - copying 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
March 3, 2008 at 12:13 pm
MALIK (3/3/2008)
i just receive an email error msg from sql server by saying this..
The SQL Server performance counter 'Percent Log Used' (instance 'DATABASE') of object 'SQLServer:Databases' is now above 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 3, 2008 at 12:05 pm
If you are on SQL Server 2005 - you can do everything you need to do in a maintenance plan. SSMS maintenance plans include a task called Execute SQL...
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 3, 2008 at 11:47 am
One more thing you might want to consider. Before running your backup set the database into single user mode then run the backup. This will insure that there...
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 3, 2008 at 11:14 am
My guess is that you are on a cluster. The drives have been added to the cluster, but not so that SQL Server can see them. On 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
February 24, 2008 at 11:39 am
Jason Selburg (2/23/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
February 24, 2008 at 10:36 am
I think what you are going to need to do is have a separate column for each OR condition, for example:
SELECT
...
,case 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
February 23, 2008 at 10:16 pm
Since you have to resort to dynamic SQL anyways, don't bother with two statements and a temp table. You can do something like:
Declare @sql varchar(max);
Set @sql = '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
February 23, 2008 at 10:00 pm
tigersam_20002000 (2/22/2008)
What features of SQL Server require you to use full logging?
Whether or not you use simple or full recovery model is not dependent upon any features of 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
February 23, 2008 at 9:32 pm
Viewing 15 posts - 6,631 through 6,645 (of 6,676 total)