Viewing 15 posts - 3,181 through 3,195 (of 6,676 total)
cfradenburg (5/27/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
May 27, 2011 at 3:03 pm
Welsh Corgi (5/27/2011)
Lucky9 (5/27/2011)
Yes sir, i need the earliest date of the particular status
I hope that this urgent requirement is only a homework assignment? :w00t:
What you have stated so...
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
May 27, 2011 at 1:00 pm
It is generally more efficient to use a single query and let SQL Server do the work. However, there are times when the query or process becomes so complex...
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
May 27, 2011 at 12:27 pm
Is this by chance running on Windows Server 2008? If so, then you need to realize (and your client) that the root of drives is more protected on this...
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
May 27, 2011 at 12:06 pm
In addition to Gail's recommendations - another option is just to leave the size alone. If you are going to rebuild all indexes - then you need the 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
May 27, 2011 at 10:06 am
Matthew Spinks (5/26/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
May 26, 2011 at 7:11 pm
You really do not have an option for an in-place upgrade. You do have an option for an SKU Upgrade.
I would recommend the SKU Upgrade - it is quite...
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
May 26, 2011 at 6:48 pm
I also avoid them - all it takes is a misplaced INIT command and you have just lost all of your transaction log backups.
Having a single file is no different...
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
May 26, 2011 at 6:40 pm
You can backup directly to a network share. To do so, you have to use the UNC path instead of a drive letter. Since SQL Server is a...
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
May 26, 2011 at 6:31 pm
Groleau+SQL (9/1/2010)
SELECT _________ FROM ______ AS Data WHERE DATEPART(month, Data.The_Date_Field)
= DATEPART(month, DATEADD(month, -1, GETDATE()));
(Say, when I screw up, how do I delete my post instead...
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
May 25, 2011 at 8:14 pm
Take a look at SQL Assistant from SoftreeTech - this is another tool much like SQL Prompt. This tool works on multiple database systems (SQL Server, Oracle, mySQL, etc...)...
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
May 24, 2011 at 8:16 pm
When you say you cannot failover the instance - which instance are you failing over and what is the current node hosting that instance?
When I had a similar problem 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
May 24, 2011 at 8:14 pm
You can read this blog: http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx
The actual counters are: Avg Disk sec/Read and Avg Disk sec/Write (sorry - mixed them up, which I always do unless I actually open perfmon).
What...
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
May 23, 2011 at 3:37 pm
What is 32-bit, is it the OS or the installation media?
SQL Server 2008 (and above) is a combined installation media and will default to the OS that you are installing...
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
May 23, 2011 at 1:02 pm
To validate your IO - you should be looking at the Avg Disk Reads/sec and Avg Disk Writes/sec counters. Open perfmon on the server and start capturing those numbers.
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
May 23, 2011 at 12:49 pm
Viewing 15 posts - 3,181 through 3,195 (of 6,676 total)