Jeff Moden

Forum Replies Created

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

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
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:34 AM
Eirikur Eiriksson - Sunday, November 19, 2017 11:05 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:20 pm

#1968688
RE: VARBINARY(n) vs VARBINARY(MAX) - size

DamianC - Saturday, November 18, 2017 9:52 AM
Hello
I haven't really had the need for VARBINARY before
Just started filling in some gaps 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 19, 2017 at 9:58 am

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

SQL-DBA-01 - Friday, November 17, 2017 1:29 PM
ZZartin - Friday, November 17, 2017 1:17 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 9:42 am

#1968679
RE: Are the posted questions getting worse?

Grant Fritchey - Sunday, November 19, 2017 6:46 AM
WayneS - Friday, November 17, 2017 3: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 9:31 am

#1968677
RE: Extracting a specific number of words from a string in sql

chinhvowili - Sunday, November 19, 2017 12:01 AM
Adam Haines - Wednesday, February 27, 2008 7:32 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 9:06 am

#1968676
RE: One of my sql database

yetiger909 - Sunday, November 19, 2017 3:32 AM
If you canâ€™t open or repair .mdf via any method, in such case was...
--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 8:59 am

#1968675

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