Viewing 15 posts - 6,481 through 6,495 (of 7,636 total)
ggraber (6/26/2008)
I thought the actual example would take too long to explain.
Does anyone have any suggestions of how...
[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]
June 26, 2008 at 9:32 pm
Here is a vesion without any Cursors:
create proc spVB_Make_Class as
--from Lambert Antonio, 26-jun-2008
Set NoCount ON
declare @field table (id int identity primary key clustered, fieldname varchar(50), fieldtype varchar(50))
declare @table_name varchar(50)
set @table_name...
[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]
June 26, 2008 at 8:58 pm
Make a common library that you can call both from your SQLCLR wrapper and from VB.net.
[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]
June 26, 2008 at 7:49 pm
Why would you want to do it this way? Why not just write records into one table?
[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]
June 26, 2008 at 7:35 pm
Sorry, I missed that there were two columns returned...
As for why it is faster, this is an Inline Table-Valued-Function. They are special in that they do not have procedural...
[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]
June 26, 2008 at 4:16 pm
This server is still pegged, just not as badly as before. If you look at the charts you will see that it swings from being CPU-saturated, to being Disk-saturated...
[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]
June 26, 2008 at 3:53 pm
smunson (6/26/2008)
BEGIN TO COMMIT
WHEN RECEIVE DUMP
THEN END CONVERSATION
Kind of silly, but I got a laugh out of it...
especially when I considered how RELATIONAL it is :w00t::D:P:hehe:
Steve
(aka...
[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]
June 26, 2008 at 9:14 am
Catalin Enescu (6/26/2008)
Jeff Moden (6/26/2008)
Alright... you need to tell us why you say that... useless for what?nolock hint on select statement
according to BOL :"This is the default for SELECT operations"
Could...
[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]
June 26, 2008 at 9:11 am
mithun gite (6/26/2008)
Respected Mr. Gail shaw & RBarryYoung, ...
Gail is probably too polite to point it out, but I think that you meant to say "Ms. Gail Shaw".
[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]
June 26, 2008 at 8:34 am
Try replacing your function with this one, in the query:
CREATE FUNCTION [dbo].[FN_SplitCommaInClause_N]
(
@ItemList NVARCHAR(4000),
@delimiter CHAR(1))
Returns TABLE
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]
June 26, 2008 at 7:55 am
markl (6/25/2008)
example 1 - SLOW on 64 bitdeclare @ParamaterList varchar(1000)
set @ParamaterList='6507'
select distinct Column1, column2
from MyTable
where
Paramater in (Select convert(nvarchar,Value) from dbo.FN_SplitCommaInClause(@ParamaterList,','))
or
@ParamaterList=''
This query looks like it is part of a larger procedure...
[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]
June 26, 2008 at 7:32 am
thanks. no clues there, unfortunately. I suspect that it has something to do with the function; can you post its listing?
Also, if you select directly from your paramaters...
[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]
June 25, 2008 at 7:36 pm
Can you attach the different query plans, in xml format?
[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]
June 25, 2008 at 5:02 pm
What is the format of the file to load? If you control that, then you make it compatible with BULK INSERT and its easy. Otherwise, it is probably...
[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]
June 25, 2008 at 10:19 am
Well, I am not that familiar with SyBase, but are you getting any error messages?
[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]
June 25, 2008 at 7:09 am
Viewing 15 posts - 6,481 through 6,495 (of 7,636 total)