Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,121 through 18,135 (of 59,069 total)

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
RE: Bit of a "Newbie" question. Compare and join databases.

davros30 (3/13/2016)
SQLC is another good tool that will meet your needs. RedGate is also a very good tool but it is expensive.
SQLC is very affordable. You can download...
--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 13, 2016 at 10:04 pm

#1864832
RE: PowerBI Desktop - CALENDAR() function

pietlinden (3/13/2016)
No, I'm using the Calendar table as a Dimension so I can lump sales etc into "bins" -- summarize by Year/Month whatever.
While that works and can be fairly well...
--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 13, 2016 at 4:11 pm

#1864818
RE: Single Sign On between Forests

steve.wouden (3/13/2016)
I agree with you Jeff, but management is going to need more from me then calling them idiots 🙂
Thanks
Heh... totally agreed especially since it was probably that same management...
--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 13, 2016 at 2:24 pm

#1864816

Viewing 15 posts - 18,121 through 18,135 (of 59,069 total)