Viewing 15 posts - 5,161 through 5,175 (of 6,676 total)
A good day off would be any day where I didn't think of work, log into work from home, answer an email from work or have anything to do with...
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 22, 2009 at 11:48 am
Unless I am missing something, put this in the text box:
="Coverage Type of B: " & Sum(IIF(Fields!Coverage_Type.Value = "B",1,0))
Now, I wouldn't do it this way because you lose the ability...
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 22, 2009 at 11:42 am
Search this site and google for articles on parameter sniffing. That is what you are running into here.
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 21, 2009 at 9:43 pm
Thanks Steve - I should have been clearer on that.
FWIW - I use Powershell and SMO to connect to the SQL Server and pull the DataSpaceUsage and IndexSpaceUsage properties 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
May 21, 2009 at 5:41 pm
No - that kind of information is not stored or tracked by SQL Server. You have to build your own process to get that information to be able 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
May 21, 2009 at 3:41 pm
And do not truncate the log anymore. By doing that, you are breaking the log chain and eliminating the ability to perform point in time recovery. You have...
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 21, 2009 at 2:58 pm
You really should be looking at sys.dm_db_partition_stats instead of sysindexes. There are known issues with sysindexes not being updated appropriately and requiring update usage (dbcc updateusage) to be run...
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 21, 2009 at 2:52 pm
Steve Jones - Editor (5/21/2009)
Right, sorry, Flip to full, truncate to clear space, flip back.I want to reset the space usage down and see what happens.
No need to truncate the...
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 21, 2009 at 2:47 pm
pradyothana (5/21/2009)
Thanks Jeffrey Williams ...for Link in your signature
Really - you should thank Gail for the article.
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 21, 2009 at 12:27 pm
What is the error message you are getting? What tool are you using?
Just stating that you can't login does not provide enough information for anybody to identify the problem....
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 20, 2009 at 8:50 pm
Please review the article in my signature and learn how to manage your transaction logs. Do not shrink the transaction logs on a regular basis. Doing so will...
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 20, 2009 at 8:47 pm
Yeah - it is kinda cool 😎
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 20, 2009 at 8:39 pm
What is the error you are getting when you try to login? What tool are you using to login?
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 20, 2009 at 4:36 pm
nimmi.smith (5/20/2009)
Thanks for the advise. I will find a math forum and post there. Any know of math forums?
I will say it again - the problem you are...
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 20, 2009 at 4:23 pm
I also would recommend looking at SQL Server 2008 and filestreams.
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 20, 2009 at 3:40 pm
Viewing 15 posts - 5,161 through 5,175 (of 6,676 total)