Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,666 through 19,680 (of 59,072 total)

RE: SQL Backups

jasona.work (8/28/2015)
Ricky, you are correct about basing the TLog backups on how much data loss is acceptable.
In my case, the actual data loss customers agree too (not my call) is...
--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 7:42 pm

#1824524
RE: The Problem Solver

Andy Warren (8/31/2015)
Jeff,
I wonder if the life of a DBA isn't different than most because of the complexity compared to other systems. I'm not an Exchange/Sharepoint/whatever/whatever guy, but it sure...
--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 7:37 pm

#1824523
RE: Percentage of Fragmentation increased after 6 hours

coolchaitu (9/1/2015)
Dear Jeff,
In that case, how to find unused indexes.
You can still use the information in sys.dm_db_index_usge_stats to guide you. You just don't want to do it based...
--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 7:09 pm

#1824520
RE: Can't release space of temdb

sriponraj (9/3/2015)
Check the connection for temp db by using sp_who2 active. Kill all the connection related to temp db and try to shrink..
So, if the run you kill is 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 3, 2015 at 5:13 pm

#1824511
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

Viewing 15 posts - 19,666 through 19,680 (of 59,072 total)