Viewing 15 posts - 26,461 through 26,475 (of 59,102 total)
Please post the link that you mentioned so others can see what you have seen. Thanks.
If you want to generate a million rows of sample data using those ratios,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2013 at 8:44 pm
Test Code...
DECLARE @BitBucket BIGINT
SET STATISTICS TIME,IO ON
SELECT TOP 1000000 @BitBucket=ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
FROM sys.all_columns ac1, sys.all_columns ac2;
SELECT TOP 1000000 @BitBucket=ROW_NUMBER() OVER (ORDER BY (SELECT 0))
FROM sys.all_columns ac1, sys.all_columns...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2013 at 8:15 pm
It wasn't an article. It was a post on the Running Total article and Tom updated it with a slightly different take on the check. Tom's post with...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2013 at 7:49 pm
smarinova (7/9/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2013 at 5:22 pm
izhar-azati (7/9/2013)
Why not to use CLR aggregate function that you can download from:Izhar Azati
Mostly because I'm not going to download and install a .msi file from the internet from an...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2013 at 5:15 pm
dwain.c (7/8/2013)
In that case,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2013 at 7:44 am
Adi Cohn-120898 (7/8/2013)
Pleas check out the code bellow:
declare @tbl table (i int)
declare @i int
insert into @tbl (i) values (1)
update @tbl
set @i = i, i = 2
select @i as varible,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2013 at 2:39 pm
L' Eomot Inversé (7/7/2013)
jasona.work (7/5/2013)
Koen Verbeeck (7/5/2013)
jasona.work (7/5/2013)
I could've driven...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2013 at 12:37 pm
GilaMonster (7/6/2013)
Jeff Moden (7/6/2013)
If there is no unique clustered index, then an 8 byte "uniquefier" is also added to the index.
Not quite
If there's no clustered index, the 8-byte RID...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2013 at 11:12 pm
I agree with the others... it's way too skinny (about 1/3 the width of any of my screens) and it causes way too much scrolling.
I have to admit that I...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2013 at 11:34 am
GilaMonster (7/6/2013)
Jeff Moden (7/6/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2013 at 10:57 am
Sean Grebey (7/2/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2013 at 10:28 am
Banana-823045 (7/6/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2013 at 9:39 am
dwain.c (7/6/2013)
Jeff Moden (7/5/2013)
dwain.c (7/4/2013)
What in Buddha's name is a "lac day?""lac" is 100,000 in the OP's language.
Oh, I get it! It can be used like a productivity measure:
SLOC/lac-days
😛
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2013 at 8:37 am
masoudk1990 (7/5/2013)
I changed my Stored Procedure to this:
DECLARE @MyString NVARCHAR(3);
SELECT CASE
WHEN 1 = 1
...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2013 at 5:52 pm
Viewing 15 posts - 26,461 through 26,475 (of 59,102 total)