Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,041 through 17,055 (of 59,067 total)

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
RE: SQL backup Script is appending instead of overwriting

mwinn (8/11/2016)
Thanks, I will try that, not sure why it worked for all these years prior to yesterday though.
To be honest, it couldn't have UNLESS you changed the file name...
--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:05 pm

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

p.s. NEVER use that type of Dynamic SQL in anything that's public facing, especially where modeltrim_name (in this case) could be entered by users, because it IS susceptible 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)

August 11, 2016 at 10:49 pm

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

Here's the Dynamic CROSSTAB version. I believe you might find it a little easier to read, modify, and troubleshoot.
--===== Local Variables
DECLARE @sql ...
--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 10:40 pm

#1895153
RE: Tablix assistance please!

faulknerwilliam2 (8/11/2016)
I am currently using SSRS 2008R2. This is the script I am using:
SELECT
a.name,
DATENAME(M, a.Date) as Month,
DATENAME(YEAR,a.Date) as Year,
DATEPART(YYYY, a.Date) as...
--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 9:03 pm

#1895149

Viewing 15 posts - 17,041 through 17,055 (of 59,067 total)