Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,186 through 16,200 (of 59,067 total)

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
RE: Using OpenRowset to Insert Data

Hopefully, that's not a real UID and PW that you used in your post.
--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 5:27 pm

#1914847

Viewing 15 posts - 16,186 through 16,200 (of 59,067 total)