Viewing 15 posts - 39,811 through 39,825 (of 49,571 total)
Alvin Ramard (4/12/2009)
Being a contractor, that would be without pay too
Same here. It comes out of my 'education and training' savings.
If you're paying your own way, ignore the conference hotels....
April 12, 2009 at 8:39 am
Another option if you're using Enterprise edition is to drop the idea of multiple tables and consider partitioned tables.
April 12, 2009 at 8:37 am
You can't install the server components of Enterprise edition on a non-server OS. Basically, to install the server components of SQL Enterprise edition, you need Windows Server 2003 or Windows...
April 12, 2009 at 8:35 am
I suspect the cluster vs heap discrepancy is more the result of a lot of bad and missing indexes.
It would really help if you could post the actual execution plan....
April 12, 2009 at 4:42 am
peleg k (4/12/2009)
Select * from Messag2008+@MonthName
but withought using a dynamic query which will be activated...
April 12, 2009 at 4:00 am
Jack Corbett (4/11/2009)
So am I. The nice thing is I'm not expecting to be selected so I feel no pressure.
I'm hoping they'll accept one of mine. Firstly because I...
April 12, 2009 at 2:27 am
What operating system?
What edition of SQL were you installing?
April 12, 2009 at 2:14 am
Wish (4/12/2009)
I read many post suggesting to avoid cursor as it degrade the performance. But I am confised why cursor is slower.
Because cursors are iterative, row-by row operations....
April 12, 2009 at 2:10 am
Please post new questions in a new thread and include as much detail as possible, including any errors that you get as well as the stack dump, what causes the...
April 12, 2009 at 1:43 am
Bob Hovious (4/11/2009)
April 11, 2009 at 11:43 am
Bob Hovious (4/11/2009)
I was thinking about the LIKE solution earlier, but that would make the join be
INNER JOIN T2 ON LongCode like ShortCode+'%'
Yup.
Doesn't the ShortCode+'%' expression create the same problem...
April 11, 2009 at 11:37 am
Jeff Moden (4/11/2009)
I saw that Gail and Jack also made submittals.
Grant also. He was a real early-bird and submitted before I'd even decided on titles.
April 11, 2009 at 11:10 am
Post the exec plan for each please.
While a heap is occasionally beneficial, in most cases it's better for a table to have a cluster. There's probably a missing index or...
April 11, 2009 at 11:07 am
Florian Reischl (4/11/2009)
DECLARE @i INT
SET @i = 1
START:
PRINT...
April 11, 2009 at 10:52 am
like this:
CREATE TABLE [dbo].[test6](
[callerid] [char](5) NOT NULL,
[name] [varchar](50) NULL,
[address] [varchar](50) NULL,
[recordnum] [int] IDENTITY(1,1) NOT NULL
primary key NONCLUSTERED ( callerid)
) ON [PRIMARY]
GO
April 11, 2009 at 10:39 am
Viewing 15 posts - 39,811 through 39,825 (of 49,571 total)