Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,781 through 15,795 (of 59,098 total)

RE: Loading Non Duplicated Data Using SSIS

Shifting gears a bit, I wouldn't use SSIS for any of this other than maybe a process controller. Between things like WITH IGNORE DUPLICATES as a part of an index...
--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)

January 31, 2017 at 9:56 pm

#1925993
RE: Finding Within dates

Suth - Friday, January 27, 2017 4:31 AM
Hi
Im new to sql and I have a date column created , 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)

January 31, 2017 at 9:51 pm

#1925992
RE: Finding Within dates

Thom A - Friday, January 27, 2017 5:19 AM
CREATE TABLE #Date (DateColumn DATE)
GO
INSERT INTO #Date
SELECT '01-Jan-2017';
GO
SELECT CASE WHEN DateColumn...
--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)

January 31, 2017 at 9:41 pm

#1925991
RE: DUPLICATING A ROW BY NUMBER OF OCCURENCE OF A PARTICULAR FIELD IN ANOTHER TABLE

JALLY - Tuesday, January 31, 2017 4:09 PM
drew.allen - Tuesday, January 31, 2017 3:55 PM
--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)

January 31, 2017 at 9:32 pm

#1925989
RE: FAQ: Using the new forum Software (Jan 2017)

xsevensinzx - Friday, January 13, 2017 10:59 PM
All I want to know is how in the world did Jeff get his gif...
--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)

January 31, 2017 at 9:26 pm

#1925988
RE: Check who deleted entry from msdb..restorehistory table

SQL-DBA-01 - Tuesday, January 31, 2017 1:44 PM
Hello Experts
I found that someone had deleted few random entry from msdb..resorehistory table. Is 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)

January 31, 2017 at 4:45 pm

#1925978
RE: Loading Non Duplicated Data Using SSIS

Nakul Vachhrajani - Monday, January 30, 2017 11:58 PM
Jeff Moden - Monday, January 30, 2017 11:51 PM
--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)

January 31, 2017 at 3:44 pm

#1925971
RE: How to write a string to a file in SQL.

What's wrong with the BCP solution, Ben?
--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)

January 31, 2017 at 12:18 pm

#1925934
RE: Any ideas on bad query plan?

Instead of posting pictures of the execution plans, save then as files and attach them. Also, that last outer join has no chance of being SARGable as both columns must...
--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)

January 31, 2017 at 12:16 pm

#1925932
RE: The New DBA is a Developer

jasona.work - Monday, January 30, 2017 2:11 PM
Jeff Moden - Sunday, January 29, 2017 4:42 PM
--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)

January 31, 2017 at 7:56 am

#1925868
RE: Loading Non Duplicated Data Using SSIS

Nakul Vachhrajani - Monday, January 30, 2017 11:38 PM
csj - Monday, January 30, 2017 11:18 PM
--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)

January 30, 2017 at 11:54 pm

#1925770
RE: Loading Non Duplicated Data Using SSIS

Nakul Vachhrajani - Monday, January 30, 2017 10:34 PM
The problem is scalability. Aggregations are blocking transforms. Hence, they block the data flow...
--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)

January 30, 2017 at 11:51 pm

#1925769
RE: SQL Pivot Query

Very cool, Phil. Now I know what to look for. I appreciate 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)

January 30, 2017 at 4:58 pm

#1925754
RE: SQL Pivot Query

drew.allen - Monday, January 30, 2017 11:29 AM
I would recommend that you use a reporting tool such as SSRS to produce these...
--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)

January 30, 2017 at 1:17 pm

#1925720
RE: Need help with bcp

The "DIR" command I posted wasn't supposed to export the file. It was supposed to test to see if SQL Server could see the share. Can you post 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)

January 30, 2017 at 1:03 pm

#1925719

Viewing 15 posts - 15,781 through 15,795 (of 59,098 total)