Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,931 through 15,945 (of 59,098 total)

RE: SSC Forum Updates

Jeff Moden - Thursday, January 12, 2017 8:52 AM
Thom A - Thursday, January 12, 2017 4:24 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)

January 12, 2017 at 8:54 am

#1922329
RE: SSC Forum Updates

Thom A - Thursday, January 12, 2017 4:24 AM
It seems that the word wrapping goes a bit odd at the end of a...
--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)

January 12, 2017 at 8:52 am

#1922326
RE: SSC Forum Updates

Dave Convery - Thursday, January 12, 2017 4:11 AM
You can vote on the "Comic Sans Issue" now.
https://www.sqlservercentral.com/Forums/Topic1849980.aspx
I'm thinking that there are...
--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)

January 12, 2017 at 8:47 am

#1922324
RE: Are the posted questions getting worse?

ChrisM@Work - Thursday, January 12, 2017 8:31 AM
Jeff Moden - Thursday, January 12, 2017 8:29 AM
Not...
--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)

January 12, 2017 at 8:40 am

#1922321
RE: Are the posted questions getting worse?

Not sure if it's just me or not. Under forums, the "Latest" posts don't ever appear for me. I just get an hour glass. I "live" by the "Latest Posts".
--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)

January 12, 2017 at 8:29 am

#1922313
RE: format number

Manic Star (1/11/2017)
ThomasRushton (1/11/2017)
GilaMonster (1/11/2017)
ThomasRushton (1/11/2017)
You could also use
SELECT FORMAT(10.500,'N1')
See documentation for the FORMAT function.
Although FORMAT is extremely slow compared to CONVERT.
https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but
Good point.
Mind you, this sort of formatting should be...
--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)

January 11, 2017 at 11:16 am

#1922023
RE: format number

ThomasRushton (1/11/2017)
GilaMonster (1/11/2017)
ThomasRushton (1/11/2017)
You could also use
SELECT FORMAT(10.500,'N1')
See documentation for the FORMAT function.
Although FORMAT is extremely slow compared to CONVERT.
https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but
Good point.
Mind you, this sort of formatting should be done away...
--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)

January 11, 2017 at 11:15 am

#1922021
RE: recommendation of tempb files

Talib123 (1/9/2017)
Whoops didn't read page 2 of this post T1117 already mentioned.
So was T1118. But, on the subject of T1117 and as I mentioned in a previous post on...
--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)

January 11, 2017 at 7:56 am

#1921952
RE: Are the posted questions getting worse?

Grant Fritchey (1/11/2017)
Brandie Tarvin (1/11/2017)
I had a brainstorm yesterday. I'm wondering if it's worth the effort to try and get some coding basics sessions together for the local SQL Saturdays,...
--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)

January 11, 2017 at 7:40 am

#1921949
RE: Create incrementing group numbers for groups of 500 rows?!

LinksUp (1/10/2017)
WebTechie (1/4/2017)
Hello,
We are doing a migration and need to import in batches of 500 rows. The table that we are migrating has 60,000 rows.
Just curious, but are these...
--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)

January 10, 2017 at 7:25 pm

#1921808
RE: The Salary Range

Alan.B (1/10/2017)
Jeff Moden (1/7/2017)
Alan.B (1/3/2017)
Great post Steve, 5 stars.
I found out a few weeks back that my department is moving to Phoenix AZ. I did not chose to transfer...
--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)

January 10, 2017 at 7:20 pm

#1921807
RE: Near Real time copy of OLTP for SQL2014

Andrew..Peterson (1/10/2017)
Jeff, thanks for the tip on SAN Replication. I'll look into. No problems with replication, but with lots of tables, it adds more administrative work that is desired.
It's been...
--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)

January 10, 2017 at 7:10 pm

#1921805
RE: The SQL Saturday Thread

Ray K (1/10/2017)
I've submitted presentations to a number of SQL Saturdays around the Northeast US. Who's going where this year?
I intend to go to NYC regardless of whether or...
--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)

January 10, 2017 at 11:38 am

#1921691
RE: The SQL Saturday Thread

Ray K (9/26/2016)
Who's going to be in Pittsburgh this Saturday?
BTW... you missed a great "Black Arts" precon. 😉
--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)

January 10, 2017 at 11:27 am

#1921686
RE: Initial size for TempDb data and Log file?

chuck.hamilton (1/10/2017)
That's simply not true. An instance will not hang because you filled the tempdb database. Queries will fail and the instance will throw errors like 1105, but it most...
--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)

January 10, 2017 at 11:19 am

#1921683

Viewing 15 posts - 15,931 through 15,945 (of 59,098 total)