Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,161 through 26,175 (of 59,102 total)

RE: Adding Columns to report if no data in a given period

The missing months don't need to appear for any of the companies if you use a calendar table or a smaller table with just the months of interest in 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)

August 19, 2013 at 11:19 pm

#1642945
RE: SQL backup on Cluster shared drive or Local drive.

The shared drive is normally some pretty expensive high speed hardware. I'd rather put the backups on a simple and much less expensive network share somewhere. A couple...
--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 19, 2013 at 11:15 pm

#1642943
RE: Shrink does not release space

Erland Sommarskog (8/19/2013)
REORGANIZE essentially performs a bubble-sort of the index. The pages are not changed, so if a page is only 50 % full, it will remain 50% full.
I'm pretty...
--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 19, 2013 at 6:39 am

#1642647
RE: Help on query

vignesh.ms (8/19/2013)
@jeff Moden
Case is doing good ..
but that question was not for the case solution. that's for Erland's Query...
Understood. I just wanted to make sure that you weren't overlooking...
--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 19, 2013 at 6:33 am

#1642644
RE: Help on query

@vignesh.ms ,
I have to ask... was there something that the simple CASE statement solution wasn't doing for you?
--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 19, 2013 at 4:24 am

#1642606
RE: Use a CTE to calculate running total instead of using the SSRS function?

pietlinden (8/18/2013)
Getting closer, I think.... really should have heeded my professor's advice and used a smaller dataset, but anyway! I think this is right
SELECT ProtocolNo
, WeekNumber
, Goal
-- ADD RTGoal...
--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 18, 2013 at 7:25 pm

#1642531
RE: Should He Stay or Should He Go?

L' Eomot Inversé (8/18/2013)
BTW, I hope you don't really believe that 2008 was only 3 years ago. :w00t:
Crap. I knew I should have changed the BIOS battery 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)

August 18, 2013 at 7:19 pm

#1642529
RE: Script to montior ErrorLog every 1 hour

I think you only need one temp table, though.
--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 18, 2013 at 12:32 pm

#1642515
RE: Shrink does not release space

My apologies. The "reorganize" option is a leftover in my mind from me only doing these types of things via the GUI simply because it's so rare that I'd...
--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 18, 2013 at 12:22 pm

#1642513
RE: Very strange performance issue

Erland Sommarskog (8/18/2013)
Jeff Moden (8/18/2013)
Even if it coud be done efficiently, I'd still like to know why someone is building a result set that contains 20 million rows.
So Curious_sqldba did...
--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 18, 2013 at 12:12 pm

#1642512
RE: how to view log files

a9727 (8/18/2013)
I'm trying to find out who deleted data.
I agree with Gail. If you're in the FULL recovery mode and are doing backups correctly, there's a pretty good chance...
--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 18, 2013 at 12:09 pm

#1642511
RE: Use a CTE to calculate running total instead of using the SSRS function?

If you have 2012, then there's some "new" functionality in the SUM() OVER fuction that will do this nicely for you.
If you have 2008 or 2005, then a recursive CTE...
--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 18, 2013 at 11:44 am

#1642510
RE: Should He Stay or Should He Go?

I guess it depends. I'm linked to probably 50 or 60 thousand posts where I get an email anytime someone responds to one of them no matter how old...
--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 18, 2013 at 11:33 am

#1642508
RE: Very strange performance issue

Even if it coud be done efficiently, I'd still like to know why someone is building a result set that contains 20 million rows.
--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 18, 2013 at 11:16 am

#1642504
RE: Shrink does not release space

jfgrocha (8/16/2013)
Hi Jeff,
I'm not sure If I understood your question, but I running the command DBCC SHRINKFILE('name').
You said you rebuilt some of the indexes. You might not have rebuilt...
--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 18, 2013 at 11:14 am

#1642503

Viewing 15 posts - 26,161 through 26,175 (of 59,102 total)