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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 14, 2011 at 11:40 am
Have you checked out the logs?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 14, 2011 at 11:26 am
Please check out the following article:
http://support.microsoft.com/kb/937343
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 14, 2011 at 11:24 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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 2:05 pm
There a number of tools that can be used for optimization.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 10:06 am
Viewing 15 posts - 3,136 through 3,150 (of 3,738 total)