Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,601 through 21,615 (of 59,072 total)

RE: Question related to indexes?

All non-clustered indexes are a duplication of data and, along with that realization come concerns about disk space, backup times, and restore times especially where wide covering indexes with INCLUDES...
--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)

February 4, 2015 at 10:45 am

#1775419
RE: Trigger

WHAT has been the cause of the trigger failing? Specifically, what are the error message(s)?
--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)

February 4, 2015 at 10:38 am

#1775411
RE: practical advice arounding indexing and ETL?

Nevyn (2/4/2015)
KoldCoffee (2/4/2015)
Hi Nevyn, yes I'm doing one big merge statement from stage to final table. So, you are saying there is better approach.
Well, I am saying I suspect there...
--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)

February 4, 2015 at 10:36 am

#1775407
RE: practical advice arounding indexing and ETL?

What is the basis of the daily imports? Are they temporal in nature in that if the larger table had an index based on a particular datetime column, that...
--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)

February 4, 2015 at 10:07 am

#1775388
RE: Should I add a table for values that will never change?

dwain.c (2/3/2015)
Never say never!
One day you'll want to add "4 - prior customer" for a contact that used to be a customer but is no longer paying for your services.
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)

February 3, 2015 at 11:11 pm

#1775199
RE: backup tool

Sorry. I may have jumped the gun a bit on that recommendation. Again, I'm a bit ignorant as to what some of these central backup systems do by...
--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)

February 3, 2015 at 11:02 pm

#1775198
RE: What is the best practice about maintain and using Big Log Database

To cover some of what has been said, 35 inserts per second should be trivial for a well written audit system. It's usually the tables or a shedload 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)

February 3, 2015 at 10:53 pm

#1775196
RE: What is the best practice about maintain and using Big Log Database

MMartin1 (2/3/2015)
Eric M Russell (2/3/2015)
MMartin1 (2/3/2015)
Maybe I missed it somewhere but it seems as though you are reporting from the same system you insert into. You generally want to build...
--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)

February 3, 2015 at 10:47 pm

#1775195
RE: backup tool

I might be the only one but I don't care for central management tools for backups not because any of them are particularly bad but because if the box that...
--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)

February 3, 2015 at 10:42 pm

#1775193
RE: backup tool

To be honest, I'd use SQL Server native backups for such a small number of servers.
--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)

February 3, 2015 at 1:44 pm

#1775138
RE: Curious interview question

I've read/written from/to the registry for certain crazy imports back in the days of the JET drivers. I also use it to read the default backup directory paths that...
--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)

February 3, 2015 at 10:42 am

#1775087
RE: How to reduce MDF file size ?

Joy Smith San (2/3/2015)
Thanks Igor Micev and CodedSteve.
No much free space in the DB, so shrinking will not release any space to drive.
Shrinking log file is also not an...
--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)

February 3, 2015 at 10:37 am

#1775084
RE: Is it possible to embed a parameter in the name of stored procedure that's called from within another sproc?

CELKO (2/3/2015)
I will study your advice and I'm appreciative that I have been flamed by the famous Joe Celko. I've heard that you are tough but I don't mind...
--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)

February 3, 2015 at 8:37 am

#1775048
RE: Where do senior SQL DBAs land finally?

tcronin 95651 (2/2/2015)
If you want to be the blowhard at the SQL conferences that has to be listened to for affirmation go for it.
You sound a bit sour there (maybe...
--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)

February 2, 2015 at 11:14 pm

#1774939
RE: Database File Placement and number of files

HookSqlDba7 (2/2/2015)
Database File Placement Layout?
We are planning to implement a new SQL Server 2014 OLTP Database with a 1 TB Data file and 1 TB Log File. I am looking...
--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)

February 2, 2015 at 10:49 pm

#1774937

Viewing 15 posts - 21,601 through 21,615 (of 59,072 total)