Viewing 15 posts - 5,686 through 5,700 (of 7,631 total)
karthikeyan (8/29/2008)
I got it...:) Yes,Just i turn off the below one.set arithabort off
is it a wise decision ?
I'll have to check, but I don't think that you should hav...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 29, 2008 at 6:37 am
OK, this should correct thos errors:
declare @sql varchar(8000)
Declare @DB_Objects varchar(8000)
Select @DB_Objects = ' name COLLATE DATABASE_DEFAULT as [Name], uid, status, sid, createdate, updatedate
From %D%.dbo.sysusers
'
Select @sql = 'SELECT * FROM
(Select '+Cast(dbid...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 10:33 pm
Include VALUE in the index _dta_index_QUESTION_RESPONSES_T_8_1557580587__K5_K4 as a covered column:
DROP INDEX [_dta_index_QUESTION_RESPONSES_T_8_1557580587__K5_K4] ON [dbo].[QUESTION_RESPONSES_T]
GO
CREATE NONCLUSTERED INDEX [_dta_index_QUESTION_RESPONSES_T_8_1557580587__K5_K4] ON [dbo].[QUESTION_RESPONSES_T]
([SURVEY_RESP_ID0] ASC,[Q_ID0] ASC)
INCLUDE (VALUE)
WITH (DROP_EXISTING=ON, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 10:27 pm
Try this:
declare @sql varchar(8000)
Declare @DB_Objects varchar(8000)
Select @DB_Objects = ' name COLLATE DATABASE_DEFAULT as [Name], uid, status, sid, createdate, updatedate
From %D%.dbo.sysusers
'
Select @sql = 'SELECT * FROM
(Select '+Cast(dbid as varchar(9))+' as DBID,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 8:50 pm
Let us know if you need anything else, Helmut.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 8:32 pm
Jeff Moden (8/28/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 8:27 pm
Actually, I probably only need the definition, keys and indexes for [question_responses_t].
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 8:19 pm
OK, there's nothing obvious in the execution plan. We'll need to see the table definitions including the keys and indexes.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 7:47 pm
This is a corrupted execution plan file. Please re-save it as a *.sqlplan file and attach it to a reply.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 6:55 pm
Yes, but what defines the Order?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 6:26 pm
grtn316 (8/28/2008)
But if the rows were wider and there were less tables involved, I would lower required disk space but I would be sacrificing performance? Correct?
No. The issue is...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 6:18 pm
Cliff notes: Is it complicated/impossible to load 80gig files with 8 columns of float(decimal) data into SQL Server?
That depends almost entirely on the nature, structure and format of the file....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 4:16 pm
There are 586 tables listed in your Excel file. Which are the 30 that you want to move?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 3:59 pm
I am not sure that I would want to retain the personal Views of expired or departed users. If they have production value they should not have been personally...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 3:27 pm
I am just saying, I do not see where a Tally table comes in? The query that I already posted works fine without it. And I am not...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 3:16 pm
Viewing 15 posts - 5,686 through 5,700 (of 7,631 total)