Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,396 through 22,410 (of 59,098 total)

RE: Split out a field of comma separated values based on a unique code in the same row.

greatrajani (11/24/2014)
hi!
kindly go through below link
http://msdn.microsoft.com/en-IN/library/ms178129.aspx
there is provision of bulk insert and bcp which is ultra fast in execution
Regards
Rajani Karthik
While I applaud the innovative thought, that would mean that you...
--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 24, 2014 at 10:09 pm

#1760688
RE: What Counts for a DBA: Empathy

Louis Davidson (@drsql) (11/24/2014)
And yeah, cheap is not total cost of ownership for sure... Ask anyone who owned a Yugo 🙂
BWAAA-HAAA!!! Now THAT'S funny! 🙂
--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 24, 2014 at 8:43 pm

#1760679
RE: Please help with Recursive CTE to get reversed people hierarchy

I just happen to have a beautiful test bed for such testing in my "Hierarchies on Steroids" articles. When I get the chance, I'll convert the rCTE in 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 24, 2014 at 5:34 pm

#1760671
RE: Clustered index failed to build with Online=ON

haiao2000 (11/21/2014)
Here is my question. I have Enterprise version of SQL Server 2012 & SQL server 2008. I understand that Image/Text/NText is obsoleted and should not be used. That...
--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 24, 2014 at 5:28 pm

#1760670
RE: SQL DBA knowing user passwords

Markus (11/24/2014)
Jeff Moden (11/22/2014)
Markus (11/21/2014)
I just tired to have a squirrel user and one small dept. app. user test out the expire users password and it basically kills them 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)

November 24, 2014 at 5:22 pm

#1760667
RE: Are the posted questions getting worse?

Evil Kraig F (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic 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)

November 24, 2014 at 4:41 pm

#1760659
RE: T-SQL Development Standards

SQLRNNR (11/24/2014)
Jeff Moden (10/25/2008)
But, ya gotta be will to and have management's support to just say "NO" to bad code.
I completely agree. Standards mean nothing if you don't have...
--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 24, 2014 at 4:25 pm

#1760656
RE: Are the posted questions getting worse?

andrew gothard (11/24/2014)
David Burrows (11/21/2014)
Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀
Agreeable, surely?
Unless there's no designated driver, most assuredly.
--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 24, 2014 at 4:15 pm

#1760651
RE: Are the posted questions getting worse?

swoozie (11/24/2014)
I got so used to 3rd party software and automation that I had originally set up years ago that when I came to a much more rudimentary environment I...
--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 24, 2014 at 4:14 pm

#1760650
RE: Are the posted questions getting worse?

Eirikur Eiriksson (11/24/2014)
Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on the XML forum has proportionally...
--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 24, 2014 at 4:11 pm

#1760647
RE: T-SQL Development Standards

Just to make sure that no one else falls upon that document, I've deleted it from my previous post. It's just too out of date and that item about...
--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 24, 2014 at 4:05 pm

#1760644
RE: T-SQL Development Standards

chenke (2/17/2010)
I understand this is an old forum, but in effort to add to a discussion that others may benefit from I want to share a document that might also...
--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 24, 2014 at 3:56 pm

#1760640
RE: T-SQL Development Standards

Sean Lange (11/24/2014)
paul s-306273 (11/24/2014)
Reading 'XYZ', I'm surprised that the use of views is discoraged.
You read that document (which btw is more than 6 years old) and you were surprised...
--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 24, 2014 at 3:51 pm

#1760638
RE: What Counts for a DBA: Empathy

Gary Varga (11/24/2014)
alicesql (11/24/2014)
...Also, there is a triumvirate of price, quality and speed. You can generally get 2 of these, but not all three. In other words, you can get...
--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 24, 2014 at 7:29 am

#1760512
RE: Large tran log dump after Differential or Full backup

suedunham2 (11/24/2014)
Thank you for that prompt reply - it looks like there is no way of reducing the size of the first Monday tran log dump unless I change 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 24, 2014 at 7:23 am

#1760509

Viewing 15 posts - 22,396 through 22,410 (of 59,098 total)