Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,351 through 22,365 (of 59,098 total)

RE: Types don't match between the anchor and the recursive part in column "Hierarchy" of recursive query

BTW, although this is kind of a "set based" recursive CTE (rCTE from here on) because it processes a whole level in the hierarchy at a time, rCTEs can be...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2014 at 8:54 am

#1761515
RE: Types don't match between the anchor and the recursive part in column "Hierarchy" of recursive query

peterausger (11/29/2014)
Dear all
Following is my db table
student_id student_code student_parent_id student_name
1 11 NULL a
2 111 1 b
3 1111 2 c
4 11111 3 d
I want to generate following op
student_id ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2014 at 8:37 am

#1761513
RE: How to free up the drive space in SQL that has data files

A 1 TB 15k-RPM drive costs less than $300 for a SAN drive. For a local drive, you can get one for about $70. You've probably already spent...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 8:57 pm

#1761496
RE: trying to find a more efficent way

Take a look at the first link under "Helpful Links" in my signature line below. For this one, we're going to need to know the actual table structure is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 7:48 pm

#1761494
RE: Query to show table Products with its modes

It won't be slow if you avoid the self join of the CTE, which causes it to go through both tables twice. This will work almost as fast as...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 7:38 pm

#1761493
RE: tsql with out using cursors

stook (11/28/2014)
if the cursor is not working then try the insensitive cursor. Without cursor - you mean something like this?
declare @dbname nvarchar(255)='', @found bit=1
while @found=1 begin
set @found=0
select top 1...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 5:35 pm

#1761490
RE: Please vote for the "built in Tally Table" function.

P.S. Personally, I don't care if ANSI, ISO, INCITS, or any other organization agrees or not. Sometimes you have to first build the tool before you try to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 5:32 pm

#1761489
RE: Please vote for the "built in Tally Table" function.

CELKO (11/28/2014)
I have mixed feeling on this. It sounds like a schema level table constant with contiguous exact numeric values. Nobody can change a constant. Why would it start at...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 5:25 pm

#1761488
RE: sql server cpu schedulers

You might also want to look into Trace Flags 1117 and 1118.
http://www.brentozar.com/archive/2014/06/trace-flags-1117-1118-tempdb-configuration/
http://www.sqlskills.com/blogs/paul/misconceptions-around-tf-1118/
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 1:01 pm

#1761484
RE: Are the posted questions getting worse?

TomThomson (11/28/2014)
Divine Flame (11/26/2014)
Voted. 153 now.
Now 167.
Needs quite a few more vote, I think.
Agreed. I'll try to submit an "editorial" for inclusion on the front page for sometime next...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 12:35 pm

#1761482
RE: Please vote for the "built in Tally Table" function.

TomThomson (11/28/2014)
voted.
It's now 167. Not growing fast enough.
Agreed. I'll write up an "editorial" and see if we can get it published next week.
Keep up the great work folks....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2014 at 11:57 am

#1761480
RE: Point in time restores referencing copy-only backups?

slimchance99 (11/27/2014)
The reason is that the daily copy-only backups are performed at the data centre onto their backup media as part of the enterprise DR plan. If we have to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 27, 2014 at 1:37 pm

#1761348
RE: Release

river1 (11/27/2014)
When will SQL Server 2014 will be released to be installed in production.
I mean, when will I have a version that I can trust to put in production?
Thanks
Never. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 27, 2014 at 1:17 pm

#1761345
RE: Point in time restores referencing copy-only backups?

slimchance99 (11/25/2014)
On one of our SQL Server 2014 boxes each database has a copy-only full backup made every night, in addition to the maintenance plan schedule of a full backup...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 27, 2014 at 1:08 pm

#1761344
RE: Thanksgiving 2014

Heh... "Happy Bird Day" Steve!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 26, 2014 at 8:59 pm

#1761196

Viewing 15 posts - 22,351 through 22,365 (of 59,098 total)