Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,801 through 22,815 (of 59,067 total)

RE: export table

Heh... I don't believe so. I know a lot of people really like XML for what it does but I hate it for what it does. For example,...
--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)

September 3, 2014 at 11:05 pm

#1743080
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of the space delimiter so, IMHO, empty...
--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)

September 3, 2014 at 10:39 pm

#1743076
RE: export table

I didn't know there was ever a "good" case for XML. 😉
--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)

September 3, 2014 at 10:33 pm

#1743074
RE: export table

Eirikur Eiriksson (8/25/2014)
Jeff Moden (8/25/2014)
Eirikur Eiriksson (8/25/2014)
Feel I'm starting to repeat my self on the issue:pinch:
BWAAA-HAAA!!! Me too!
Switching from one delimiter to another is a form of procrastination, 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)

September 3, 2014 at 10:00 pm

#1743070
RE: Finding special characters within character strings

Katharine Mahon (8/29/2014)
How to find an embedded Tab or Pipe in an address field? I got into some problems when exported the text files with those special characters.
As...
--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)

September 3, 2014 at 9:45 pm

#1743067
RE: Grouping and Sorting challenge

RedBirdOBX (8/25/2014)
Jeff -
I just wanted to jump in and say Thanks! I went out of town last week so I was never able to follow up on this....
--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)

September 3, 2014 at 9:32 pm

#1743064
RE: Question regarding the difference between two different ways to populate a new table in TSQL

GilaMonster (8/24/2014)
Jeff Moden (8/23/2014)
Cathy DePaolo (8/22/2014)
I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going 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)

September 3, 2014 at 8:34 pm

#1743060
RE: Question regarding the difference between two different ways to populate a new table in TSQL

TomThomson (8/25/2014)
Jeff Moden (8/24/2014)
I absolutely agree that they'd better be able to pull the proverbial rabbit out of the hat on schema design to enable high performance code to 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)

September 3, 2014 at 4:46 pm

#1743044
RE: Some time Stored Procedure suddenly taking 10 seconds when we called through application.

patelchandresh330 80387 (8/22/2014)
Jeff Moden,
This is the actual code, we used this stored procedure to check connection to the database and this is also taking 10 seconds sometimes. and also other...
--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)

September 3, 2014 at 4:36 pm

#1743040
RE: Finding out Total Disk Space in TSQL

JimAtWork (2/3/2014)
I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ and also do not allow 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)

September 3, 2014 at 3:47 pm

#1743031
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

gbritton1 (9/3/2014)
I'm using the splitter (just downloaded the zip file) and noticed something odd. Dunno if its just me, but check this out:
select * from dbo.[DelimitedSplit8K](' ', ' ')...
--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)

September 3, 2014 at 3:34 pm

#1743023
RE: Just testing. Please disregard.

Jeff Moden (9/3/2014)
Jeff Moden (9/3/2014)
SELECT * FROM sys.All_Columns
SELECT * FROM sys.All_Columns;
One more time from my work desktop...
SELECT * FROM sys.All_Columns;
--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)

September 3, 2014 at 10:11 am

#1742892
RE: Just testing. Please disregard.

Jeff Moden (9/3/2014)
SELECT * FROM sys.All_Columns
SELECT * FROM sys.All_Columns;
--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)

September 3, 2014 at 10:08 am

#1742889
RE: Are the posted questions getting worse?

Ok... the dust bunnies are in an uproar and the hunt is on for "lost sock" as the only possible source of the leak for the secret recipe...
https://www.yahoo.com/food/introducing-hopsicles-the-beer-popsicles-c1408568357508.html
--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)

August 29, 2014 at 9:16 pm

#1742042
RE: OPENQUERY error: An unexpected NULL value was returned

DataDeveloper (8/28/2014)
I had the same issue pulling data into SQL Server from an AS400 server using OPENQUERY via a linked server. Try the following Syntax... it solved my problem....
--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)

August 29, 2014 at 10:26 am

#1741987

Viewing 15 posts - 22,801 through 22,815 (of 59,067 total)