Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,216 through 16,230 (of 59,098 total)

RE: Mathematics/Algorithms in SQL

OR... are you looking for things like why you might want to use Integer math, how to do things with dates and times, how to compare two differently partitioned ROW_NUMBER()...
--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 30, 2016 at 4:03 pm

#1915298
RE: RAMDisk? Use it for TempDB?

Gail Wanabee (11/30/2016)
RAMDisk used to exist in Windows NT. I used it and it worked really well. Then, it was eliminated in Windows Server 2003, as I recall.
You would block...
--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 30, 2016 at 3:59 pm

#1915297
RE: should i use temp table all the time while making loops

rajemessage 14195 (11/30/2016)
i have taught my team to use set based operation strictly,...
Excellent. You're a man after my own heart.
rajemessage 14195 (11/30/2016)
... but there are cases where ,we...
--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 30, 2016 at 9:00 am

#1915194
RE: possible combinations for all rows in table

Post withdrawn... didn't read the requirements correctly. Interesting problem.
--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 30, 2016 at 8:30 am

#1915183
RE: Finally, Create or Alter

Ed Wagner (11/30/2016)
KenpoDBA (11/29/2016)
If we could get something like the following we could also avoid most of the dynamic-sql out there:
select * from @DBName.dbo.T1;
update @DBName.dbo.T1;
select * from @DBName.sys.database_files;
etc.
They force us...
--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 30, 2016 at 8:26 am

#1915181
RE: Change table from vertical to horizontal

benkraiemchedlia (11/30/2016)
Hi,
I have a table "Questions" with 2 columns "id", "text" it already contains many rows (200 rows):
id | text
1 | aa
2 | bb
3 | cc
...
I want...
--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 30, 2016 at 8:21 am

#1915178
RE: can i remove loop with this and is there any other better

rajemessage 14195 (11/30/2016)
hi,
1) should i remove loop with follwiong query.
2) and is there any other way to do it, with out using loop.
declare @str varchar(max)=''
select @str=@str+'exec [dbo].[usptest]' + ' '''+abc.name+''';...
--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 30, 2016 at 8:18 am

#1915177
RE: A scenario where SQL Server doesn't seem to help

whenriksen (11/30/2016)
It would be helpful if you can post some of the dynamically generated SQL, ideally one with all 20+ columns included. In my experience, procedural developers don't write...
--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 30, 2016 at 8:00 am

#1915170
RE: What is Normal?

TomThomson (11/29/2016)
David.Poole (11/28/2016)
http://www.publications.parliament.uk/pa/cm200405/cmselect/cmconst/243/24307.htm paragraph 92 for us in the UK
well, para 92 makes it pretty clear than our NI "numbers" are a total mess. I wonder if our other...
--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 29, 2016 at 9:10 pm

#1915082
RE: Finally, Create or Alter

Steve Jones - SSC Editor (11/29/2016)
Jeff Moden (11/29/2016)
Heh... yeeaaahhh... that's what I want to do for a 140 column table. 😉
If you're treating code like code, then you'd always have...
--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 29, 2016 at 8:46 pm

#1915080
RE: Finally, Create or Alter

Steve Jones - SSC Editor (11/29/2016)
Nelson Petersen (11/29/2016)
No need to specify all the columns when you only want to change one of them:
create table test9 (c1 number, c2 number, c3...
--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 29, 2016 at 4:20 pm

#1915060
RE: Finally, Create or Alter

KenpoDBA (11/29/2016)
If we could get something like the following we could also avoid most of the dynamic-sql out there:
select * from @DBName.dbo.T1;
update @DBName.dbo.T1;
select * from @DBName.sys.database_files;
etc.
They force us 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)

November 29, 2016 at 4:18 pm

#1915059
RE: Survival of Human being in this world

karthik M (11/29/2016)
I am wondering about director's prediction (2022) of the movie which you mentioned...
No Need to wait till 2022...People already started to do anything for Money..They want to enjoy...
--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 29, 2016 at 8:32 am

#1914978
RE: Stairway to Power BI

karthik M (11/29/2016)
All,
I am looking for stairway to Power BI kind of articles. I have read few articles in simple-talk although it explains about some specific areas.
So look in 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 29, 2016 at 8:25 am

#1914971
RE: Recursion to iterate function

sgmunson (11/28/2016)
Jeff Moden (11/28/2016)
I hate double postings for this very reason. :crazy: Thanks for the heads up. I left my spare CRAY somewhere and forgot where I put...
--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 28, 2016 at 6:02 pm

#1914848

Viewing 15 posts - 16,216 through 16,230 (of 59,098 total)