Viewing 15 posts - 3,136 through 3,150 (of 3,738 total)
Why do you have a dbo.Process_Volumes and a new dbo.New_Process_Volumes Tables?
As a personal preference I would not name the PK column Pkey.
Is may be a remote chance that the combination...
May 14, 2011 at 11:40 am
invaliddba (5/14/2011)
In the below statement , why does primary needs to be enclosed in square brackets.?ALTER DATABASE Employee
MODIFY FILEGROUP [PRIMARY] --- why are the square brackets needed here?
DEFAULT
Because PRIMARY is...
May 14, 2011 at 11:13 am
prashantcomp90 (5/9/2011)
I am working on sql2005 and I want to create view for one table.
Table details :
table name : groups
feilds:
groupnm
debit
credit
and etc.
I want to create view with these three columns....
May 13, 2011 at 9:29 pm
There are a lot of tools but it takes a little more than that.
I have listed two tools that may be helpful but it will not be enough but hopefully...
May 13, 2011 at 2:05 pm
There a number of tools that can be used for optimization.
May 13, 2011 at 1:50 pm
Second thought the links that I provided you do not address the probable cause of your applications performance issue.
You should probably focus on the execution plan, etc,
Could you provide additional...
May 13, 2011 at 12:35 pm
You can not back up a page so you are going to have to stick with the current backup strategy.
May 13, 2011 at 12:29 pm
The Microsoft Jet database engine cannot open the file '\\mi-uk-fb-02\uw$\Property Division\Property Aggregates.mdb'. It is already opened exclusively by another user, or you need permission to view its data.".
Go to \mi-uk-fb-02\uw$\Property...
May 13, 2011 at 11:40 am
You may want to provide the Scripts for the Tables and indexes etc.
Does the report run slow consistently? Are there any other processes that are interfering with the Report?
How many...
May 13, 2011 at 11:25 am
Update from SP1 to SP4. This will not effect the existing data but you should perform in DEV & QA as well as perform UAT.
http://support.microsoft.com/kb/913089
Does SP4 correct the problem?
Need additional...
May 13, 2011 at 11:08 am
You are missing column(s) to create a Primary Key on your Vault Table.
You should have a PK on each table.
Also you should define the PartNo as an Index.
May 13, 2011 at 10:31 am
Some additional information is listed in the following article:
http://www.sqlinfo.net/sqlserver/sql_server_Alter_Add_column.php
May 13, 2011 at 10:20 am
steve.anderson 7639 (5/13/2011)
Is there a way to change the data type without having to drop and recreate tables?
You need to do this in a development environemnt. Watch out for truncated...
May 13, 2011 at 10:06 am
Viewing 15 posts - 3,136 through 3,150 (of 3,738 total)