Viewing 15 posts - 4,576 through 4,590 (of 6,676 total)
Are both instances running SQL Server 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
September 17, 2009 at 1:41 pm
You are never going to be able to rebuild that index - because it is not an index. It is a HEAP (Index ID: 0).
If you need to reorganize...
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 17, 2009 at 1:27 pm
scott.lothert (9/17/2009)
Both query plans actually are using Index Seeks, the Unicode is doing a clusterd Seek. My bad 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 17, 2009 at 10:15 am
Review the article I link to in my signature - Gail does a very good job of explaining how to manage transaction logs.
What you are seeing is normal and expected...
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 17, 2009 at 7:48 am
Unless I'm missing something, you have a column defined as varchar - and you are passing in nvarchar data types. If you view the execution plans, I would bet...
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 16, 2009 at 10:33 pm
And the solution was?
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 16, 2009 at 1:33 pm
You would add that code inside the SUM, for example:
SUM(CASE WHEN...) AS ...
But, I would recommend using COALESCE and NULLIF instead of the CASE WHEN construct - so you would...
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 16, 2009 at 1:30 pm
You have to run the service pack on all nodes in the cluster to upgrade the non-cluster aware services that exist on each node. For example, SSRS/SSIS 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
September 16, 2009 at 1:12 pm
Use sp_rename to change the name, but be careful to identify the permissions on the procedure before you recreate it. Dropping and creating stored procedures removes the permissions 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
September 14, 2009 at 4:20 pm
Yes you can, but you need to install SQL Server 2000 first (and apply all service packs/patches), then you can install SQL Server 2008 as the default instance. 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
September 14, 2009 at 4:09 pm
Jess (9/11/2009)
Thanks for the response! Strange that I have SQL Server Enteprise Edition, which should be able to access 4GB.
Well, that depends - if you are running on x86 hardware,...
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 11, 2009 at 11:49 am
Yes, you can probably assume that. SQL Server 2000 Standard Edition could not use more than 2GB of memory, regardles of how much was available on the server.
SQL 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
September 11, 2009 at 10:52 am
Trooper,
Also be aware of the fact that breaking the log chain has potential issues that could be disastrous to your company. Here is an example:
Full backup at 1am yesterday
Transaction...
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 11, 2009 at 10:46 am
As a wish list - I would ask for two systems (clustered) running Windows Server 2008 x64 - 64GB RAM and 4 hex core processors to host SQL Server 2005/2008.
I...
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 7, 2009 at 5:17 pm
Nope - you're not alone.
All of my training is self-taught on the job - no degree. Company won't pay for a laptop - so I bought my own, 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
September 7, 2009 at 10:27 am
Viewing 15 posts - 4,576 through 4,590 (of 6,676 total)