Viewing 15 posts - 5,716 through 5,730 (of 6,676 total)
Well, then add the COUNT windowing function.
SELECT (ROW_NUMBER() OVER (PARTITION BY r.RaceID, ORDER BY someresultformula))
/ (COUNT() OVER(PARTITION BY r.RaceID)) AS...
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
January 4, 2009 at 2:47 pm
BTW - the key here is the combination of Windows Server 2008/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
January 4, 2009 at 2:36 pm
Did you validate the BUILTIN\Administrators group in SQL Server 2008? I believe the problem you are having is the fact that security has changed on Windows 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
January 4, 2009 at 2:33 pm
Jayakumar Krishnan (1/4/2009)I ensured that the group where the NT user member of is Admin of the box, the same config on this box is followed other boxes as well...
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
January 4, 2009 at 12:06 pm
Well, just for that you don't need SQL Server Agent. If that is all you are doing, you might want to consider installing SQL Server Express instead. Download...
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
January 3, 2009 at 10:38 am
Review the event logs for any errors when trying to start SQL Server Agent. You can also review the SQL Server error logs for any messages there.
SQL Server Agent...
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
January 3, 2009 at 10:28 am
No - I don't think that it related to SAN. Most likely you have the default backup directory defined to the D: drive. You can find it by...
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
January 3, 2009 at 12:07 am
Is there a question here?
FWIW - item #1 is debatable and you will get people on both sides of the issue. I personally setup my service accounts as local...
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
January 2, 2009 at 7:04 pm
This looks like the original SP2 release - which had several problems. I would recommend upgrading to at least 9.0.3054 (at a minimum). Ideally, if you can apply...
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
January 2, 2009 at 3:20 pm
Preet (1/2/2009)
bbbrian007 (12/27/2007)
Maybe in the future, Microsoft will improve their optimization...
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
January 2, 2009 at 11:23 am
Oops - I read that wrong. Index ID 0 is a heap - ID 1 is a clustered index.
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
January 2, 2009 at 11:11 am
No problem - glad I could help.
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
January 2, 2009 at 10:43 am
Phil Factor (1/2/2009)
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
January 2, 2009 at 10:41 am
Why do you think you don't have a clustered index? I would take another look at the table - because your results are telling you that you do in...
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
January 2, 2009 at 10:26 am
The SPN is going to be registered under the account running SQL Server - not the machine. Use the -Q option to query for the SPN record instead 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
January 2, 2009 at 9:50 am
Viewing 15 posts - 5,716 through 5,730 (of 6,676 total)