Viewing 15 posts - 31 through 45 (of 97 total)
Ninja's_RGR'us (10/18/2011)
Just a reminder of the goal of the OP. You guys were not supposed to play with the qry at all! 😀Query Optimization using Indexes
Ha ha, good...
October 18, 2011 at 6:24 am
adlakha.22 (10/18/2011)
Ordernumber is also unique key in both the tables,
and i have also try to join the qry on the basees of cono,ordersuf,orderno that are the primary keys,
but still it...
October 18, 2011 at 5:02 am
ChrisM@Work (10/18/2011)
frfernan (10/18/2011)
... But you can join both tables trough the primary keys...Can you please show what you mean?
Yes of course, seeing the table definitions I suppose that the "natural...
October 18, 2011 at 4:10 am
Hello adlakha.22,
there are some things I don't understand seeing your query and your data structure, let me explain:
You manage two tables, orders and orderlines. I suppose there are a hierarchical...
October 18, 2011 at 3:18 am
Hello,
I think you must start trying to know the reason for this error message, "cannot read next data row for the data set.conversion failed when converting character string to smalldatetime...
October 14, 2011 at 8:19 am
Hello,
you know what timetable is planned ad what timetable is worked. You want to know the amount of time planned but not worked or worked but not planned, right?, you...
October 13, 2011 at 2:39 am
Hello,
Exactly what I said. There is no need at all for any form of index to do paging. It may be helped with an index (performance-wise), you don't need one...
October 3, 2011 at 3:14 am
Hello,
GilaMonster (9/30/2011)
frfernan (9/30/2011)
September 30, 2011 at 8:22 am
Now I executed a small test against a table:
CREATE TABLE [dbo].[TASKS](
[TaskCode] [int] NOT NULL,
[TypeCode] [smallint] NOT NULL,
[Description] [varchar](max) NULL,
CONSTRAINT [TASKS_PK] PRIMARY KEY CLUSTERED
(
[TaskCode] ASC
)WITH (PAD_INDEX = OFF,...
September 30, 2011 at 3:57 am
Hello all,
in an OLTP system, when you create an index to show data on the screen in an ordered fashion, you will need an unique index to properly scroll up...
September 30, 2011 at 2:48 am
I usually try to avoid non-unique indexes, adding the primary key after the key fields; in this case, an index (Col2, Col3, RID) has sense for me. It is a...
September 29, 2011 at 1:33 am
Hello,
try it:
DECLARE @tmp_server TABLE (servername Varchar(10))
INSERT INTO @tmp_server
SELECT 'a' UNION SELECT 'b' UNION SELECT 'c' UNION
SELECT 'd' UNION SELECT 'e' UNION SELECT 'f'
DECLARE @server_out AS VARCHAR(100)
SET @server_out =...
September 21, 2011 at 2:07 am
Hi,
SELECT COUNT(*) is usually bad if you will simply test if some records exists, better if you use the EXISTS instruction, in your original function or in a new adhoc...
September 15, 2011 at 6:15 am
Maybe yo can replace these null values by some not null string. I tried replacing
WITH OrderedAddresses AS (
SELECT RecNum, RecInd, Address1, DateApplied
, ROW_NUMBER() OVER (PARTITION BY RecNum, RecInd ORDER BY...
September 13, 2011 at 4:19 am
Viewing 15 posts - 31 through 45 (of 97 total)