urgent - sql table does not work any more as i tshould
Hello,
I added a column to a table in sql 2014. After it I am only able to get limited number of rows when I select from it and it takes a long time.
Is there a way to fix the table. I appreciate your help - it is very urgent to fix this.
Greetings,
I added a column to a table in sql 2014. After it I am only able to get limited number of rows when I select from it and it takes a long time.
Is there a way to fix the table. I appreciate your help - it is very urgent to fix this.
Greetings,
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
There's not enough information here to answer your question.
Explain 'I am only able to get a limited number of rows when I select from it, and do us a favor and right-click: Script out the 'Create Table' for all table(s) involved and paste into this question.
Explain 'I am only able to get a limited number of rows when I select from it, and do us a favor and right-click: Script out the 'Create Table' for all table(s) involved and paste into this question.
I get 1500 rows in 00:00:00 seconds when I select top 1500 rows like this
select top 1500 * from MyTable
If I search for 1540 top rows
select top 1540 * from MyTable it runs for 10 seconds before I stop it.
It returns 1500 rows right away but after that no more.
I have been using this table for a long time and never had a problem with it until now.
select top 1500 * from MyTable
If I search for 1540 top rows
select top 1540 * from MyTable it runs for 10 seconds before I stop it.
It returns 1500 rows right away but after that no more.
I have been using this table for a long time and never had a problem with it until now.
Here is the table
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MyTable](
[MyId] [int] IDENTITY(1,1) NOT NULL,
[MyText] [varchar](max) NULL,
[PId] [int] NULL,
[YearId] [int] NULL,
[DateCreated] [datetime] NULL,
[CreatedBy] [int] NULL,
[Shortname] [varchar](10) NULL,
CONSTRAINT [PK_s_Class] PRIMARY KEY CLUSTERED
(
[MyId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MyTable] WITH CHECK ADD CONSTRAINT [FK_MyTable_s_Payer] FOREIGN KEY([PId])
REFERENCES [dbo].[s_Payer] ([PId])
GO
ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [FK_MyTable_s_Payer]
GO
EXEC sys.sp_addextendedproperty
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MyTable](
[MyId] [int] IDENTITY(1,1) NOT NULL,
[MyText] [varchar](max) NULL,
[PId] [int] NULL,
[YearId] [int] NULL,
[DateCreated] [datetime] NULL,
[CreatedBy] [int] NULL,
[Shortname] [varchar](10) NULL,
CONSTRAINT [PK_s_Class] PRIMARY KEY CLUSTERED
(
[MyId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MyTable] WITH CHECK ADD CONSTRAINT [FK_MyTable_s_Payer] FOREIGN KEY([PId])
REFERENCES [dbo].[s_Payer] ([PId])
GO
ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [FK_MyTable_s_Payer]
GO
EXEC sys.sp_addextendedproperty
GO
Premium Content
You need an Expert Office subscription to comment.Start Free Trial