Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,876 through 16,890 (of 59,067 total)

RE: Who can afford Senior DBA?

ebooklub (9/7/2016)
Recently I applied thought recruiting agency as contractor for several DBA positions
Recruiters agree on asking rate, applications was submitted, few days later recruiters responded that clients looking for intermediate...
--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 7, 2016 at 10:37 am

#1899623
RE: tempdb default directories SQL 2016

I guess my question would be, "Who Cares"? 😀 If you're using the defaults, then you've probably done it wrong. 😉
--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 7, 2016 at 8:43 am

#1899596
RE: Who can afford Senior DBA?

Thanks, Eric. "I've been looking for a term to describe it and "IT Darwinism" is perfect.
--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 7, 2016 at 8:34 am

#1899594
RE: Does Log Data Belong in a Table or a File?

From the Article:
As we talked about options for accomplishing this, another member of the team remarked that all log data should go in files, period.
Heh... I'm busy. Real busy....
--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 6, 2016 at 4:18 pm

#1899485
RE: Split and Set values for the fields in Stored Procedure

mcfarlandparkway (9/6/2016)
Hello,
I am trying to get loc 1 and loc2 columns from a table.
We have another 2 columns...
--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 6, 2016 at 3:38 pm

#1899481
RE: NCAs and NDAs

I've rewritten every NCA/NDA that I've been told to sign as a "condition of employment" because they are entirely too restrictive. If I followed most as the letter 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)

September 6, 2016 at 12:05 pm

#1899431
RE: table partitioning

arkiboys (9/3/2016)
Hello,
I am a beginner in this topic.
Is there a simple tutorial somewhere which shows me how to partition a table by month?
I have not been able to find such...
--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, 2016 at 10:22 am

#1899095
RE: questions about sql

coool_sweet (8/28/2016)
hi
i have following questions :
(1)how to find nolock?
(2) can a table have only non cluster index?
(3) Design a package to transfer 10 files from FTP and store them to...
--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, 2016 at 3:18 pm

#1899060
RE: Architecture for 100,000+ transactions/sec

You should contact MS directly. I'm sure they'd be glad to provide some information on this.
--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 1, 2016 at 10:43 pm

#1898924
RE: Are the posted questions getting worse?

Thanks for the awesome compliment, Lynn. It's a two way street, though. I've learned a lot from you and the others, as well. As I've said so...
--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 1, 2016 at 9:03 am

#1898795
RE: Are the posted questions getting worse?

GilaMonster (9/1/2016)
I uploaded the slide-deck in progress. Comments?
http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948
I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.
Looks good, Gail.
Just 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)

September 1, 2016 at 8:43 am

#1898785
RE: Prevent DB creation

Sreejith! (8/31/2016)
Hello,
I would like to prevent users from creating databases on a specific disk(say D :),as there is not enough room for any new DB's & available space can be...
--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 1, 2016 at 6:31 am

#1898739
RE: Estimate single record growth size calculation

SQL Galaxy (9/1/2016)
Hi.
There is one table record counts are one month total = 199034556, so how can we estimate total estimate size of table?
Per Record size 8KB, 199034556*8 = 1592276448KB,...
--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 1, 2016 at 4:54 am

#1898721
RE: Avoiding Stored Procedures

David.Poole (8/31/2016)
Indianrock (8/31/2016)
Is this relevant? Hardware may be cheaper than experienced developers and DBAs who could actually develop the sophisticated procs which could handle complicated business logic.
In many 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)

August 31, 2016 at 11:02 am

#1898610
RE: Email Formatted HTML Table with T-SQL

tgqthi (8/30/2016)
Jeff Moden (3/15/2016)
tauseef.jan (3/15/2016)
Thankyou so much for the code snippet.
But I have a problem, that I have EMPTY(NULL) columns.
because of this the columns in the email get shifted to...
--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 31, 2016 at 10:02 am

#1898602

Viewing 15 posts - 16,876 through 16,890 (of 59,067 total)