Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,956 through 23,970 (of 59,099 total)

RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

I just added the following code to the example above, the second snippet of which matches your example, Jose.
PRINT '========== Do an aggregate only from TableA...'
SELECT TableASomeID,...
--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 5, 2014 at 5:23 pm

#1703547
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

jay 87680 (3/20/2014)
There is a general misconception of the following statement that you make.
"In this case SQL Server will still have to join all the tables in the view...
--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 5, 2014 at 4:53 pm

#1703546
RE: How many Databases are you managing

I have found that managing databases and servers is pretty easy although I certainly prefer not to have to keep up with hunred or thosands like some of the 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)

April 5, 2014 at 3:08 pm

#1703538
RE: xp_create_subdir for non-sysadmins

jpoole (4/5/2014)
Hi,
Is it possible for non-sysadmins to run xp_create_subdir on the Express version of 2008 R2? When researching the subject I have seen talk of adding a proxy account. Can...
--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 5, 2014 at 2:42 pm

#1703535
RE: Processing flat file with Header,Detail and Trailer

Drat... I was hoping you wanted a T-SQL-only solution. 😛 I don't actually know how to spell SSIS so I can't help here. Hopefully, someone who knows SSIS...
--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 5, 2014 at 1:12 pm

#1703524
RE: Find sequential numbers

You're a better man than I, Mr. Pettis. I took the time to put the originally posted data in a table along with an answer (very similar to yours...
--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 5, 2014 at 1:09 pm

#1703521
RE: Short Stroking and Performance

I think hard disks have simply gotten too big to do some of the old tricks to bring multiple spindles into play. As for "short stroking", Peter Norton figured...
--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 5, 2014 at 12:39 pm

#1703520
RE: Find sequential numbers

rui_leote (4/5/2014)
I can do it, I am not at home now. I have a table with only 2 columns. Let's say "eventdate" and "status".
Eventdate is datetime
Status is int.
I have records...
--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 5, 2014 at 11:19 am

#1703507
RE: rewrite cursor to set based

priestxandar (4/5/2014)
Could anyone help with this ?
Thank you
It's a fair bit of work to rewrite such things so that they perform better. It's also a bit like shooting in...
--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 5, 2014 at 11:16 am

#1703506
RE: Processing flat file with Header,Detail and Trailer

naresh0407 (4/4/2014)
Hi All,
I have below flatfile.Please let me know how to process this file without scripttask in SSIS.
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)

April 5, 2014 at 11:04 am

#1703505
RE: Opinion of use of LINQ

One of the biggest problems I've had with Linq to SQL (and other ORMs, as well) is the data-type mismatching it sometimes does. Most of our character based columns...
--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 5, 2014 at 11:01 am

#1703504
RE: Sequential numbers

This is a duplicate post. Please don't post any answers here because it'll just separate potential solutions from what is already in progress. Instead, please the in-progress duplicate...
--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 5, 2014 at 10:40 am

#1703502
RE: Find sequential numbers

rui_leote (4/5/2014)
I realy need some performance on it. So, how can I do it.
The idea is to use blocks of date with hours. I need to make an appointment, and...
--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 5, 2014 at 10:36 am

#1703501
RE: Find sequential numbers

milos.radivojevic (4/5/2014)
In the sample chapter you can also find an explanation why in this case a cursor solution overperforms a set based one.
While that example is technically "set-based" because it...
--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 5, 2014 at 9:59 am

#1703497
RE: Are the posted questions getting worse?

TomThomson (4/3/2014)
Lynn Pettis (4/3/2014)
TomThomson (4/3/2014)
You can have it fast, cheap, or right - pick only one of the three.
I thought that was 2 of 3? When did this change?...
--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 5, 2014 at 9:21 am

#1703494

Viewing 15 posts - 23,956 through 23,970 (of 59,099 total)