Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,916 through 24,930 (of 59,102 total)

RE: Hidden Formatting Troubles with STR() (SQL Spackle)

jimgawn (1/2/2014)
"We all know that formatting data in SQL Server is your basic Bozo-no-no".
No we don't. That's a Luddite position. T-SQL has a fairly rich set of string-manipulation...
--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 3, 2014 at 8:55 am

#1677326
RE: Exclude Columns When Using Bulk Insert

That would be the exact reason for reading the column header into a table and doing the comparison. It would show the basic structure to the user and identify...
--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 3, 2014 at 8:31 am

#1677312
RE: Query for specific format

Excellent. Thanks for the feedback.
On the Oracle shift that you're having to make (I had to work with Oracle for about 3 years), my best advice would be 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)

January 3, 2014 at 8:28 am

#1677307
RE: Return random records in a table-valued function?

ChrisM@Work (1/3/2014)
Jeff Moden (1/2/2014)
You can also just create a view called (for example) ANewID that generates a GUID as a single column, single row result and simply join to it...
--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 3, 2014 at 8:25 am

#1677303
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks for stopping by, Erik.
From what I understand, the SEQUENCEs of 2012 aren't the same as the "Generate_Series" functionality of PostGre. SEQUENCEs still rely on rows being present where...
--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 3, 2014 at 8:18 am

#1677301
RE: Rebuilding Indexes very often is good?

prakashr.r7 (1/3/2014)
Jeff Moden (1/2/2014)
prakashr.r7 (1/2/2014)
Why are we not able to rebuild indexes having BLOB data? do we need to drop and recreate in alternate?
You can rebuild indexes that contain BLOB...
--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 3, 2014 at 8:11 am

#1677299
RE: How to receive Deadlock information automatically via email.

I missed this article the first time around. Nice job, Geoff.
--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 3, 2014 at 12:58 am

#1677128
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

sneumersky (1/2/2014)
I was burned by this 8 years ago.....never again. Caffiene-deprived, Xanax induced, secondhand THC inhalation.....whatever the state (j/k on the chemical reference--maybe). What is amazing to me is how...
--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 3, 2014 at 12:06 am

#1677119
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

Scott Abrants (1/2/2014)
Jeff,
Outstanding article, nicely done with great examples.
I am certain this misuse is rampant in the real world and your examples help clarify where to look for 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 2, 2014 at 11:25 pm

#1677113
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

wolfkillj (1/2/2014)
There's a use case when STR() works better/is easier than other methods of converting numbers to strings - when the numbers are already typed as float or real. CAST...
--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 2, 2014 at 10:19 pm

#1677110
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

PHYData DBA (1/2/2014)
Jeff Moden (1/9/2011)
Mike McIver (1/9/2011)
Really . . . another ridiculous article! I am responding to this reader's reply to illustrate the problem. Misinformation breeds misinformation ....
--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 2, 2014 at 9:56 pm

#1677108
RE: Exclude Columns When Using Bulk Insert

So read the first row (the header row) into a table and do a comparison.
--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 2, 2014 at 4:24 pm

#1677084
RE: Generating JSON from SQL

Emptymoon (1/2/2014)
Done.
Please share. Thanks.
--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 2, 2014 at 4:11 pm

#1677081
RE: Return random records in a table-valued function?

You can also just create a view called (for example) ANewID that generates a GUID as a single column, single row result and simply join to it as a CROSS...
--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 2, 2014 at 4:03 pm

#1677079
RE: Data Export to .csv file

Use TAB delimiters, instead?
--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 2, 2014 at 3:10 pm

#1677070

Viewing 15 posts - 24,916 through 24,930 (of 59,102 total)