Viewing 15 posts - 5,161 through 5,175 (of 6,678 total)
sam (5/22/2009)
Let me know if i say anything wrong.
Y can't the person take a full backup of all the databases manually and truncate the...
May 22, 2009 at 2:08 pm
If you have the /PAE switch set - then the first 3GB of memory would not be AWE memory and everything above that would be AWE. If this switch...
May 22, 2009 at 11:53 am
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...
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...
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.
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...
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...
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...
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...
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...
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.
May 21, 2009 at 12:27 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...
May 20, 2009 at 8:47 pm
Viewing 15 posts - 5,161 through 5,175 (of 6,678 total)