Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,616 through 21,630 (of 59,098 total)

RE: Looking for suggestions

Jim Youmans-439383 (2/4/2015)
I have a full time day job but am very interested in branching out with some side work but not sure how best to look for it. ...
--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 5, 2015 at 9:34 am

#1775755
RE: Get Date Of Tuesday of Past x Years From Now

ScottPletcher (2/5/2015)
Jeff Moden (2/4/2015)
RamSteve (2/4/2015)
The Solution is as below
That's one solution but it relies on @@DATEFIRST which is subject to change based on selected language and other things. ...
--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 5, 2015 at 9:26 am

#1775751
RE: Barcode 128 generator (using scalar function)

mister.magoo (2/5/2015)
Hi Jeff,
I have one also that handles A, B and C
http://www.sqlservercentral.com/Forums/FindPost1470956.aspx
Absolutely awesome! I could be wrong but it doesn't look like it would handle the "SHIFT", "CODE", 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 5, 2015 at 8:35 am

#1775727
RE: Barcode 128 generator (using scalar function)

a_ud (2/17/2011)
I'm looking for a barcode generating Function that uses the standard Code128. Apparently no function that fixes this has been posted before in the forum.
The way the barcode functions...
--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 11:44 pm

#1775575
RE: Barcode 128 generator (using scalar function)

Ewan Hampson (4/8/2013)
The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ,...
--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 9:46 pm

#1775560
RE: Barcode 128 generator (using scalar function)

a_ud (6/26/2014)
The VBA code attached to my 1st message works and it's not that difficult to translate to other languages.
If that were true, you wouldn't be asking for help, now...
--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 9:40 pm

#1775559
RE: BCP not copying

BCP cannot import .XLS (Excel spreadsheet) files... period. If you're trying to import a spreadsheet to SQL Server via T-SQL, you need to use the "ACE" drivers and either...
--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 8:30 pm

#1775548
RE: Get Date Of Tuesday of Past x Years From Now

RamSteve (2/4/2015)
The Solution is as below
SELECT CONVERT(VARCHAR,DATEADD(yy, -@x, DATEADD(D, -((@@DATEFIRST + DATEPART(DW, DATEADD(yy,-@x ,GETDATE()) ) -3) % 7), GETDATE())) ,23)
That's one solution but it relies on @@DATEFIRST which is...
--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 6:37 pm

#1775528
RE: Question related to indexes?

New Born DBA (2/4/2015)
This particular SQL Statement runs around 200,000 times a day, goes through millions of logical reads and when I look at the execution plan, it shows 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 3:52 pm

#1775503
RE: Are the posted questions getting worse?

Sean Lange (2/4/2015)
Sioban Krzywicki (2/4/2015)
Sean Lange (2/4/2015)
Sioban Krzywicki (2/4/2015)
Grant Fritchey (2/4/2015)
Eirikur Eiriksson (2/4/2015)
Sioban Krzywicki (2/4/2015)
Grant Fritchey (2/4/2015)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what...
--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 3:47 pm

#1775502
RE: Question related to indexes?

New Born DBA (2/4/2015)
Lowell (2/4/2015)
to satisfy that specific query, i think an index on the four columns involved int he WHERE clause is needed, and INCLUDE all the columns in...
--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:48 am

#1775420
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

Viewing 15 posts - 21,616 through 21,630 (of 59,098 total)