Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,071 through 17,085 (of 59,101 total)

RE: Bash for ETL pre-processing

Heh... let's talk about "open minded"...Now all we have to do is get people over the fear of using xp_CmdShell and over the love affair with SSIS and you might...
--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)

August 15, 2016 at 5:29 am

#1895402
RE: Are the posted questions getting worse?

ThomasRushton (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. 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)

August 15, 2016 at 3:52 am

#1895387
RE: power script to find backup status in sql server

John Mitchell-245523 (8/15/2016)
Jeff
Does your job highlight just jobs that failed, or does it include those that didn't run, perhaps because they were accidentally disabled, or because SQL Server Agent wasn'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)

August 15, 2016 at 3:43 am

#1895386
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Sergiy (8/14/2016)
sknox (8/14/2016)
Sergiy (8/14/2016)
There are other aspects which were not mentioned by anyone.
1. The same small query populating a temp table may be reused in several procedures.
In such case its...
--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)

August 15, 2016 at 3:29 am

#1895385
RE: database stuck in restoring state

I don't know why no one answered this for you and I hope you weren't waiting on the answer.
Step one would be to restore your dev database and get 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)

August 14, 2016 at 1:53 pm

#1895360
RE: TRUNCATING MULTIPLE TABLES

pietlinden (5/11/2015)
And then just to yank Jeff's chain...
I know my response is a bit late but, remember... "Santa is watching". 😀
--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)

August 14, 2016 at 1:32 pm

#1895359
RE: Parallel insert in a table

sqlenthu 89358 (8/14/2016)
Hi All,
Is there a way to perform parallel inserts in a table ? I have any huge table in one database and I want a big chunk 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)

August 14, 2016 at 1:11 pm

#1895358
RE: power script to find backup status in sql server

John Mitchell-245523 (8/10/2016)
I agree with Jeff - no need for PowerShell. Write a view or stored procedure, and create a job to e-mail the results.
I don't share Jeff's doubt...
--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)

August 14, 2016 at 11:26 am

#1895357
RE: Count the occurrence of word in a Resume Table

Alan.B (8/8/2016)
.. I want to display the candidate rank as an avg of all the three columns .
Using my sample data from earlier, the best way would be like so:...
--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)

August 14, 2016 at 11:20 am

#1895356
RE: I need the list of those left and right side members list in binary tree along with sum(Amount Invested under his left and right side).

chintangandhi007 (8/12/2016)
I am making the study project in college.
I don't mind helping someone with school but they do have to try on their own. If you're "making a study...
--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)

August 14, 2016 at 10:57 am

#1895354
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Another take away should be...
1. If you have multiple solutions and some favor CPU while others favor IO, then you've missed a solution because you shouldn't have to settle....
--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)

August 14, 2016 at 10:48 am

#1895352
RE: SSRS vs. T-SQL - Query Response Time

dreamornightmare1 (7/9/2012)
I have the exact same problem stored proc 19 second SSRS version unig same parameters 40 + minutes and still going. Anyone have a solution for this SSRS...
--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)

August 14, 2016 at 9:56 am

#1895351
RE: Replace of isnull as 0 for dynamic pivot

Anandkumar-SQL_Developer (8/12/2016)
Dear SSC-Forever ,
Really u r genius....
--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)

August 12, 2016 at 4:21 pm

#1895309
RE: need to copy a 600 gig table

Snargables (8/12/2016)
Sorry guys. This was a drive by. A quick post in the heat of the moment. I thought i was going to have to change the identity on 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)

August 12, 2016 at 4:12 pm

#1895308
RE: How do you manage your junior DBA

S7 (8/10/2016)
Thanks, Operational dba. The person didn't have a dba background but came from application support. I'm a senior DBA and the person was hired to help me. Doesn't report...
--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)

August 11, 2016 at 11:50 pm

#1895158

Viewing 15 posts - 17,071 through 17,085 (of 59,101 total)