Jeff Moden

Forum Replies Created

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

RE: TempDb File Sizing

There's no way in hell that I'd enable TF 1117. It doesn't just affect TempDB and I don't want the nearly 90 temporal files/filegroups for a 600GB table to...
--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)

December 1, 2016 at 8:30 am

#1915434
RE: RAMDisk? Use it for TempDB?

If it has a problem with disk writes, then TempDB is probably the least of your worries. Have you looked into what that system is doing to log file...
--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 10:21 pm

#1915321
RE: Finally, Create or Alter

hakim.ali (11/30/2016)
Jeff Moden (11/29/2016)
Treating a table like code makes no sense.
Why? I ask not as a challenge, but to understand your reasoning. I have generally leaned towards treating tables 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 30, 2016 at 4:27 pm

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

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