Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,171 through 19,185 (of 59,072 total)

RE: Are the posted questions getting worse?

TomThomson (11/14/2015)
Jeff Moden (11/14/2015)
To explain some of my extreme frustration in the "developers" that I've been interviewing over the last decade, the following blog post is a great example of...
--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 14, 2015 at 3:44 pm

#1839831
RE: Show First Order With All of User Orders

I'm curious as to what will happen when the year rolls over. It strongly recommend NOT using just a simple month identifier. There has to be somewhere 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)

November 14, 2015 at 11:18 am

#1839822
RE: Need help with Pivot multiple columns in a single select

rash3554 (11/14/2015)
wow! never thought of that approach. It took me a day :-(..and the only solution I thought was creating separate temp tables for each ColumnID with primary key 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 14, 2015 at 11:15 am

#1839821
RE: Are the posted questions getting worse?

jasona.work (11/14/2015)
And now for something completely different...
I think the guy on the right, in the red Hawaiian shirt, might be Steve...
:hehe::hehe:
Nah... Steve has better legs than 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)

November 14, 2015 at 11:02 am

#1839820
RE: Referencing function from another database in CREATE TABLE stmt

It's not likely the function will change. If it does, you can use the Registered Server trick to push it to multiple databases in multiple servers. Just store...
--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 14, 2015 at 10:21 am

#1839818
RE: The equivalent of 'connect by' in Oracle

As you've found, SQL Server doesn't have anything quite as convenient as "CONNECT BY". It's does, have a couple of tools that you can use to do similar though....
--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 14, 2015 at 10:13 am

#1839817
RE: Splitting data of MDF file

vsamantha35 (11/13/2015)
Can anybody help?
To be honest, my opinion is that the drive assignments are flawed especially in light of the fact that you already know that a 10TB drive 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)

November 14, 2015 at 9:43 am

#1839813
RE: Are the posted questions getting worse?

To explain some of my extreme frustration in the "developers" that I've been interviewing over the last decade, the following blog post is a great example of the type of...
--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 14, 2015 at 8:53 am

#1839810
RE: Pounds of Formatting Fun

jamunozs (11/13/2015)
Format not exist in sql
You need to look at the newer version of SQL Server. If you're talking about ANSI SQL, few people care because this is an...
--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 13, 2015 at 9:28 pm

#1839784
RE: making t-sql 2012 execute faster

wendy elizabeth (11/13/2015)
I have been working with t-sql 2012 for awhile. I have noticed that some questions run faster than other queries. I know that this is based upon 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)

November 13, 2015 at 9:25 pm

#1839783
RE: How to do a Pivot

Sean Lange (11/13/2015)
Ed Wagner (11/13/2015)
Sean Lange (11/13/2015)
Instead of a PIVOT I would recommend using a crosstab. The syntax is far less obtuse to me and it even has a slight...
--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 13, 2015 at 9:15 pm

#1839781
RE: Whether my table is stored as heap or b-tree?

It's a whole lot easer than that. If the table has a Clustered index, the table will be based on a B-TREE. If it's a HEAP, it will...
--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 13, 2015 at 9:06 pm

#1839779
RE: Presentation Software Recommendations

I don't see why PowerPoint couldn't do all of that. You can embed videos, setup "Credits" animations and scrolling entrances and a whole bunch of other things.
--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 13, 2015 at 8:04 pm

#1839778
RE: Separate UserObejts's FileGroup And SystemObjects's FileGroup

With the understanding that you'll sacrifice a bit of performance, there are many advantages to splitting things up in separate file groups using a thing called "partitioning". It also...
--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 13, 2015 at 7:41 pm

#1839775
RE: Query Performance Problem

lraju10 (11/13/2015)
Problem : currently working on purchase sproc where it is taking 2 sec for the Purchase transaction to complete, i identified the problem statement, where i generate a six...
--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 13, 2015 at 7:23 pm

#1839774

Viewing 15 posts - 19,171 through 19,185 (of 59,072 total)