Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,626 through 23,640 (of 59,099 total)

RE: Planning for converting text, ntext, and image columns

webrunner (5/20/2014)
Hello experts,
I'm working on an upgrade to SQL Server 2012. One of the things that came up is that the text, ntext, and image are being deprecated. So although...
--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)

May 20, 2014 at 5:04 pm

#1715185
RE: Inserting multiple records from a single variable

jhinch (4/24/2014)
Here is an example to further clarify the question;
Table1
Job
1
2
3
Table2
Job Item
1 ...
--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)

May 20, 2014 at 4:50 pm

#1715181
RE: Inserting multiple records from a single variable

MMartin1 (5/20/2014)
You don't necessarily need to use a join, try the WHERE EXISTS clause. Look it up on MSDN.
WHERE EXISTS requires an Equi-Join within the sub-query.
--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)

May 20, 2014 at 4:49 pm

#1715180
RE: Saving Password in SSIS Configurations

greeshatu (5/19/2014)
Please let me know how to store password permanently in configurations
I'll be the first to admit that I don't know much about SSIS but my personal feeling is 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)

May 20, 2014 at 4:40 pm

#1715179
RE: Why Don't We Have Better Practices?

My personal feeling is the we have great "practices" in this industry and the last thing in the world that I'd want is for some RDBMS (like Oracle) start telling...
--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)

May 19, 2014 at 12:30 pm

#1714752
RE: SQL Server 2012 Insane Licensing Price!

hmischel (5/16/2014)
I am not very interested in the price difference between SQL Server and Oracle.
I need to deliver database performance and reliability to our Fund and stay within budget
Our annual...
--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)

May 19, 2014 at 12:26 pm

#1714750
RE: Comparing Different Data Types

Short, sweet, and to the point. This would be a great intro into what ORMs can do to do you if you don't pay attention. Nice article 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)

May 19, 2014 at 10:12 am

#1714707
RE: best practices for storing ssn?

Maxer (5/18/2014)
A company I work with stores all HR data for all past and present employees in a table that has SSN, DOB, address, and full name.
This sort of sets...
--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)

May 18, 2014 at 5:29 pm

#1714499
RE: Master thesis on Business Intelligence

I'd still like to know what the subject of the thesis 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)

May 18, 2014 at 5:18 pm

#1714498
RE: DBO.SysJobHistory, how do you get the Job Time?

Lynn Pettis (5/2/2014)
Instead of all the conversions you could use the scalar function msdb.dbo.agent_datetime.
For example:
declare @rundate int, @runtime int;
set @rundate = 20140502;
set @runtime = 512;
select msdb.dbo.agent_datetime(@rundate,@runtime);
While that's convenient, if you...
--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)

May 18, 2014 at 11:46 am

#1714483
RE: Need help with creating unique constraint.

@Eirikur,
What are you using to make the nice text version of ERDs like you have above and where can I get a copy?
--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)

May 17, 2014 at 6:54 am

#1714402
RE: Daily CSV

jayoub (5/16/2014)
I have been assigned a task to have a query, which a developer wrote, run against a database on a daily basis and have it generate a csv file...
--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)

May 17, 2014 at 6:51 am

#1714400
RE: Master thesis on Business Intelligence

amela.ajanovic90 (5/16/2014)
Thanks to everyone who filled out the questionnaire! I have posted on non technical sites as well, we have around 70 responses so far, but of course, the more...
--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)

May 16, 2014 at 11:35 am

#1714271
RE: Cursors

Stefan Krzywicki (5/15/2014)
Absolutely Jeff. My problem is that we're a SQL shop and he admits SQL cursors are horrible. I don't have access to other systems to show they're horrible...
--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)

May 15, 2014 at 7:16 pm

#1714067
RE: Bulk load data conversion error (truncation) ... I don't care if it truncates

J M-314995 (5/15/2014)
Right now I'm using SSMS but when I get everything put together, I'm going to throw the script into an SSIS package and put it on a schedule.
BULK...
--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)

May 15, 2014 at 6:57 pm

#1714065

Viewing 15 posts - 23,626 through 23,640 (of 59,099 total)