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: sguslan
  • Content: Threads
  • Order by date
  1. sguslan

    error 3624

    Cheers all, We have an HP DL760/8 CPU with HyperThreading Enabled/8GB RAM and an HP EVA5000 SAN running win2003 /SQL Server2000 SP3. The main active DB size is 400 GB with many tables having more than 30 million rows. Suddenly we are experiencing error 3624 for no apparent reason. Any one has...
  2. sguslan

    Any one had 3624 error in sql server 2000 - SP3

    Cheers all, We have an HP DL760/8 CPU with HyperThreading Enabled/8GB RAM and an HP EVA5000 SAN running win2003 /SQL Server2000 SP3. The main active DB size is 400 GB with many tables having more than 30 million rows. Suddenly we are experiencing error 3624 for no apparent reason. Any one has...
  3. sguslan

    Windows 2003 network stops functioning after Cisco Router powere on

    I have a database LAN connected to 2 WAN networks and dedicated fiber link into a mainframe. The database LAN is made up of a Cisco 4000 layer2 switch with no VLANs and one subnet 10.0.6.x ... WAN 1 is extranet type and i control the router with subnets in the 172.x.x.x range. All routing is...
  4. sguslan

    PIX 515E stops responding

    We have 2 pix firewalls one protecting the perimiter the other protecting the internal apps. The first is working fine, but the internal pix sops passing packets to the apps network after a while. The only way to keep it running is to pass some packets from the inside to the perimiter network...
  5. sguslan

    Dreaded Realetd ComboBox columns in DataGrid

    How do i change a datagrid two column styles to show a combobox bound to some db table and related to another combobox column in a parent/child relationship[in the same datagrdi], such that when the parent column changes the child column combobox changes too ... Urgently need a solution ...
  6. sguslan

    Joins Performance

    A nice article on joins ... Hope you find it helpful . http://www.sql-server-performance.com/tuning_joins.asp ________________________________________________________________________________ If you do not like change, get out of the IT business...
  7. sguslan

    Databases Indy 500 !

    SQL 64bit is the performance leader now ! http://www.tpc.org/tpcc/results/tpcc_perf_results.asp?resulttype=noncluster ________________________________________________________________________________ If you do not like change, get out of the IT business...
  8. sguslan

    Great SQL Security reading ! htt

    Great SQL Security reading ! http://vyaskn.tripod.com/sql_server_security_best_practices.htm ________________________________________________________________________________ If you do not like change, get out of the IT business...
  9. sguslan

    See what SQL Server 64-bit can deli

    See what SQL Server 64-bit can deliver ... ! NEC has moved up the ladder in the OLTP database performace fray .. NEC holds number 2 postion for non-clustered systems behind a huge mainframe from Fujitsu.. And the sweet part is the low cost per transaction standing at $12 where as the mainframe...
  10. sguslan

    SQL Replication to Oracle 8i : ORA0001 Primary Key violation

    I have an SQL setup to replicate data to an Oracle 8/7.3... After upgrding to Oracle 8i, we started getting ORA0001 primary key violation messages and the replication started missing about 5% of the replicated rows. Reverting Oracle back to version 8 solved the problem> Any one experienced such...
  11. sguslan

    Virtual Memory Question

    Terry , I've setup an dedicated SQL server 2000/SP2 with one mission: read rows from OS390/DB2 through HIS2000 and linked server to DB2, then store and forward data to 2 Oracle servers[7.3 and 8i] I experienced VM [at least that is my conclusion] problems where, immediately, after running a...
  12. sguslan

    HIS200 SP1 resolves some DB2 linked server problems

    For those of you SQL Gurus running SQL linked servers to a Mainframe DB2 though SNA protocols, Microsoft released HIS2000 SP 1. I used to have trouble with DB2 linked servers leaking memory and rendering SQL server unusable until SQL is restarted; but, after applying HIS2KSP1, all problems...
  13. sguslan

    C# DataGrid Printing

    Hi C# gurus Is there a simple way to print the content of a datagrid. I found examples at the C corner web site, but were in a dequate, or hard to customise for my needs. Coming from PowerBuilder, i find printing the most deficient aspect of C#/Visual Studio. In powerBuilder, when you create a...
  14. sguslan

    Migrating Oracle to SQL server

    I found this helpful article for people migrating Oracle Pl-SQL into SQL Server T-SQL ! Enjoy .. http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
  15. sguslan

    T.Broadbent AND Gurus: how to iput data from keyboard

    Can i perform keyboard input into a variable?
  16. sguslan

    SQL Drained Resources !

    Hi Gurus,, I use a sql2000/SP2/Win2000 SP2 to copy data from a DB2 mainframe database with MS HIS2000 using APPC transport. When I execute many queries directly through a linked server as opposed to using OPENQUERY [ i.e. select fields from linkedserver.database.owner.tablename], the linked...
  17. sguslan

    Hi All ... If a local user on a

    Hi All ... If a local user on a W2K prof workstation has the same user name and password on a domain, he can just double click on the DC/server name on the network neighborhood and have immediate access to all resources without being asked for the password. Can this behavior be changed? Thanx
  18. sguslan

    Slow machine

    Have a fast Dell server with a fast >1G CPU and 1 GB mem for development. One of the developers manage to get the transaction log full and ate up all HD space>45 GB. After cleaning the mess the server became very slow. I defragged system and data drives then copied the data to a new database...
  19. sguslan

    Any thoughts on Unisys ES7000 ?

    I am in charge of an SQL2000 operational datastore/DW prject. The raw data is only 150-200GB on a SAN storage. I have 2 options(budget allows both): 1 -- Run both databases on Unisys ES7000 with 32 CPUs 32GB memory( 2 partitions each running 2 SQL instances for an MS MSC passive/active...
  20. sguslan

    Tough Date Question

    Gurus,, Can I change the default datetime range to accept dates < 1753 for historical data? I have tons of historical data that I need to process with different SQL date functions, so storing dates as INT or DECIMAL is out of question.

Part and Inventory Search

Back
Top