Viewing 15 posts - 5,776 through 5,790 (of 6,676 total)
Are your client tools upgraded to the same level as the 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
December 26, 2008 at 9:21 am
I don't think you will get the kind of numbers you are looking for with this. SQL Server will take as much memory as it needs - in fact,...
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 23, 2008 at 4:06 pm
And here is the above cleaned up a little:
Declare @days int;
Declare @inputDate datetime;
Set @days = 10;
Set @inputDate = '20081225';
;With nums(n)
As (Select Top(@days + (@days / 5 + 1) * 2)...
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 23, 2008 at 3:54 pm
The first thing you are going to want to do is get that data into a usable format. That would be - put the data into a table in...
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 23, 2008 at 2:30 pm
Here is a small little modification to Jack's code which will give you what you want.
-- populate temp numbers table
SELECT TOP 100
IDENTITY(INT, 1,1) AS n
INTO
...
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 23, 2008 at 2:19 pm
As suggested by Luke - review the articles that he gave you the links for. Those articles will show you how to solve your problem.
If not, then...
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 23, 2008 at 1:50 pm
What are the min/max memory settings for each instance running on each node?
What is the Maximum Degree of Parallelism setting on each instance?
What was the previous system configuration?
And last, but...
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 23, 2008 at 12:24 pm
madhu.arda (12/23/2008)
We 16GB in the server and total 16GB is allocated for SQL Server.Still we got couple of times the below error in last two months.
A significant part of...
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 23, 2008 at 12:01 pm
Why do you have to loop? What is the requirement that states you have to process a single day at a time?
FWIW, you could build a stored procedure 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
December 23, 2008 at 10:59 am
Steve Jones - Editor (12/22/2008)
That works if you're restoring same server, but if this were DR or on another box, you wouldn't know, would you?
As long as you are not...
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 22, 2008 at 10:24 pm
No, the maintenance plan plug-ins do not have any real logic behind them. The rebuild plug-in generates the code to rebuild every single index in the database(s) selected. ...
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 22, 2008 at 7:33 pm
Use msdb;
Select *
From dbo.restorehistory r
Inner Join dbo.backupset b2 On b2.backup_set_id = r.backup_set_id
Inner Join dbo.backupmediaset b3 On b3.media_set_id = b2.media_set_id
...
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 22, 2008 at 5:31 pm
WebTechie38 (12/22/2008)
I couldn't use SSMS because it was giving me an error message. I tried but since the tables had a lot of data, I couldn't just move 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 22, 2008 at 2:06 pm
ps (12/21/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
December 22, 2008 at 1:58 pm
And, if you decide to follow 'timothywiseman' solution - don't forget to remove any indexes and recreate them on the new columns, as well as the foreign key references (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
December 21, 2008 at 6:59 pm
Viewing 15 posts - 5,776 through 5,790 (of 6,676 total)