Viewing 15 posts - 31 through 45 (of 163 total)
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...
August 7, 2008 at 6:51 am
I issue the following codes :
DECLARE @ExStr varchar(500)
SET @ExStr = 'CREATE TABLE dbo._X080805 (
[ICno] [int] NOT NULL DEFAULT (0),
[Xdate] [smalldatetime] NOT...
August 2, 2008 at 4:58 am
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...
July 31, 2008 at 11:32 am
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...
July 21, 2008 at 10:25 am
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...
April 29, 2008 at 3:17 am
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. ...
April 9, 2008 at 4:13 am
April 8, 2008 at 11:17 pm
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...
April 8, 2008 at 10:39 pm
From what I seen there is no problem having SQL server installed on c:, looks like this is the default and most common way.
Have you ever tried to get...
March 12, 2008 at 10:25 pm
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...
March 12, 2008 at 6:18 am
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...
March 11, 2008 at 8:30 am
Please read this article:
Specially check this step:
After adding the parameter "-T3608" did you re-start the server?
March 10, 2008 at 7:42 am
Additionally, if your query is not supported by a single non clustered index, there is a high possibility of book mark lookup.
March 10, 2008 at 7:35 am
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...
March 10, 2008 at 7:34 am
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 >=...
March 3, 2008 at 6:47 am