Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,421 through 18,435 (of 59,098 total)

RE: purging old data and outer joins

Orlando Colamatteo (2/14/2016)
Jeff Moden (2/14/2016)
If you absolutely insist on deleting the rows, then learn to use EXCEPT between the Address table and the other tables (starting with the largest of...
--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)

February 14, 2016 at 7:30 pm

#1858709
RE: Like / Contains

If you're going to have to resort to such hacks as a "reverse" column especially for such a narrow column as a "Name" column, it's easier and better to simply...
--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)

February 14, 2016 at 7:14 pm

#1858708
RE: HEX conversions

One of many good reasons to always know your data and use explicit sizes for datatypes.
--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)

February 14, 2016 at 6:56 pm

#1858706
RE: Multiple standard instances on 32 core AWS machine

Roust_m (2/13/2016)
Hi,
I have four SQL instances (currently Enterprise) which I want to downgrade to Standard edition.
I can have couple of days downtime for the server, so I will be doing...
--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)

February 14, 2016 at 6:27 pm

#1858705
RE: Restoring a backup file on a remote server

himanshu.sinha (2/13/2016)
Thanks for the reply .
Well since the backup size is 200GB , I am not very comfortable using the UNC path but i will give it 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)

February 14, 2016 at 6:22 pm

#1858704
RE: Get Relation ship between TeamLead and SE

p.s. The VARBINARY(100) is good out to 25 levels. Since a Boeing 747 has a parts list that's only about 18 levels deep, that should suit just about anything...
--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)

February 14, 2016 at 6:11 pm

#1858703
RE: Get Relation ship between TeamLead and SE

suresh0534 (2/13/2016)
Hi,
Table Emp:
Id Name Designation Teamlead
2 Ravi TL ...
--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)

February 14, 2016 at 6:07 pm

#1858702
RE: purging old data and outer joins

Sergiy (2/14/2016)
In this case the best solution would be simply to stop the job.
Removing 1% of the records as an ultimate goal does not make much sense. Achieving it won't...
--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)

February 14, 2016 at 4:37 pm

#1858692
RE: SCAN vs. SEEK

greg6363 (2/14/2016)
[Err... Seek and scan are SQL's two internal operations for accessing indexes, they're not something you explicitly use.
What exactly are you trying to do? Post table definitions (as CREATE...
--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)

February 14, 2016 at 3:37 pm

#1858686
RE: Recursive data but increasing date by one day

steve.tarry (1/21/2015)
Thanks for the piece of code. Very nice. In the grand scheme of things the CTE query executes very quickly but happy to use a better solution.
Great stuff.
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)

February 14, 2016 at 2:35 pm

#1858682
RE: Bending strings

Jeff Moden (1/22/2015)
Steve Jones - SSC Editor (1/22/2015)
bump
<HeadDesk> My apologies. Major side tracks and I forgot about it. I'll resurrect it this weekend.
Crud. My apologies. ...
--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)

February 14, 2016 at 2:23 pm

#1858681
RE: Find Replace Text - Output

curious_sqldba (2/13/2016)
Hugo Kornelis (2/13/2016)
curious_sqldba (2/12/2016)
I have a script which basically scripts out all the users along with permissions needed, my script will spit a script that should be executed 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)

February 13, 2016 at 5:34 pm

#1858625
RE: DBA -tasks and solutions

I'll third that... Backups and test restores first. Security next and very soon... hopefully, the same day.
--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)

February 13, 2016 at 5:22 pm

#1858624
RE: How to extract overlapping date ranges from a table of date ranges

stig.benning (2/13/2016)
Hi Jeff, Thanks for the links and your suggestion. And for solving my problem 🙂 Stig
You bet. Thank you very much for the feedback.
--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)

February 13, 2016 at 12:37 pm

#1858605
RE: How do we get the definition of tables via sql

J Livingston SQL (2/13/2016)
Jeff Moden (2/13/2016)
mw112009 (2/12/2016)
Jeff M
What we need is to be able to do via T-SQL and also we need to get the def for all tables (...
--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)

February 13, 2016 at 10:25 am

#1858594

Viewing 15 posts - 18,421 through 18,435 (of 59,098 total)