如何处理SQL Server 2008? [英] How to deal with SQL Server 2008?

问题描述

亲爱的朋友们！

我将使用SQL2008数据库在VB.Net中开发薪资应用程序. (以前，我已经使用MS Access数据库开发了两个Windows应用程序.)

现在，Plz指导我如何使用SQL2008数据库
1.为了缩短我的数据库文件大小(sod.mdf).
2.防止其大小随着时间的流逝而迅速增加.
3.使用此数据库有效地运行我的工资单应用程序

(注意:我也在数据库中插入该雇员的图像.)

如果还有其他与我的问题有关的问题，请联系我.

感谢您.

Dear Friends!

I am going to develop a Payroll Application in VB.Net using SQL2008 Database. (Previously I have developed two windows applications using MS Access Database.)

Now, Plz guide me that What should I do with SQL2008 Database
1. To keep my database file size (sod.mdf) shorter.
2. To stop its size from increasing rapidly with the passage of time.
3. To run my payroll application efficiently with this database

(Note: I am also inserting images of the employee in my database).

And if there are other issues related to my problem, plz also guide me about that.

I will be thankful to you.

推荐答案

谢谢您的提问.请遵循以下代码.

Thank you for your question. Follow the code bellow.

USE master;
GO
CREATE DATABASE Sales
ON PRIMARY
( NAME = SPri1_dat,
    FILENAME = 'D:\SalesData\SPri1dat.mdf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 15% ),
( NAME = SPri2_dat,
    FILENAME = 'D:\SalesData\SPri2dt.ndf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 15% ),
FILEGROUP SalesGroup1
( NAME = SGrp1Fi1_dat,
    FILENAME = 'D:\SalesData\SG1Fi1dt.ndf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 ),
( NAME = SGrp1Fi2_dat,
    FILENAME = 'D:\SalesData\SG1Fi2dt.ndf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 ),
FILEGROUP SalesGroup2
( NAME = SGrp2Fi1_dat,
    FILENAME = 'D:\SalesData\SG2Fi1dt.ndf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 ),
( NAME = SGrp2Fi2_dat,
    FILENAME = 'D:\SalesData\SG2Fi2dt.ndf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 )
LOG ON
( NAME = Sales_log,
    FILENAME = 'E:\SalesLog\salelog.ldf',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB ) ;
GO

您可以使用图像数据类型在数据库中存储图像.

有关更多信息，
http://msdn.microsoft.com/en-us/library/ms176061.aspx [ ^ ]


谢谢，
Mamun

You can use image data type for store image in database.

For more info,
http://msdn.microsoft.com/en-us/library/ms176061.aspx[^]


Thanks,
Mamun

嗨rashid，

请参考此链接.

http://hubpages.com/hub/Optimising_SQL_Server [

Hi rashid,

plese refer this link .

http://hubpages.com/hub/Optimising_SQL_Server[^]

这篇关于如何处理SQL Server 2008?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！