Viewing 15 posts - 3,451 through 3,465 (of 6,676 total)
The database engine and analysis services engines are services - not applications. You won't see them in Programs, but you will see them in the services applet (services.msc).
It sounds...
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 4, 2011 at 6:40 pm
willtwc (1/3/2011)
DECLARE @DatabaseName nvarchar(50)
DECLARE @SPId int
DECLARE @userid varchar(100)
declare @command varchar(200)
SET...
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 3, 2011 at 7:04 pm
So, you are restoring the backup to another system - not the same system.
It looked like you were backing up the database, and restoring it to the same system. ...
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 3, 2011 at 7:01 pm
Well we tried the single user mode. We are using Lite Speed and it tries to open another connects and fails. So we abandon that method.
Steve
I use 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
January 3, 2011 at 3:17 pm
Now I have to ask - why would you do this?
It really does not make any sense to backup the current database, then immediately restore over the existing database 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 3, 2011 at 3:08 pm
pro-1019688 (1/2/2011)
Someone mentioned in an earlier post that all tables must have a cluster definition. This is not true. It's called a hash table.
Actually - it is called...
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, 2011 at 3:22 pm
Not sure about Azure and what is available or not - but lookup WAITFOR in BOL. That will allow your process to sleep for a time and start up...
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, 2011 at 3:17 pm
Also a bit late, but if SSIS is not installed on that server - then I would think the package is also not installed on that server. If it...
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, 2011 at 3:14 pm
First, what do you believe the certs will give you - that you don't already have through time and experience?
Is there a goal here besides just getting a certificate?
I wouldn't...
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, 2011 at 10:31 am
Lowell (1/1/2011)
instead of quotes, you could use the builtin QUOTENAME function to get brackets, which would still be syntactically correct:
SELECT 'EXEC sp_helpdb ' + QUOTENAME(name) + ' FROM sys.tables
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 1, 2011 at 7:06 pm
Yes - it is possible to run multiple instances in a cluster, and no reason why you cannot run both 2008 and 2005 on the same cluster.
Remember, in a cluster...
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 1, 2011 at 10:08 am
A couple of things:
1) Are you sure you are running SQL Server 2008 Enterprise Edition and not Standard Edition? Use one of the following to verify:
Select @@version;
Select serverproperty('Edition');
Note: Standard...
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 28, 2010 at 2:48 pm
A couple of items missed in the recommendations might help out:
Data Compression
Page Compression
Either (or both) of the above options could reduce the storage requirements and also improve IO performance. ...
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 27, 2010 at 5:30 pm
When you setup a maintenance plan - by default, reporting is enabled. You get to this reporting by clicking on the Reporting & Logging button next to the Manage...
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 27, 2010 at 5:17 pm
You need to modify the command line when executing maintenance plans. The reason for this is because of the sub-plan capability, which just creates separate containers inside a single...
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, 2010 at 10:14 am
Viewing 15 posts - 3,451 through 3,465 (of 6,676 total)