Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TitleistDBA
  • Order by date
  1. TitleistDBA

    3gb and AWE

    I have a 700 gb db running on SQL 2000 Ent fix 997. The OS is Win2K3. We have been having a non paged pool memory error. Microsoft has suggested removing the 3db switch from the boot.ini. If I do this,it is my understanding that SQL will not longer be able to use more than 2gb of memory. Is...
  2. TitleistDBA

    sa password lost

    Unfortionatly, I can't get in at all. I think I'm going to have to stop the services, save off the database and re-install. www.acushnetcompany.com www.titleist.com
  3. TitleistDBA

    Cannot open backup device - when trying to backup a DB

    I have run into that problem. If your device is empty just delete it from the backup folder. When you run the backup it will create a new one. If you need the backup sets in it, then save it off. Also check that no other programs like Tivoli or other backup utilities have a lock on your...
  4. TitleistDBA

    Are my SQL Indexes Being Used? Utilization Rate?

    you can run sp_spaceused [index_name] to find how many rows and the size of you index. as for finding which indexes are being used that is going to be allot more difficult. if you know all the querries you can use query analyzer show plan. If you don't then you will need to run profiler to...
  5. TitleistDBA

    sa password lost

    I've just been handed a sql server 2000 sp4 install without the sa password. To make matters worse the built in admin has been removed. Short of re-installing is there a way in to the system to run sp_password www.acushnetcompany.com www.titleist.com
  6. TitleistDBA

    Sysobjects question

    I found a better way. I'll just do this to build my script. SELECT 'select OBJECTPROPERTY(object_id('+ name +'),CnstIsDisabled)' FROM sysobjects WHERE xtype = 'F' www.acushnetcompany.com www.titleist.com
  7. TitleistDBA

    Sysobjects question

    Mr Denny. Thank you very much. the only problem I have is there are hundreds of FK's and I don't know which one could be disabled. The company which provided us this product also gave the developers a script to disable all constraints. Why they would do that I have no idea. Anyway, I am...
  8. TitleistDBA

    Sysobjects question

    ...constraints have been disabled. Is there an easy way to do this? I have run the following select which will show my all my FK constraints. select * from sysobjects where xtype = 'F' How can I tell if any have been disabled with the following syntax. ALTER TABLE cnst_example NOCHECK...
  9. TitleistDBA

    Index Usage

    I know I can get current index usage from SQL Profiler, but I was hoping there was some unsupported DBCC command I didn't know about that would show me how often each index is accessed. Thanks for your help. www.acushnetcompany.com www.titleist.com
  10. TitleistDBA

    Index Usage

    In MSSQL 2000 Ent edition is there anyway to tell how often or even if an Index has ever been used? www.acushnetcompany.com www.titleist.com
  11. TitleistDBA

    Subtract two date fields

    Once again Denis you come to the rescue! Thanks for your help. www.acushnetcompany.com www.titleist.com
  12. TitleistDBA

    Subtract two date fields

    I have two data fields. They are both datetime datatypes [Date open] and [Closed on] I need to select all the records in my table where [Date Open] - [Closed on] < 4 hours Does anybody know how to do that? www.acushnetcompany.com www.titleist.com
  13. TitleistDBA

    Calculate percentage

    SQLDenis That worked!!! Thanks for your help!! www.acushnetcompany.com www.titleist.com
  14. TitleistDBA

    Calculate percentage

    Yes it is..But my boss would rather see the 27% So once I get the math to work for that percentage I will remove the percent free. www.acushnetcompany.com www.titleist.com
  15. TitleistDBA

    Calculate percentage

    ...USED', SUM(CONVERT(DECIMAL,LD.[Size in MBytes]))-SUM(CONVERT(DECIMAL,LD.[Free Space in MBytes]))/SUM(CONVERT(DECIMAL,LD.[Size in MBytes]))*100.00 AS 'Percent Used', SUM(CONVERT(DECIMAL,LD.[Free Space in MBytes]))/SUM(CONVERT(DECIMAL,LD.[Size in MBytes]))*100.00 AS 'Percent...
  16. TitleistDBA

    Calculate percentage

    ...in mbytes]) AS 'Percent Used' SUM(CONVERT(DECIMAL,LD.[Free Space in MBytes]))/SUM(CONVERT(DECIMAL,LD.[Size in MBytes]))*100.00 AS 'Percent Used' FROM ( [vResourceEx] T0 INNER JOIN [Inv_AeX_OS_Operating_System] T1 ON T0.[Guid] = T1.[_ResourceGuid] ) INNER JOIN...
  17. TitleistDBA

    Calculate percentage

    I feel stupid! This is my result set now? C: 6250963 4518721 .00 D: 26141720 15533886 .00 E: 4830965 3398903 .00 F: 11119681 6033662 .00 G: 1686799 972264 .00 H: 1012356 722261 .00 I: 406197 48508 .00...
  18. TitleistDBA

    Calculate percentage

    This query is returning me disk information about all machines. We are going to use the results to halp design our SAN. www.acushnetcompany.com www.titleist.com
  19. TitleistDBA

    Calculate percentage

    ...I have. SELECT LD.[DEVICE ID], SUM(LD.[Size in MBytes]) AS 'Total Space in MB', SUM(LD.[Free Space in MBytes]) AS 'Free Space in MB' SUM(LD.[Free Space in MBytes])/SUM(LD.[Size in MBytes])*100.00 AS 'Percent Used' www.acushnetcompany.com www.titleist.com
  20. TitleistDBA

    Calculate percentage

    I have the following query on a database for Altiris. it returns the device name, total space and free spcace for all of our servers in the company. SELECT LD.[DEVICE ID], SUM(LD.[Size in MBytes]) AS 'Total Space', SUM(LD.[Free Space in MBytes]) AS 'Free Space' FROM (...

Part and Inventory Search

Back
Top