Viewing 15 posts - 16 through 30 (of 417 total)
Again, tnx for answering.
That sounds familiar, but there was more to it. We had a set of test scripts for measuring the performance. Basically you could turn all options ON...
September 29, 2011 at 1:45 am
Tnx for answering.
I have performance issues and the cursors are not going away real soon. They are build in the communication layer of a commercial 3rd party software. I have...
September 27, 2011 at 6:03 am
Tnx for answering all.
You are right: under advanced options you can change the destination of database files. It has been a while for me as well since last I installed...
September 16, 2011 at 12:15 am
Colx has about 11000 unique values on several million rows.
On being disabled, I don't know, I'll have to check that. Never thought of that.
September 3, 2011 at 2:27 am
OK, the real thing:
/****** Object: Index [$13] Script Date: 08/30/2011 08:54:40 ******/
CREATE UNIQUE NONCLUSTERED INDEX [$13] ON [dbo].[ABX$Item]
(
[EAN-Code] ASC,
[No_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...
August 30, 2011 at 12:57 am
OK, here comes:
/****** Object: Index [$13] Script Date: 08/29/2011 14:05:06 ******/
CREATE UNIQUE NONCLUSTERED INDEX [$13] ON [dbo].[Table1]
(
[Colx] ASC,
[Coly] ASC
)WITH
(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...
August 29, 2011 at 6:17 am
So, the use of PERCENT is the problem? That's the only difference I notice...
Tnx for the heads-up all. I rarely use view design, but I was lazy this time...
August 26, 2011 at 2:51 am
Tnx, this sure is helpful. I wonder though if this is the Real Thing. As I recall this database was designed and build by a private person and had it's...
August 26, 2011 at 2:44 am
Use of the index on a varchar will not be (much) slower, other things may be taken into consideration, like maintenance overhead, updates and deletes, diskspace and such. Here is...
August 23, 2011 at 3:38 am
Tnx for answering all. I do find it peculiar, that in DESIGN mode the BY ORDER clause is working.
Oh well.
August 23, 2011 at 2:51 am
I think most modelling tools can do this. I have worked with ERStudio from Embarcadero and PowerDesigner from Sybase, both can reverse engineer, though it sometimes comes with weird solutions.
However,...
August 11, 2011 at 5:21 am
You are right, I was thinking of an attach-statement, has no truck here.
Anyways, 2 of the 3 offending databases have been succesfully restored, I will try the 3rd tonight,it's a...
August 9, 2011 at 6:59 am
Tnx for answering all.
The number of files are the same for all DB's, 1 .MDF and 1 .LDF.
The logical names are the same on PROD(source) and TST(target). Location is different,...
August 9, 2011 at 5:41 am
Right!
Tnx a lot.
September 20, 2010 at 3:57 am
Viewing 15 posts - 16 through 30 (of 417 total)