Search results for query: *

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...

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

Can i perform keyboard input into a variable?

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...

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

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...

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...

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.