Viewing 15 posts - 3,076 through 3,090 (of 6,676 total)
In addition to all of the advice given so far - you really need to look at how you are using those functions. Scalar functions are notoriously slow 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
July 9, 2011 at 6:19 pm
There are only a few processes that will break the differential backup chain. This has nothing to do with the log chain at all - specifically, this is some...
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
July 8, 2011 at 2:12 pm
I am going to guess that the OP means he needs to add 14GB of the additional 28GB of memory to that instance of SQL Server.
The question still remains -...
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
July 7, 2011 at 1:21 pm
Can you provide the backup statement that is being used to backup the databases?
Also, just to verify - can you provide the results of @@version for each instance?
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
July 7, 2011 at 1:14 pm
what you are seeing is just a display issue. By default, output is truncated at 255 characters or the size of the column, whichever is smaller.
The data type 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
July 6, 2011 at 10:37 am
And, reviewing your code - I am not sure what you are trying to accomplish. There doesn't seem to be any reason to use rtrim, nor any reason to...
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
July 5, 2011 at 8:50 pm
Returns character data if expression is one of the supported character data types. Returns binary data if expression is one of the supported binary data types.
The above is from...
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
July 5, 2011 at 8:47 pm
It depends on what has happened on the principal after mirroring has been stopped. If you have a continuous log chain, then all you need to do is 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
July 5, 2011 at 8:22 pm
I know this isn't a solution - but there are two buttons next to the database drop-down to connect/disconnect or change connection.
After dragging the file, or double-clicking a sql file...
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
July 5, 2011 at 8:16 pm
I don't see what columns you are totaling, and what the expected total should be.
For this example, what is the expected value - and what is the actual value you...
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
July 5, 2011 at 8:00 pm
This is normal when you haven't set max memory for SQL Server. SQL Server will take all of the memory you allow 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
July 5, 2011 at 3:06 pm
This cannot be done using the standard tasks provided for maintenance plans. To do this, you would need to write custom code to loop through each database - backup...
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
July 5, 2011 at 3:02 pm
That looks good to me - good luck.
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
July 4, 2011 at 1:28 pm
I have done this same procedure on several systems - and it works quite well.
The last time we had to do this, I didn't even have to get involved. ...
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
July 4, 2011 at 12:23 pm
Ninja's_RGR'us (7/4/2011)
How do you estimate the impact of a slower processor speed when you are dealing with mostly oltp env? Olap? Hybrid?
Actually, I usually don't have to - because...
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
July 4, 2011 at 12:00 pm
Viewing 15 posts - 3,076 through 3,090 (of 6,676 total)