Viewing 15 posts - 3,691 through 3,705 (of 7,631 total)
OK, fair enough.
First, the ORDER BY is giving an error because you cannot put it there. In fact, it cannot be applied (directly) to the output of a script...
[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]
January 31, 2009 at 12:34 am
Well this is easy enough to fix, but it sure does sound like homework. Could you please tell us what the business purpose of this query is? I...
[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]
January 30, 2009 at 4:25 pm
shnex (1/30/2009)
SQLDMO works with SQL Server 2005? that's the question:)
I understand from what you say that sqldmo works with named instances in 2000. Maybe it works with 2005...
[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]
January 30, 2009 at 3:52 pm
You probably have both 2000 and 2005 on your local system. Named instances were new with SQL Server 2000 & DMO and they do not handle named instances as...
[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]
January 30, 2009 at 3:32 pm
Glad I could help.
[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]
January 30, 2009 at 3:27 pm
This should do the same thing and probably will perform better:
SELECT PART.ID AS PART_ID, UDFCURRENT.STRING_VAL AS [Description]
FROM PART
LEFT OUTER JOIN USER_DEF_FIELDS UDF ON PART.ID...
[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]
January 30, 2009 at 3:25 pm
Well first of all, when you OUTER JOIN tables, you should not put conditions for the Nullable table into the WHERE clause (unless that include a test for NULL), because...
[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]
January 30, 2009 at 3:20 pm
shnex (1/30/2009)
I see everywhere that is for SQL Server 2000, but I'm using it for 2005.
It can see may server and my SQL Server 2000 databases.
Is there...
[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]
January 30, 2009 at 3:07 pm
Please post the code that you are using.
[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]
January 30, 2009 at 3:05 pm
Suresh B. (1/29/2009)
The actual code could be some thing like this:
declare @query nvarchar(4000)
select @query = 'SELECT ColumnName FROM tbl_TableName WHERE...
[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]
January 30, 2009 at 12:43 pm
shnex (1/30/2009)
Could you give me a link, pls?
SMO is documented in BOL.
If you want a code example of how to do this with SMO, see here: http://www.sqlservercentral.com/Forums/Topic494616-386-1.aspx#bm494720
[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]
January 30, 2009 at 11:14 am
Lynn Pettis (1/30/2009)
RBarryYoung (1/30/2009)
Steve Jones - Editor (1/30/2009)
The Beverly Hills Chihuahua was a long two hours out of my life.
OMG, you poor SOB! :crazy: I am sure that I...
[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]
January 30, 2009 at 10:16 am
Steve Jones - Editor (1/30/2009)
I definitely prefer things exploding in my movies, so I'll be looking for some of those.
Tropic Thunder. Plenty of explosions...
[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]
January 30, 2009 at 10:11 am
Steve Jones - Editor (1/30/2009)
The Beverly Hills Chihuahua was a long two hours out of my life.
OMG, you poor SOB! :crazy: I am sure that I would have chewed...
[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]
January 30, 2009 at 10:07 am
OK, if vwMatch_Base really is a table, then you might try applying a Clustered Index with the following columns:
Surname, PostCode, Firstname, YearMonth, YearDay
[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]
January 30, 2009 at 10:03 am
Viewing 15 posts - 3,691 through 3,705 (of 7,631 total)