Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,571 through 27,585 (of 59,101 total)

RE: Acing an Audit

I agree with what I believe the premise of the article to be. If you have to actually spend any significant time preparing for an audit beyond setting up...
--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, 2013 at 10:45 am

#1583729
RE: Cramming for Interviews

Gary Varga (1/21/2013)
Jeff Moden (1/18/2013)
lewandot (1/17/2013)
You can teach them SQL.
I'm finding that to be less and less true. Some people will never actually get it.
Unfortunately, it appears to 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)

February 3, 2013 at 10:36 am

#1583727
RE: Cramming for Interviews

Steve Jones - SSC Editor (1/22/2013)
Jeff Moden (1/18/2013)
lewandot (1/17/2013)
You can teach them SQL.
I'm finding that to be less and less true. Some people will never actually get it.
I'm not...
--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, 2013 at 10:21 am

#1583726
RE: Database Design question regarding Normalized Tables

kramaswamy (2/2/2013)
Stores may not have been the best example to use 😛 How bout, let's say, information about a client - the client's home address, name, etc...
The only reason I'm...
--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, 2013 at 10:06 am

#1583723
RE: Microsoft Certified Master

Vedran Kesegic (12/15/2012)
SQLCharger (12/14/2012)
I've interviewed people with high scores in MCTS/MCITP exams and was unimpressed with their actual knowledge (I hope we understand what the real issue is) 😉
Only two...
--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, 2013 at 11:39 pm

#1583688
RE: Calculating Running Totals for Today and Today Last Year

One of my principles of the help I get on this forum is to never put a line of code in production I don't completely understand.
That's absolutely the correct spirit!
I...
--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, 2013 at 11:14 pm

#1583687
RE: Antipathy for Entity Attribute Value data models

David.Poole (2/1/2013)
One comment I didn't understand in the feedback in this thread was about SQL_Variant making rubbish of the points in my article. I know it wasn't you who...
--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, 2013 at 10:46 pm

#1583685
RE: Antipathy for Entity Attribute Value data models

Heh... at least you know what you'll be doing every day, Steven. 😉 And, you can buy shoes by the pallet at Walmart with just a little notice! 😛
I...
--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, 2013 at 10:03 pm

#1583684
RE: Help Re Indexing

Vertigo44 (2/1/2013)
Hi, I have a 28 GB SQL 2000 Database that is in need of a re index. I am currently running DBCC DBREINDEX on all tables within My_DB 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)

February 2, 2013 at 8:09 am

#1583659
RE: Issue with crypt_gen_random

_simon_ (2/1/2013)
This is my scalar function, which returns numbers between @min-2 and @max-2 (both included):
create function GetRandom(@min int, @max-2 int)
returns int
as
begin
declare @diff int = @max-2 - @min-2 + 1
return @min-2...
--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 1, 2013 at 9:04 pm

#1583634
RE: Script to send alert when jobs runs more than 24 hours

Ironically, you're working on the wrong problem. You should be working on making the job take less than 24 hours. Peel one potato at a time by finding...
--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 1, 2013 at 7:37 pm

#1583629
RE: Calculating Running Totals for Today and Today Last Year

DataAnalyst011 (2/1/2013)
Thanks again, Dwain. That is super helpful. I was inner joining on the date column, and while it didn't leave NULLs, it also kicked out several rows (whereas 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)

February 1, 2013 at 7:14 pm

#1583627
RE: Encryption noob with a table design general question

Michael Valentine Jones (2/1/2013)
William Plourde (2/1/2013)
ok, I think I understand that. So if fetching the 'common' un enc data just make sure I use the appropriate field list in 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)

February 1, 2013 at 7:06 pm

#1583626
RE: Create a Column That holds the SUM of values in the same field where The Invoice Number is the same

anthony.green (2/1/2013)
ChrisM@Work (2/1/2013)
Or this:
SELECT
T1.IDCUST,
T1.IDINVC,
T2.AMTPAYM,
TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)
FROM MyTable1_ARIBH T1
INNER JOIN MyTable2_ARTCP T2
ON T2.IDCUST = T1.IDCUST
AND T2.IDINVC = T1.IDINVC
WHERE...
--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 1, 2013 at 6:51 pm

#1583625
RE: Pivot

farooq.hbs (2/1/2013)
Hi guys,
I have table with sample data below.
I want to retrieve the record for the fiscal year FY-12 i.e Between 01-10-2012 to 30-09-2013..One year data
WorkId ...
--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 1, 2013 at 6:48 pm

#1583624

Viewing 15 posts - 27,571 through 27,585 (of 59,101 total)