Viewing 15 posts - 2,386 through 2,400 (of 7,631 total)
manoj2001 (5/15/2009)
i want to ask you one question to all expertise who are using 2005 with CLR.
Is there any performance problem you are facing while using your SPs Functions...
[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]
May 15, 2009 at 6:00 am
Paul White (5/14/2009)
Bob Hovious (5/14/2009)
[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]
May 14, 2009 at 11:26 pm
fjmorales (5/14/2009)
I have this explanation for the counter % IDLE TIME from Steve Choy :
% IDLE TIME = This measures the percentage of time the disk was idle...
[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]
May 14, 2009 at 10:38 pm
bc (5/14/2009)
if question 1 has choices A B C D, then value them as 1 2 3 4 and do your calculations on the...
[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]
May 14, 2009 at 10:19 pm
Well one thing that jumped out at me right away was this:
Lee Hart (5/14/2009)
...'(
@Tech_Spec is null OR
@Tech_Spec = Tech_Spec
)AND
(
@Product_Category is NULL OR
@Product_Category = SMSSelectorGuide.[Product Category (Legacy)]
)AND
(
@nonCommissonFilter...
[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]
May 14, 2009 at 9:46 pm
Jeff Moden (5/4/2009)
Frank Carrelli (5/4/2009)
I found my issue that was causing my slow running queries. It appears the Coalesce statements...
How serendipitous... I've recently made that same discovery with doing things...
[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]
May 14, 2009 at 8:57 pm
If you have a *very* small number of constants and their speed is *really* important, then you could make a constant scan in a View or an inline Table-Valued function.
A...
[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]
May 14, 2009 at 8:53 pm
Malcolm Daughtree (5/14/2009)
[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]
May 14, 2009 at 7:58 pm
Actually, here's a method that will give you fairly "pseudorandom" SSNs, but always distinct:
Declare @P as Decimal(17)
Declare @s-2 as Decimal(17)
Select @P = 613452691, @s-2 = 1000000000
;WITH cteenroll as (
Select *
,...
[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]
May 14, 2009 at 3:07 pm
GSquared (5/14/2009)
RBarryYoung (5/14/2009)
...And you didn't get any duplicates? That's very suprising. Hmm, maybe my geusstimation is wrong...
Barry, this version can't have duplicates. It's a primary key. ...
[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]
May 14, 2009 at 2:38 pm
klnsuddu (5/14/2009)
What do you want to accomplish by adding more files? What other drives do you have available to you?
Because the content database size is 70 GB now and it...
[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]
May 14, 2009 at 2:29 pm
Heh. Nice...
[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]
May 14, 2009 at 2:27 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]
May 14, 2009 at 2:25 pm
GSquared (5/14/2009)
...
This will generate 5-million unique fake SSNs.
set nocount on;
create table #SSNs...
[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]
May 14, 2009 at 1:57 pm
Michael Valentine Jones (5/14/2009)
This will update your SSN column with 9 digit SSN numbers.
update MyTable
set
ssn = right(convert(bigint,convert(varbinary(7),newid())),9)
Michael: because you are truncating the ID to 9 digits, I do not think...
[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]
May 14, 2009 at 1:52 pm
Viewing 15 posts - 2,386 through 2,400 (of 7,631 total)