You can write a scheduled job which inserts the data of the database file sizes into a table. Schedule the job to work every month or what ever the...

edward (8/2/2008)

---

Sorry to tell you it can't work.... :crying:

I issue the following codes :

DECLARE @ExStr varchar(500)

SET @ExStr = 'CREATE TABLE dbo._X080805 (

[ICno] [int] NOT NULL DEFAULT (0),

[Xdate] [smalldatetime] NOT...

Rebuilding an index means dropping and recreating the index.

You can truncate the tables using Truncate table

You dont have to shrink the database and it will grow anyway when...

Do you have SSIS packages stored in the database?

What about the scheduled jobs?

Do you have replication in that server?

You may have to take a backup of MSDB and restore it...

Hi,

Your post is quite unclear on the details.

It looks like you haven't desinged the database yet. IF so, give the requirements clearly.

If you have done the...

I actually put the common stored procedures into master. I have not tried with UDF. One of the reason is you need to refer them as master.dbo. ...

Try this:

http://support.microsoft.com/kb/914157

I have created some of the common stored procedures (mainly related to Administration) in master. I have also used the prefix sp_ for them. It is stored ina...

Have you ever tried to get...

I have installed SQL Server and the data files in C Drive in the past, and no at least one reason for it.

Windows has its own temp files and page...

You can do through Enterprise Manager too. I have done that.

BTW, while moving system databases, detach and attach one database at a time. (Or atleast do in the...

Please read this article:

http://www.sqlservercentral.com/articles/Administering/movingsystemdatabasesachecklist/1608/

Specially check this step:

After adding the parameter "-T3608" did you re-start the server?

Additionally, if your query is not supported by a single non clustered index, there is a high possibility of book mark lookup.

Can you submit the query and table structure (with indeces)?

Also note that the execution plans may vary based on the load. If your indexes are statistics are up...

In addition to others mentioned,

Specially on the month issue,

If you know the years of data stored within the table and if it is only few, You can use >=...