Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,631 through 21,645 (of 59,098 total)

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
RE: Is it possible to embed a parameter in the name of stored procedure that's called from within another sproc?

CELKO (2/2/2015)
These report periods can overlap or have gaps. I like the MySqL convention of using double zeroes for months and years, That is 'yyyy-mm-00' for a month within 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)

February 2, 2015 at 10:04 pm

#1774934
RE: Should I create an SP

Have an old app that imports data into a MSSQL server DB using an ODBC connection.
To be honest, because of the CID=1 thing, all of the solutions so far look...
--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 6:22 pm

#1774917
RE: sum result type character

elkinfortiz (2/2/2015)
If your analysis is correct. But this strip of operations corresponds to an interpretation of fields, sort of mini compiler, which translates : ' (WIDTH / 3 ) +...
--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:58 am

#1774857
RE: Swap Firstname lastname

sharonsql2013 (2/2/2015)
I was joining two tables on PersonFullname column when found that one tables has PersonFullname as Roger, Sharon whereas the other has Sharon Roger
How can I swap...
--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:55 am

#1774856

Viewing 15 posts - 21,631 through 21,645 (of 59,098 total)