SQL database design
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
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

Pulling rows from SQL Server and loading the data into column textboxes
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

What type of Raid to use on Windows Servers and tempdbs?
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

Column extention
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

Storing general files in a SQL Server database
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

How to perform exploratory database testing using ERDs
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

How can we reindex a SQL Server 2000 database?
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