Viewing 15 posts - 3,646 through 3,660 (of 6,676 total)
This is really useful when bulk loading data into a DW. When you bulk load the data, you can DISABLE all of the non clustered indexes, load the data,...
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
August 22, 2010 at 10:27 am
sql_er (8/21/2010)
I work with MSSQL 2000. When creating tables I never paid attention to the order and type of columns. Last week a co-worker mentioned that it 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
August 22, 2010 at 10:25 am
The default settings of the SQL Server Agent is usually not adequate. There are two options in that dialog, the first one defines how many rows will be kept...
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
August 20, 2010 at 5:17 pm
Rajat Jaiswal-337252 (8/16/2010)
I just want to reduce log file size because there is size issue on my production database drive.
and the log become 20 GB to 30 GB...
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
August 16, 2010 at 7:10 pm
Rajat,
I am still confused as to why you think you need to shrink the log file at all. The size of the log file has no bearing on 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
August 15, 2010 at 11:02 am
Unless there is a specific reason you need to use separate service accounts for each service - I don't usually do that. I'll create a single service account for...
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
August 15, 2010 at 10:52 am
The simplest and fastest (for me), is to just open a query window and start typing.
Now, if this is a case where the user is not really sure what 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
August 13, 2010 at 2:15 pm
I would create a stored procedure that loops continuously - and put in a WAITFOR DELAY.
Then, create a SQL Agent job that checks to see if the process is started...
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
August 11, 2010 at 6:55 pm
The two statements are not equivalent - combining them could eliminate those rows that don't match the second queries criteria, and those rows wouldn't be updated.
To make sure you can...
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
August 10, 2010 at 7:57 pm
That is correct - SQL Server 2008 does not add the BUILTIN\Administrators to SQL Server. This is a security measure to prevent local administrators of the machine from automatically...
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
August 10, 2010 at 7:42 pm
Use configuration manager to restart the services. You can use SSMSE - if you run it as administrator.
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
August 7, 2010 at 9:35 am
Review the article I link to in my signature - it explains all of this very well.
Truncation makes space in the log file available to be reused. Truncation happens...
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
August 5, 2010 at 7:38 pm
Lynn Pettis (8/5/2010)
I guess I'll post my answer in both.Here is an article you may want to read as well: Deleting Large Number of Records[/url].
heh - I found the other...
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
August 5, 2010 at 7:31 pm
WayneS (8/5/2010)
Thanks for the update Jeff.In 2008, you should be able to use PowerShell to get the data you need.
Only if you have access to the OS to run 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
August 5, 2010 at 5:31 pm
jerry-621596 (8/5/2010)
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
August 5, 2010 at 5:07 pm
Viewing 15 posts - 3,646 through 3,660 (of 6,676 total)