Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,031 through 30,045 (of 59,101 total)

RE: Common questions asked in SQL Server DBA Interview

Brandie Tarvin (5/14/2012)
Jeff Moden (5/14/2012)
Brandie Tarvin (5/14/2012)
What is the wing span of an unladen swallow?
It depends. What is the age and current speed of the swallow?
I don't know.
<Aaaaaaaaarrrrrrrrggggghhhhhhhhhh>
Then 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 14, 2012 at 4:48 am

#1487023
RE: Please suggest the query

Your post has gone 2 days with no responses. Take a look at the first link in my signature line below to increase the odds of your question being...
--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 14, 2012 at 4:42 am

#1487017
RE: Are the posted questions getting worse?

Brandie Tarvin (5/14/2012)
dwain.c (5/13/2012)
Oh and BTW. I've been using the below terminology. If anyone knows of different, more widely accepted terminology, I'd appreciate knowing what that is.
Single use...
--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 14, 2012 at 4:38 am

#1487013
RE: Dynamic Joins

lanky_doodle (5/14/2012)
Thanks for the input guys. I have managed to sort this out;
How's the performance on all of that?
--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 14, 2012 at 4:29 am

#1487010
RE: Common questions asked in SQL Server DBA Interview

Brandie Tarvin (5/14/2012)
What is the wing span of an unladen swallow?
It depends. What is the age and current speed of the swallow?
--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 14, 2012 at 4:25 am

#1487008
RE: GUID

riya_dave (5/11/2012)
hi
i have unique identifier field in one sp, that i need to pass into another sp.
when i copy paste it to another sp as a parameter value,i am...
--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 14, 2012 at 4:17 am

#1487004
RE: how to test the performance of 2 queries

As a sidebar, also be leary of SET STATISTICS TIME ON when user defined functions are involved. A query may take sub second times when the setting is off...
--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 14, 2012 at 4:08 am

#1486997
RE: Is Software Engineering Dead?

Abrar Ahmad_ (5/13/2012)
Jeff Moden (5/12/2012)
Good article, Steve. I believe that you've hit the nail on the head. So many managers think that Hours worked = Hours wisely 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)

May 14, 2012 at 3:59 am

#1486996
RE: UDFs, Stored Procs, table-valued functions and subqueries

Damned good to see you back, Barry! Really Long time no see!
--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 13, 2012 at 6:12 pm

#1486905
RE: RegEx for DBAs

I very much appreciate the time you've spent on that great explanation, Solomon. And I absolutely believe that you've hit the nail on the head when you said...
...if...
--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 13, 2012 at 6:09 pm

#1486904
RE: Select Records from table and insert it to another table or update if exist

Heh... did you look it up in Books Online as I suggested? It has examples there. What I'm hoping is that you'll take a minute and teach yourself...
--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 13, 2012 at 5:48 pm

#1486902
RE: UDFs, Stored Procs, table-valued functions and subqueries

Rowles (5/13/2012)
I have five questions.
1. Table-valued subqueries are subqueries that return tables while they may or may not accept tables (or table variables) as input parameters, right?
They're more commonly...
--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 13, 2012 at 3:31 pm

#1486893
RE: Time for Your Career

What I find really sad is the hundreds (maybe, thousands) of people I've run across on these and other forums who really need to do some studying of their own...
--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 13, 2012 at 3:16 pm

#1486892
RE: Select Some Date From A long Text Column

What you may want to do to make your life easier in the future is to normalize the data. Like this...
--===== Create the test data.
SELECT *
...
--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 13, 2012 at 3:01 pm

#1486891
RE: Select Records from table and insert it to another table or update if exist

This would be a good use for the "new" MERGE command. Take a look at it in Books Online. It's petty simple to use.
--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 13, 2012 at 2:28 pm

#1486890

Viewing 15 posts - 30,031 through 30,045 (of 59,101 total)