Viewing 15 posts - 4,006 through 4,020 (of 6,676 total)
Add to the list:
Any query hints? If so, is it required and the documentation in place explaining why?
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 23, 2010 at 7:21 pm
If you are migrating off of this system, why do you care? Once you have moved to the new system wouldn't you just retire the existing system and delete...
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 23, 2010 at 2:04 pm
I agree with Jason...
Next items:
Are all objects schema qualified?
Are aliases defined and used?
Are there any functions being used in the where clause that would prevent index usage?
Are there any functions...
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 23, 2010 at 2:01 pm
Why do you want to return the space to the OS? Your database is going to grow - so why not keep the space for the future growth 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
March 23, 2010 at 1:01 pm
Yeah - I was afraid of that. And, no - I don't have any other suggestions - sorry.
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 23, 2010 at 7:03 am
Not sure this will work for your case, but you can lookup SOUNDEX and see if that gets you anywhere. Documentation here: http://msdn.microsoft.com/en-us/library/aa259235(SQL.80).aspx
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 22, 2010 at 9:54 pm
I wasn't clear on whether or not the problem is with your log file - or your data file. If it is your log file, how often are you...
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 22, 2010 at 9:46 pm
You are welcome - and thanks for the feedback, it is appreciated.
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 22, 2010 at 7:40 pm
Are you trying to backup across the network? Is SQL Server running under a domain user account that has the necessary rights to the folder being backed up 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
March 22, 2010 at 2:19 pm
Instead of using db_datareader, and then trying to remove all other access - it would be better to create your own role and add the specific rights you want 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
March 22, 2010 at 2:17 pm
Error 33 is telling you that the file is locked by another process. One of the reasons for that could be a compressed volume. Another possibility is 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 22, 2010 at 7:25 am
Digs (3/21/2010)
Whats with the ';' in the SQL statement'2000-01-01');
???
I dont use ';' in SQL 2005, should I ??
You should start getting in the habit of terminating your SQL statements...
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 21, 2010 at 3:38 pm
ihsanps (3/21/2010)
Below are the Process which i m doing inside the cursor.Hope this will help you to give me a better solution.
OPEN @getData
FETCH NEXT FROM @getData INTO @DateValue,@Value
WHILE @@FETCH_STATUS =...
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 21, 2010 at 10:15 am
TRACEY-320982 (3/21/2010)
There are approx 133095 rows per day.
DELETE TOP(100000)
FROM tablename WHERE
startdate >= '2009-12-17' and
startdate <= '2009-12-17'
Then this uses approx 10 GIG of Log...
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 21, 2010 at 9:50 am
Dang it - you are quite right. Per socket is what I thought I wrote...thanks.
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 20, 2010 at 11:00 pm
Viewing 15 posts - 4,006 through 4,020 (of 6,676 total)