Viewing 15 posts - 106 through 120 (of 548 total)
Jeff, I was always under the impression that you are based somewhere in the New York area or at least the EDT time zone. Have you moved? Because there it...
November 16, 2012 at 12:53 am
Jeff Moden (11/16/2012)
... it was the only way I could teach myself how it would all work. :hehe:
Jeff, this is the first time I see someone use this...
November 16, 2012 at 12:38 am
They both start with J. He was close.:-)
November 15, 2012 at 11:21 am
mister.magoo (11/14/2012)
you can use
row_number() over (order by @@spid)
Yes, that's the one!
November 14, 2012 at 7:37 am
MM and Mark,
This is what I was looking for.
select top 1000 identity(int,1,1) as N
into dbo.HTally
from master.sys.all_columns ac1
cross join master.sys.all_columns ac2
But you would then have to do an update...
November 14, 2012 at 7:10 am
Jeff Moden (11/14/2012)I believe the question was actually about how to use the table from the article... not the HierarchyID.
Oops, you're right
November 14, 2012 at 1:56 am
jimbobmcgee (11/13/2012)
Michael Meierruth (11/13/2012)
What is this '(select null)' trick all about?
It's a trick to 'order' by constant value, i.e. to not order/sort at all; in this case it adds a...
November 14, 2012 at 1:41 am
Cyclone (11/14/2012)
Hi ...This may be a silly question, but how does one use the dbo.Hierarchy table ?
Thanks.
If you know absolutely nothing about HierarchyID this is a good place to start:...
November 14, 2012 at 1:26 am
Jeff,
In the code for generating the tally table, you use this syntax:
row_number() over (order by (select null))
I have never see this before. But it works. What is this '(select null)'...
November 13, 2012 at 2:56 pm
Paul Randal (11/8/2012)
Michael Meierruth (11/8/2012)
November 8, 2012 at 12:27 pm
Adam Seniuk (11/8/2012)
Michael Meierruth (11/8/2012)
There is something not right with your 'exec' statment with all those quotes and parenthesis. Can't quite grasp what it is.
But I definitely like this 'with...
November 8, 2012 at 11:17 am
Adam,
There is something not right with your 'exec' statment with all those quotes and parenthesis. Can't quite grasp what it is.
But I definitely like this 'with TABLERESULTS' clause. This definitely...
November 8, 2012 at 9:40 am
After reading your recent 'Importance of Validating Backups' and now this article on DBCC CHECKSUM, I'm very curious to know how much database corruption is really encountered in the real...
November 8, 2012 at 2:05 am
Paul Randal (9/28/2012)
Nothing...
September 29, 2012 at 12:54 am
rmechaber (9/28/2012)
Did you see my post on page 3 of the comments?Rich
Yes, it's 200 lines of code and comments (I like those!)
But I'm comparing 1 line of my code (a...
September 28, 2012 at 11:59 am
Viewing 15 posts - 106 through 120 (of 548 total)