i have slary system using vb.net and sql server there is 27 user the compute up to 700 employ salary every monthe i collecte (700 *27) number of row and adding them programaticaly to a table called salary the table salary have 40 column with one primery key is there any proplem with this algorthim [...]
Answer Question | March 31, 2012 6:09 AM
Database, Database design, SQL Database, SQL Server database design and modeling
Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it [...]
Answer Question | February 6, 2009 12:57 AM
Database design, SQL Server administration, SQL Server database design and modeling, SQL Server maintenance, SQL Server performance, Very Large Databases
I am trying to load data into 13 column textboxes, and I need the ability to pull any number of rows from the SQL Server based on these parameters: control group number, accounting period and posting date. The results will be about 50 lines of transactions, and I want those loaded to textboxes on my [...]
Answer Question | January 27, 2009 7:49 PM
SQL Server, SQL Server database, SQL Server database design and modeling, SQL Server Row Versioning
I have a SQL Server with eight disks, and I am not sure if I should use Raid 10 twice, one for Windows Server 2003 with NDFs and the other for the log file and tempdb, or apply Raid 1 for the Windows Server, Raid 10 for the NDF and MDF, and Raid 1 again [...]
Answer Question | October 25, 2008 4:52 PM
RAID, RAID 1, RAID 10, SQL Server database design and modeling, Windows Server 2003
Hi I want to expand the number of columns that sql would permit me to creat. How do I start? any suggestions? example: 1032 maximun column limit I want in the area of upper 5000 ramge for a table. someone help thanks
Answer Question | October 15, 2008 6:05 AM
SQL Server database design and modeling, SQL Server development
Is it wise to store files such as .doc’s or .pdf’s as binary objects in a SQL Server database? If there can be issues down the line, is there a way to design the SQL database to make it easier to work with?
Answer Question | October 17, 2008 3:57 PM
SQL Server database, SQL Server database design and modeling
Can you please advise me on how to perform exploratory testing on a database using ERDs?
Answer Question | May 15, 2008 3:05 PM
Database testing, ERD (Entity Relationship Diagram), SQL Server database design and modeling
We have a SQL Server 2000 database that has never been reindexed. Do you have any suggestions? Is there a link to a step-by-step process for SQL Server database reindexeing you can share?
Answer Question | March 7, 2008 10:29 PM
SQL Server 2000, SQL Server database design and modeling