Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,151 through 18,165 (of 59,102 total)

RE: Split Multiple Times

Luis Cazares (3/14/2016)
I would upload the file using bulk insert or something similar to avoid the pivot and the additional split. But I was waiting for a reply from 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 14, 2016 at 7:50 pm

#1865106
RE: Find hierarchyID from different parts of a node?

Shifting gears a bit...
...Consider the possibility of not using HierarchyID at all.
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
--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 14, 2016 at 7:45 pm

#1865105
RE: Building Better Software

I think it highly ironic that a lot of managers want code real bad and then have the nerve to be disappointed when the developers give it them that way....
--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 14, 2016 at 7:34 pm

#1865104
RE: Find difference between two records

The Danish Dynamo (3/14/2016)
It depends on what version you are using
MSSQL 2014+ has that feature:
https://msdn.microsoft.com/en-us/library/bb933994.aspx
Here's why I don't use that feature...
•There is a built-in cleanup mechanism. Cleanup for change tracking...
--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 14, 2016 at 5:39 pm

#1865096
RE: Memory recommendation

sunny.tjk (3/14/2016)
Grant Fritchey (3/14/2016)
I doubt there's a document to support that. It's a bad estimate. I've successfully run 200gb databases on servers with 16gb of memory. It really depends 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)

March 14, 2016 at 5:34 pm

#1865094
RE: Unable to select from function

The Danish Dynamo (3/14/2016)
Here's a solution without all the if's and butt's
-- 1) Get the code from sp_linkedservers
sp_helptext sp_linkedservers
-- 2) Copy the code into inline table valued udf
CREATE FUNCTION dbinv.ufn_Get_Linked_Servers...
--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 14, 2016 at 5:16 pm

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

Solomon Rutzky (3/14/2016)
Jeff Moden (3/14/2016)
I'll have to agree to strongly disagree with most everything you've said and the reasons you've said them.
Well, for reasons heretofore stated and unstated, whether expressly...
--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 14, 2016 at 11:39 am

#1865021
RE: Cannot drop the table 'TABLE' because at least part of the table resides on an offline filegroup.

I learned of all these caveats the hard way. We have a large partitioned table that we only need 3 months of for Dev restores. What a freakin'...
--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 14, 2016 at 10:50 am

#1865004
RE: Split Multiple Times

rootfixxxer (3/14/2016)
Hello
I have a simple problem, that i can solve easily with help of cursors, but i want to know if anyone knows a better way.
I have a large piece...
--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 14, 2016 at 10:26 am

#1864991
RE: Dealing with large tables (Financial transactions)

TheSQLGuru (3/14/2016)
1) IIRC, partitioning is an Enterprise Edition only feature. That could preclude it's use right off the bat.
2) Partitioning CAN make SOME or even MOST queries run very...
--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 14, 2016 at 10:00 am

#1864985
RE: Parent and child relationship is broken when do the sort based on parent name

stsivaraj (3/13/2016)
Thanks for your response. Actually, I got solution from my manager. Thanks for your support
I'd be very interested in seeing the code that you and your manager used. ...
--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 14, 2016 at 9:47 am

#1864982
RE: How to execute an SSIS package from the command line or a batch file

Good article but, is there any way around this major security violation???
6. Modify the configuration file to change the server name and [font="Arial Black"]user name and add the password [/font]
Open...
--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 14, 2016 at 9:25 am

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

spaghettidba (3/14/2016)
FWIW, I agree with Solomon here.
Heh... for once, we disagree. 😛
--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 14, 2016 at 9:16 am

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

Solomon Rutzky (3/13/2016)
Jeff Moden (3/12/2016)
since there's a work around for that, as well, I can live with the idea that the relational purists have of not returning anything because a...
--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 14, 2016 at 9:15 am

#1864966
RE: But we've always done it that way…

andrew gothard (3/14/2016)
Wayne West (8/3/2015)
Fast/Cheap/Correct: choose two.
Also, bear in mind, if you fail to choose Correct, you can forget about the other two as well.
As Tom Tompson once...
--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 14, 2016 at 9:06 am

#1864962

Viewing 15 posts - 18,151 through 18,165 (of 59,102 total)