Viewing 15 posts - 2,386 through 2,400 (of 7,636 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...
May 15, 2009 at 6:00 am
Paul White (5/14/2009)
Bob Hovious (5/14/2009)
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...
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...
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...
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...
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...
May 14, 2009 at 8:53 pm
Malcolm Daughtree (5/14/2009)
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 *
,...
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. ...
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...
May 14, 2009 at 2:29 pm
GSquared (5/14/2009)
...
This will generate 5-million unique fake SSNs.
set nocount on;
create table #SSNs...
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...
May 14, 2009 at 1:52 pm
Viewing 15 posts - 2,386 through 2,400 (of 7,636 total)