Viewing 15 posts - 2,971 through 2,985 (of 6,676 total)
Here is a script I use to identify the unused space allocated to a table. I have used this to identify HEAPS that have a lot of unused space.
...
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
October 19, 2011 at 11:47 am
After you restart SQL Server, it will start allocating memory as needed - up to the max memory setting. Once it hits the max memory setting, it will 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
October 16, 2011 at 8:14 am
cdumont (10/14/2011)
The Maintenance job...
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
October 15, 2011 at 6:53 pm
AER (10/6/2011)
This is a Live database. Is it not going to affect performance?
Yes, it will affect performance because it needs to read the database and move pages around. 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
October 6, 2011 at 11:48 am
No, this will not be possible because it isn't a backup. If you had a backup - then you could perform a partial file restore, but then again -...
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
October 6, 2011 at 11:36 am
Here is how I would do this:
1) Create two tables for the process - an odd/even pair (MyTransformedDataOdd, MyTransformedDataEven).
2) Create 2 synonyms - one for the current data, one 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
September 15, 2011 at 2:11 pm
meghna.bhargav (9/10/2011)
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
September 10, 2011 at 6:46 pm
Another option is CROSS APPLY. Example:
select c.case_id
,m.description
,m.seq_num
from case_table c
cross apply (select top...
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
September 10, 2011 at 6:40 pm
One trick I learned a while ago is to modify SSMS to change tabs to spaces and to change the default tab size to 8 characters instead of the default...
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
September 4, 2011 at 9:47 am
You can turn on SQLCMD mode which will allow you to use SQLCMD syntax. The one I think you are looking for is:
:r filename
That will load the SQLCMD code...
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
September 3, 2011 at 8:56 am
I wouldn't call it an active/active cluster. It is really a multi-instance cluster in the Windows/SQL Server world.
To create a multi-instance cluster, you need to create separate resources 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 31, 2011 at 6:10 pm
The default connection settings for Oracle is explicit transactions. Which means you have to specifically issue a commit or rollback.
In SQL Server, the default is implicit transactions - which...
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 31, 2011 at 6:06 pm
webtekkie (8/31/2011)
Is is necessary to reindex every index on...
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 31, 2011 at 6:03 pm
I would look at the functions and either convert them to iTVF or eliminate them. In fact, I would get rid of all of the functions on the select...
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 31, 2011 at 5:59 pm
If there isn't any database corruption - then my guess is someone cleared the history. How are you checking the job history?
Wait...just realized you are talking about jobs. ...
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 28, 2011 at 10:12 pm
Viewing 15 posts - 2,971 through 2,985 (of 6,676 total)