Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,186 through 19,200 (of 59,098 total)

RE: Are the posted questions getting worse?

jasona.work (11/17/2015)
I love it when I'm poking through topics that sound interesting, and come across something I've not done / seen before. Which then leads me down a rabbit...
--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 17, 2015 at 7:51 am

#1840335
RE: making t-sql 2012 execute faster

Any feedback, Wendy?
--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 16, 2015 at 8:42 pm

#1840194
RE: Good Basic T-SQL Exercises

hoseam (11/13/2015)
Hi
I want to return two character from a column. But now the column itself returns 0 -9, then double digits. before I concatenated "0", then the problem I had...
--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 16, 2015 at 7:40 pm

#1840193
RE: Good Basic T-SQL Exercises

Steve Jones - SSC Editor (11/12/2015)
I'm looking for a number of problems that I can ask people to solve in T-SQL to try and drive some learning. I'm wondering what...
--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 16, 2015 at 7:36 pm

#1840192
RE: Data Sprawl

I think it only appropriate that "data sprawl" accompany the "Tower of Babel" that a lot of people end up using.
We had a similar problem way back in 1996 were...
--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 16, 2015 at 7:15 pm

#1840190
RE: Query Performance Problem

Jeff Moden (11/13/2015)
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...
--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 16, 2015 at 3:30 pm

#1840172
RE: Help with query that group consecutive records based on a field value

laorozco1 (11/16/2015)
Thanks a lot, it works
Since you're the one that will need to explain it and support it, do you know how and why it works?
--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 16, 2015 at 9:33 am

#1840009
RE: 150 GB Backup (compressed) taking over 1 day

jbrandenburg (11/16/2015)
We have 75 databases being backed up using simple recovery model on a nightly basis. We have no custom applications, but we have the following 3rd party apps...
--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 16, 2015 at 9:32 am

#1840008
RE: How to do a Pivot

Sean Lange (11/16/2015)
Jeff Moden (11/13/2015)
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...
--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 16, 2015 at 9:24 am

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

chuck.forbes (11/16/2015)
Registered server trick?
Yes. You register the servers in SSMS into a common group and then run the promotion script against the group. All of the underlying servers...
--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 16, 2015 at 8:54 am

#1839989
RE: Are the posted questions getting worse?

GilaMonster (11/14/2015)
I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and research really...
--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 4:02 pm

#1839833
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

Viewing 15 posts - 19,186 through 19,200 (of 59,098 total)