Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,221 through 20,235 (of 59,072 total)

RE: Skill Supply and Demand

Iwas Bornready (6/25/2015)
We had a new programmer talk us into using a complex tool set for a rewrite we were doing. After we got well into it, way to far...
--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)

June 25, 2015 at 7:42 am

#1808062
RE: How to subtract dates from previous date on same patient?

sachin.patke (6/24/2015)
Hi. Here's a quick script that returns all dates between two dates provided and whether that date is a weekend or not. you could use this in your scenario...
--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)

June 24, 2015 at 3:35 pm

#1807910
RE: server automatically reboots after windows updates

Steve Jones - SSC Editor (6/24/2015)
Or at least it's off your plate to worry about.
Heh... I'm a DBA... it doesn't matter what anyone else does, it's part of my job...
--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)

June 24, 2015 at 1:33 pm

#1807877
RE: Evaluating Rows to identify >=3 months of consecutive dates and exclude first and last month

Thank you both for the feedback.
For those that may not understand how the formula for the "Grp" column works, you can find an explanation of the principle in the article...
--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)

June 24, 2015 at 1:19 pm

#1807873
RE: Bulk inserts in batch

craig.g.smith (6/24/2015)
Still wondering why an insert select is slower than a select into -- why don't they do the same thing? I wish there were a way to turn...
--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)

June 24, 2015 at 11:46 am

#1807851
RE: Remove a value from a union

Dohsan (6/24/2015)
Execution plan puts #2 at a higher cost of the batch
Just a bit of a sidebar here. The execution plan is a wonderful research tool for improving...
--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)

June 24, 2015 at 9:54 am

#1807813
RE: Ghost in the machine?

Ok and agreed. Thanks for the feedback. I appreciate it.
--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)

June 24, 2015 at 9:47 am

#1807808
RE: SQL server 2014 features

roblew 15918 (6/24/2015)
Thanks Phil,
Don't suppose you know if you can get this free if you are an MCP?
If you look around, it only costs $44USD. We've all bought books...
--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)

June 24, 2015 at 9:18 am

#1807797
RE: Need Ammunition for Developers Doing Select *'s

To be honest, having Developers physically walk through the papers in the box example is annoying at best and, at worst, demeaning and will earn you a whole lot 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)

June 24, 2015 at 9:12 am

#1807792
RE: Avoiding if conditional to reduce CPU usage

Minaz Amin (6/23/2015)
Hi All,
I have a function with multiple if ( condition) which is CPU intensive. How could I avoid this.
CREATE FUNCTION prici.[fn_pricipalamt]
(
-- Add the parameters for the function...
--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)

June 24, 2015 at 8:54 am

#1807783
RE: Ghost in the machine?

I have to ask... why are you using SQLCMD for this task? A simple stored procedure is able to do these types of restores no problem (I have 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)

June 24, 2015 at 8:42 am

#1807776
RE: Remove a value from a union

Alvin Ramard (6/24/2015)
Deprecated? Why didn't I know that? Oh yes. I'm stuck on older versions of SQL Server.
Ah... hang on a minute while I get the egg off my face.
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)

June 24, 2015 at 8:13 am

#1807757
RE: Compare field to results from another table

DaveK2014 (6/24/2015)
Thanks Jeff I have tried both an inner and a left. The left seems to speed it up a bit.
Like I said previously, because of the WHERE NOT IN,...
--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)

June 24, 2015 at 7:43 am

#1807742
RE: Partition an existing SQL Server Table

Again...
1. With the understanding that the word "Archive" means "back it up and drop it from the database" to me, start off by taking a backup that you'll save 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)

June 24, 2015 at 7:41 am

#1807740
RE: Skill Supply and Demand

TheComedian (6/24/2015)
Labour shortage is a myth. Offer a very good salary (I'm talking 6 figures) and then you'll see how many great applicants you'll get.
With the interviews that I've...
--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)

June 24, 2015 at 7:07 am

#1807724

Viewing 15 posts - 20,221 through 20,235 (of 59,072 total)