Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,106 through 21,120 (of 59,072 total)

RE: Split function that allows multiple character delimitter

No problem. You're happy with the performance of the While loop then?
--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)

April 2, 2015 at 6:35 pm

#1788453
RE: XP_cmdshell DIR

Stephen Swan (4/2/2015)
I modified Jeff's procedure to allow for subfolders. I put a maxDepth parameter into it for some control as needed. Thanks Jeff for the code.
ALTER PROCEDURE dbo.GetDirDetails
/**************************************************************************************************
...
--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)

April 2, 2015 at 6:26 pm

#1788452
RE: SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in SSMS!!

Is the owner of the database a member of the sysadmin role?
--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)

April 2, 2015 at 6:02 pm

#1788450
RE: Identity on Uniqueidentifier

tomy200501 (4/1/2015)
Hello All,
I am trying to set "Is Identity property" To Yes on a column that has uniqueidentifier as a type and has a primary key constraint on it. Is...
--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)

April 1, 2015 at 9:24 pm

#1788179
RE: Recover table from database backup

Anshul Parmar (4/1/2015)
Hi Guys,
I've to recover data for a single table from a database backup. I could not restore full database as it is very large (~900GB).
Please suggest what would...
--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)

April 1, 2015 at 9:11 pm

#1788176
RE: Get file size

SAinCA (3/31/2015)
This saved the day for a SQL2012 need.
Many thanks!
Wow. Even after all this time. Thank you for the feedback. Care to share any details on what...
--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)

April 1, 2015 at 10:31 am

#1788083
RE: Are the posted questions getting worse?

GilaMonster (4/1/2015)
Grant Fritchey (4/1/2015)
SQLRNNR (4/1/2015)
Who remembered to do an April Fools post today?
No inspiration for one this time.
No inspiration, no enthusiasm, no time.
It's an HR violation for me to give...
--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)

April 1, 2015 at 9:47 am

#1788075
RE: T-SQL Help...probably pretty simple but I'm tired :)

ScottPletcher (3/31/2015)
As a side note, but still critical, let me warn everyone to use lowercase only for data type names in SQL Server. That is, "int" not "INT", "datetime"...
--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)

March 31, 2015 at 5:29 pm

#1787884
RE: Question on how to update quickly

krypto69 (3/30/2015)
Thanks Grant.
Long story, but it's financial data and I'm new there so can't complain..yet.
Kinda figured those were my only options. Shame I can't use my high avail...without read only.
Think...
--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)

March 30, 2015 at 6:37 pm

#1787532
RE: Query plan for partitioned views not running as they should.

josjonkmans (3/30/2015)
I did find a solution for the problem, I was using an SQL account for my linkedserver connections. When I changed it to use the "Be made using 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)

March 30, 2015 at 10:39 am

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

mark hutchinson (3/30/2015)
@jeff
I didn't say "Null was equal to nothing". I wrote that Null was something that "means nothing".
Oh yes. I understood that from the git. 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)

March 30, 2015 at 10:33 am

#1787419
RE: How to quickly update/insert 3M records in a large table?

Jason-299789 (3/30/2015)
I would also suggest that the key on both the destination table is clustered it should make the process significantly faster. so something like.
"It Depends". Unless the key...
--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)

March 30, 2015 at 10:28 am

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

mister.magoo (3/30/2015)
Ed Wagner (3/30/2015)
Jeff Moden (3/29/2015)
mark hutchinson (3/29/2015)
Null is a something that means nothing
I'll have to disagree with that. To me, an empty string or the number 0 is...
--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)

March 30, 2015 at 8:53 am

#1787382
RE: Partition for a particular value and not

To answer your original question, yes, it is possible to partition based on the CustomerID as 1 partition for some customers and 1 partition for ranges of customers. Just...
--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)

March 30, 2015 at 8:31 am

#1787370
RE: Populate table with some gaps in between

inHouseDBA (3/29/2015)
Gurus,
Thank you very much for your help.
Is there a way you can explain the interaction of
WITH T(N) AS (SELECT N FROM...
--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)

March 29, 2015 at 9:55 pm

#1787209

Viewing 15 posts - 21,106 through 21,120 (of 59,072 total)