Viewing 15 posts - 6,481 through 6,495 (of 7,631 total)
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
Ken Simmons (6/24/2008)
DROP DATABASE FILEIF NO BACKUP TO RESTORE
BEGIN TO DENY
ROFL! :laugh:
Beautiful, Ken.
[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 6:57 am
The other thing that I would suggest for building Clustered Keys on big tables like this is to make sure that you MDF, LDF and TempDB's are all on seperate...
[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 24, 2008 at 12:50 pm
This is large for a clustered key, I suggest that you find a smaller one (on none at all as previously suggested). ReOrdering 12M rows will take a while.
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]
June 24, 2008 at 12:48 pm
You don't need the DISTINCT for an IN(..), and you can make the update_date test's more sarg-able:
SELECT user_key AS User_id, update_date AS createDate
FROM accounting.dbo.user
WHERE user_key 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]
June 24, 2008 at 12:41 pm
Let us know how it works out. 🙂
[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 24, 2008 at 12:27 pm
Viewing 15 posts - 6,481 through 6,495 (of 7,631 total)