Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,696 through 19,710 (of 59,098 total)

RE: File group is running out of space frequently.

EasyBoy (9/3/2015)
I had a talk with senior person today. And he said they configured Limited file-growth to Unlimited. But at that time they were getting Drive space full alerts. And...
--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)

September 3, 2015 at 5:06 pm

#1824510
RE: Huge headache to work with big data

halifaxdal (9/3/2015)
With Luis' help, I just imported a huge data file into my local server/db on my laptop as well as a remote server (btw: The built-in import/export seems 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)

September 3, 2015 at 4:47 pm

#1824509
RE: Are the posted questions getting worse?

Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"
Nope. Just faked out the entire MSDN web...
--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)

September 3, 2015 at 11:34 am

#1824431
RE: Are the posted questions getting worse?

Grant Fritchey (9/3/2015)
AAAAARRRRGGGHHHH!
The STUPID! It burns.
No, no links. Just needed to scream in agony for a moment. Go about your lives.
Heh... I should do something like that once in 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)

September 3, 2015 at 11:32 am

#1824430
RE: Creating 15000 partitions

shamshad.ali (9/3/2015)
I googled for efficient way of archiving and found partitioning with several advantages. And Please let me know how do I resolve this if partitioning is much complex and...
--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)

September 3, 2015 at 11:08 am

#1824407
RE: Difference count

sgmunson (9/3/2015)
ramrajan (9/3/2015)
-- Find Quarter difference count
declare @enddate datetime = '2015-09-03 00:39:53.973'
declare @startdate datetime = '2014-11-07 00:42:39.920'
WITH Quarters AS (
SELECT Q = '1',...
--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)

September 3, 2015 at 9:29 am

#1824354
RE: Should I use money column to store amount related columns

I agree with Grant and Luis. I'll also tell you that if you store the calculations from interest calculations for things like amortization tables, don't just store the data...
--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)

September 3, 2015 at 9:21 am

#1824348
RE: Creating 15000 partitions

shamshad.ali (9/3/2015)
We have to move daily transactions on archive (daily bases we move day end data on archive DB) and I see that table partitioning can do this in better...
--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)

September 3, 2015 at 9:14 am

#1824343
RE: Interesting Design Issue

mar.ko (9/2/2015)
Thanks Jeff -
you are saying that if the table is properly indexed, I really don't need to use the view which will limit the look-back period and thus...
--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)

September 2, 2015 at 3:52 pm

#1824160
RE: Newbie saying Hi

Grant Fritchey (9/2/2015)
Lord Lucan (9/2/2015)
Thanks for the welcome folks.
Grant - You've lost me with your second reply 🙂
Lord Lucan. The Charge of the Light Brigade. The battle of Balaclava. 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)

September 2, 2015 at 3:50 pm

#1824159
RE: Not Exist causing major performance problem

GilaMonster (9/2/2015)
Jeff Moden (8/28/2015)
Before you go to all that trouble, try changing "postalid" to "*" or "1" in the not exists and see what happens.
That won't do anything. 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)

September 2, 2015 at 10:54 am

#1824081
RE: Newbie saying Hi

Welcome aboard!
--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)

September 2, 2015 at 8:28 am

#1824008
RE: Interesting Design Issue

mar.ko (9/2/2015)
Call center data - large volume....millions of rows.
When a sale is made, a column value is established with the Lead ID in the source data table.
I need to set...
--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)

September 2, 2015 at 8:27 am

#1824006
RE: Formatting a date affecting MIN

John Mitchell-245523 (9/2/2015)
Yes, or just do the conversion after calculating the minimum:
CONVERT(varchar(17),MIN(a.orderdue),103)
This has the added advantage that it only has to do the conversion once (on the minimum date) instead...
--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)

September 2, 2015 at 8:23 am

#1824005
RE: File group is running out of space frequently.

Alvin Ramard (9/1/2015)
EasyBoy (9/1/2015)
Thanks for your prompt response. I understand that we can't limited to growth. But, this is how they implemented tempdb. According to technet.microsoft if we have 200...
--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)

September 2, 2015 at 8:17 am

#1824000

Viewing 15 posts - 19,696 through 19,710 (of 59,098 total)