Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,731 through 23,745 (of 59,102 total)

RE: problem in logic for finding a Recursive Cte

Eirikur Eiriksson (5/4/2014)
thava (5/3/2014)
hi,
hope everybody doing good,
here is my problem this is my data
The problem is in the data, each node can only have one parent!
😎
For classic...
--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)

May 4, 2014 at 7:40 pm

#1710610
RE: Backup questions for 612GB database!

GilaMonster (5/4/2014)
Jeff Moden (5/3/2014)
if you use the COPY ONLY option on the NUL backup tests, the test won't interfere with the Point-In-Time backups.
You mean they won't interfere with differentials 🙂
I...
--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)

May 4, 2014 at 7:22 pm

#1710609
RE: First SQl job were you nervous?

thomashohner (5/4/2014)
Do you use a While Loop or Recursive CTE to make your test data?
Niether, I spent this time researching how to do this and stumbled on a article by...
--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)

May 4, 2014 at 6:59 pm

#1710607
RE: First SQl job were you nervous?

thomashohner (5/4/2014)
On the million record test data... I know what I'm doing today:-D
Do you use a While Loop or Recursive CTE to make your test data?
Thanks so much for your...
--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)

May 4, 2014 at 12:23 pm

#1710582
RE: First SQl job were you nervous?

If you're nervous about living up to expectations, then you're well on your way to being one of the "big boys". Keep reading about SQL Server. If you...
--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)

May 4, 2014 at 12:02 am

#1710553
RE: DBA Dreams

Jim P. (5/1/2014)
Yet Another DBA (5/1/2014)
I have interviewed people for DBA positions and have had them not knowing what a null is/ biggest query they have ever written being 25...
--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)

May 3, 2014 at 11:49 pm

#1710552
RE: Database and its Objects Naming Standards

Sean Lange (4/30/2014)
Jeremy Brown (4/30/2014)
Honestly I don't feel as strongly one way or another. Fine, you want the object name first, go for it. You want the behavior...
--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)

May 3, 2014 at 11:21 pm

#1710551
RE: Backup questions for 612GB database!

BTW and I'm sure that someone else already thought about it and just hasn't posted it, yet... if you use the COPY ONLY option on the NUL backup tests, the...
--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)

May 3, 2014 at 5:07 pm

#1710546
RE: Backup questions for 612GB database!

Thanks Gail. That's a pretty cool thing then. Hat's off to whomever came up with it.
Shifting gears, we're working with a database that's only about 310GB... if nothing...
--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)

May 3, 2014 at 4:58 pm

#1710545
RE: Backup questions for 612GB database!

Andrew G (4/30/2014)
I agree with Gail, you should be backing up to a separate disk or raid group/set of spindles, disable SQL backup compression, then use Backup Exec 2012 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)

May 3, 2014 at 4:03 pm

#1710543
RE: Hash Match

I think a much better question would be, "What determines what will be the first (top) table (according to books online) in a hash match join"? 😉
--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)

May 3, 2014 at 1:32 pm

#1710541
RE: Get the hierarchy orders(top to bottom) of the table

yuvipoy (4/8/2014)
Jeff Moden (4/5/2014)
The easiest way would be to open the tables in the design mode of SSMS and look at the FK's.
This will give about the sigle relationship, i...
--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)

May 3, 2014 at 7:11 am

#1710522
RE: How to centralize your SQL Server Event Logs.

lsatchell (5/1/2014)
This article was the subjectline feature article 2nd May 2014 SQLServerCentral e-mail newsletter.
Come on guys, a circa 2010 solution featuring a VBscript!? Where's the powershell updated equivalent? ...
--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)

May 2, 2014 at 8:24 am

#1710359
RE: trigger to call a program to write a text file onto a folder in the server

eseeweb (4/30/2014)
hi
I just have an update that we don't need to delete the record from the table as long as every time a record inserted can be write to a...
--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)

April 30, 2014 at 12:57 pm

#1709977
RE: Changed behavior or am I missing something?

Eirikur Eiriksson (4/30/2014)
INNER JOIN NUMBERS NM
ON LEN(MT.MYTEMP_STR) <= NM.N
I'm thinking that bit of code cannot possibly be correct even for the old versions.
--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)

April 30, 2014 at 12:52 pm

#1709973

Viewing 15 posts - 23,731 through 23,745 (of 59,102 total)