Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,666 through 13,680 (of 59,101 total)

RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

GilaMonster - Monday, November 20, 2017 4:33 AM
Jeff Moden - Sunday, November 19, 2017 9:42 AM
--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 20, 2017 at 10:10 am

#1968815
RE: Amount of RAM in server

tfeuz - Sunday, November 19, 2017 6:25 PM
tfeuz - Sunday, November 19, 2017 6:24 PM
--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 19, 2017 at 7:07 pm

#1968712
RE: Not able to get any links to find ebbok for sql 2016 MCSA certification

Thom A - Sunday, November 19, 2017 5:13 AM
sej2008 - Sunday, November 19, 2017 2:58 AM
--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 19, 2017 at 6:40 pm

#1968711
RE: mapping an Excel Spreadsheet to a Table

etl2016 - Sunday, November 19, 2017 3:31 PM
Hi
I have a client who will send me an Excel spreadsheet and I 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 19, 2017 at 6:31 pm

#1968710
RE: Amount of RAM in server

tfeuz - Sunday, November 19, 2017 6:13 PM
Jeff Moden - Sunday, November 19, 2017 5:56 PM
--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 19, 2017 at 6:21 pm

#1968707
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Sunday, November 19, 2017 5:05 PM
Jeff Moden - Sunday, November 19, 2017 4:44 PM
--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 19, 2017 at 6:02 pm

#1968705
RE: Amount of RAM in server

tfeuz - Friday, November 17, 2017 3:19 PM
Just curious - how much RAM do you have in your SQL server?
384GB of RAM...
--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 19, 2017 at 5:56 pm

#1968704
RE: Migration from Teradata to SQL

prasanna0184 - Friday, November 17, 2017 11:14 AM
Hi,
We are currently migrating our project database from teradata to SQL. In teradata all 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 19, 2017 at 5:50 pm

#1968703
RE: Help with aggregate function

It won't make a bit of improvement performance-wise over what Luis posted, but it does simplify the code a bit. The derived table could be a CTE or CROSS APPLY,...
--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 19, 2017 at 5:45 pm

#1968702
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Sunday, November 19, 2017 4:30 PM
Jeff Moden - Sunday, November 19, 2017 4:19 PM
--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 19, 2017 at 4:44 pm

#1968700
RE: Are the posted questions getting worse?

TomThomson - Sunday, November 19, 2017 1:01 PM
Eirikur Eiriksson - Sunday, November 19, 2017 10:39 AM
--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 19, 2017 at 4:29 pm

#1968698
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Sunday, November 19, 2017 2:34 PM
Eirikur Eiriksson - Sunday, November 19, 2017 1:11 PM
--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 19, 2017 at 4:19 pm

#1968697
RE: Simple Queries Run Slow

SKP DBA - Friday, October 27, 2017 9:42 AM
Dear Experts,
Simple queries run lot of time in millions record table table have around...
--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 19, 2017 at 12:41 pm

#1968691
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Sunday, November 19, 2017 11:36 AM
Lynn Pettis - Friday, November 17, 2017 2:11 PM
--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 19, 2017 at 12:25 pm

#1968690
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Sunday, November 19, 2017 11:38 AM
Jeff Moden - Sunday, November 19, 2017 9:42 AM
--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 19, 2017 at 12:22 pm

#1968689

Viewing 15 posts - 13,666 through 13,680 (of 59,101 total)