Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,011 through 23,025 (of 59,099 total)

RE: Getting It Right First Time. Almost?

Jim P. (8/5/2014)
lshanahan (8/5/2014)
I can imagine managers and directors saying, "What? You want another SQL Server license just for testing?"
I've always have gotten the reading from our legal staff 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)

August 5, 2014 at 10:13 pm

#1735465
RE: SQL Injection - Suggestion..!!!

Some of this has already been said but it's worth repeating...
Make sure that your password policies are strict and enforced.
Also, make sure that the logins for SQL Server and SQL...
--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 5, 2014 at 10:01 pm

#1735464
RE: SQL DBA high ended question (5+ years’ experience)

rajeshn29.dba (8/5/2014)
Hi Friends,
I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity
Thanks a lot ...
--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 5, 2014 at 9:50 pm

#1735462
RE: Table size is Huge!!!

smtzac (8/5/2014)
I have a database around 600 GB out of that A table is 398 GB, index size is 3 GB free space arund 5 GB. What are options do...
--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 5, 2014 at 9:40 pm

#1735461
RE: Loop or similar solution

Very cool. Glad to see someone with so much intellectual curiosity. Well done!
Also, thanks for the feeeddback on what you were looking for. I sometimes wonder if...
--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 5, 2014 at 8:46 pm

#1735458
RE: Loop or similar solution

P74 (8/5/2014)
Hi Lynn, I do use CTEs, but i've never specified the column names in that way... i just normally go "with myCTE as (select col1,col2 from tab1)". is 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)

August 5, 2014 at 3:22 pm

#1735401
RE: Are the posted questions getting worse?

Eirikur Eiriksson (8/5/2014)
So this incedent was not a bug after all, it was a pork chop.
Heh... I wonder if the lead developer's name was "Glon". 😛
--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 5, 2014 at 2:50 pm

#1735386
RE: Are the posted questions getting worse?

Eirikur Eiriksson (8/4/2014)
Jeff Moden (8/4/2014)
Eirikur Eiriksson (8/4/2014)
Koen Verbeeck (8/4/2014)
Lynn Pettis (8/4/2014)
Whom ever has the Great Mystical Crystal Ball, you are needed here.
I am afraid I have left it in my...
--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 5, 2014 at 9:21 am

#1735260
RE: Bulk insert statement cannto open file on the share

Lowell (6/30/2014)
pure permissions is the issue;
this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives...
--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 4, 2014 at 4:07 pm

#1734963
RE: Are the posted questions getting worse?

Koen Verbeeck (8/4/2014)
Lynn Pettis (8/4/2014)
Whom ever has the Great Mystical Crystal Ball, you are needed here.
I am afraid I have left it in my other coat...
I'd let you borrow mine......
--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 4, 2014 at 3:34 pm

#1734961
RE: Are the posted questions getting worse?

Eirikur Eiriksson (8/4/2014)
Koen Verbeeck (8/4/2014)
Lynn Pettis (8/4/2014)
Whom ever has the Great Mystical Crystal Ball, you are needed here.
I am afraid I have left it in my other coat...
I'm relying on...
--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 4, 2014 at 3:33 pm

#1734960
RE: Are the posted questions getting worse?

Alvin Ramard (8/4/2014)
GilaMonster (8/4/2014)
If the questions have worn you out, may I suggest a couple of maths limericks?
http://iwastesomuchtime.com/on/?i=93785
A dozen, a gross and a score
plus three time the square root 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 4, 2014 at 3:32 pm

#1734959
RE: Generating Hex on Insert

Also be aware that the trigger is setup to handle one and only one insert at a time. If you have a multirow insert, only 1 row will ever...
--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 4, 2014 at 2:03 pm

#1734941
RE: DBA vs Developer

Heh... no. Nothing stops a properly launched pork chop. 😀
--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 3, 2014 at 8:27 pm

#1734721
RE: Loop or similar solution

Lynn's code is excellent for this problem.
I've modularized it a bit to make it reusable depending on your needs and have added a couple of extra columns to the output,...
--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 3, 2014 at 8:25 pm

#1734720

Viewing 15 posts - 23,011 through 23,025 (of 59,099 total)