Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,901 through 15,915 (of 59,063 total)

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
RE: Initial size for TempDb data and Log file?

ScottPletcher (1/10/2017)
Never disable autogrowth on tempdb -- it could bring the entire instance to a waiting state. Instead, put alert(s) into place to make sure you are made aware...
--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 10:34 am

#1921672
RE: Killing Statistics Jobs

sknox (1/10/2017)
Both sysadmin and processadmin roles have VIEW SERVER STATE rights anyway, so that option is redundant. (see https://msdn.microsoft.com/en-us/library/ms188659(v=sql.130).aspx#Permissions of Fixed Server Roles for a nice graphic.)
The question was unclear...
--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 10:29 am

#1921670
RE: Are the posted questions getting worse?

I used to think it odd that people that people I've interviewed with more than 5 years of "experience" with SQL Server that made the claim of being a DBA...
--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 9, 2017 at 9:13 pm

#1921523
RE: Identify the Column for 'String or binary data would be truncated'

ReReplaced (1/9/2017)
Tonight I dickered with GSquared's approach. Much better than I could write and it may work in some situations, but it compares importtable1(columnLength) to destinationtable2(columnLength) - It does 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 9, 2017 at 8:26 pm

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

The question is, do you really need "real time"? If the answer is no, consider "SAN Replication", which is nearly instantaneous. It may be an added piece of...
--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 9, 2017 at 8:08 pm

#1921520

Viewing 15 posts - 15,901 through 15,915 (of 59,063 total)