Jeffrey Williams

Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 6,676 total)

RE: shrinking log file

Yes, there are restrictions on database names - and there are quite a few special characters that will cause problems.
You probably could have gotten around that particular error by quoting...
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 24, 2009 at 11:11 am

#1096370
RE: undo the last update on a table...

Unfortunately, your only option is to go back to the old backup and restore. You can restore to a separate database and then perform a comparison on just 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 24, 2009 at 11:05 am

#1096368
RE: Convert dates

Dates are not stored as formatted strings in SQL Server. The client you are using will display the datetime value according to how the client is set up 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

December 24, 2009 at 10:56 am

#1096364
RE: increase in log space used affecting performance

rrajkumar17 (12/24/2009)
I do agree 4 MB is too less for a log file. But its been working fine without issues for years. Our DBAs changed the size of one 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 24, 2009 at 10:43 am

#1096357
RE: Does DBAs use 'Update Statistics' maintenance plan task?

Michael Valentine Jones (12/23/2009)
I often schedule a job to run sp_updatestats on each non-system database on a daily basis.
This procedure was greatly improved with SQL 2005 to only do updates...
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 24, 2009 at 9:58 am

#1096344
RE: Looking at someone elses code

Lynn Pettis (12/21/2009)
CirquedeSQLeil (12/21/2009)
Lynn Pettis (12/21/2009)
Jason is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). ...
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, 2009 at 7:33 pm

#1095209
RE: Looking at someone elses code

CirquedeSQLeil (12/21/2009)
OK Jeff, what am I missing here - I see no code at all.
Well - you're probably missing the ability to access the linked image. The code 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

December 21, 2009 at 5:07 pm

#1095182
RE: SQL Server Auditing - Yeah that again

First, I don't believe SQL Server actually stores login attempts. You can find that information in the event log and/or SQL Server log.
Second, the only way the owner 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 21, 2009 at 4:58 pm

#1095178
RE: Looking at someone elses code

Lynn Pettis (12/21/2009)
SQL Iron Chef (12/21/2009)
Lynn Pettis (12/21/2009)
SQL Iron Chef (12/21/2009)
You do know that the NOLOCK hint on the update is ignored, right?
Actually I didn't! I was just trying 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

December 21, 2009 at 4:20 pm

#1095164
RE: Setting memory

kareem007 (12/21/2009)
So in my case shall I enable AWE ?
If you want SQL Server to be able to access more than 2GB of memory, then yes - you need 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

December 21, 2009 at 4:15 pm

#1095162
RE: How do I delete a transaction log file?

I am not sure, but I don't think the EMPTYFILE option actually works with log files. You need to issue checkpoints until the VLF is located in the primary...
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, 2009 at 4:13 pm

#1095160
RE: Maintenance plan

If you rebuild your indexes, you don't need to re-organize them. Also, there is no need to update statistics on index statistics after a rebuild. However, if 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

December 21, 2009 at 4:09 pm

#1095159
RE: Autogrowth out of control

As I think you are already aware - there was an issue with the autogrow setting being converted to a very large number. If you have already patched beyond...
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, 2009 at 4:07 pm

#1095157
RE: Page File Maxed Out - Help !!

iqtedar (12/20/2009)
thanks Jeff..Yup i realized the memory in in Mb.s
So, was that the problem and is it now resolved? Or, are you still having the issue?
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 20, 2009 at 6:49 pm

#1094566
RE: transaction log

Who recommended truncating the transaction log?
Are you performing regular and frequent transaction log backups? If not, why are you running in full recovery model?
Once you issued that command, 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

December 20, 2009 at 11:08 am

#1094522

Viewing 15 posts - 4,351 through 4,365 (of 6,676 total)