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 [...]
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 [...]
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 [...]
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 [...]
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
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?
Can you please advise me on how to perform exploratory testing on a database using ERDs?
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?





