Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,826 through 18,840 (of 59,098 total)

RE: Copy all data from Database A. to Database B.

Eirikur Eiriksson (12/27/2015)
Jeff Moden (12/27/2015)
C@mel (12/27/2015)I don't want to restore a backup of A. to B.
I want a script to copy all data from A. to B.
WHY? To 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)

December 27, 2015 at 11:11 pm

#1848204
RE: Possible to insert unaffected by rollback?

If this is for a batch job, then make it easy on yourselves. Set the job up to capture any output from the run to a file. 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)

December 27, 2015 at 10:58 pm

#1848202
RE: Copy all data from Database A. to Database B.

C@mel (12/27/2015)I don't want to restore a backup of A. to B.
I want a script to copy all data from A. to B.
WHY? To what end? What 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)

December 27, 2015 at 10:46 pm

#1848200
RE: Salary vs contract rate?

Eirikur Eiriksson (12/26/2015)
Jeff Moden (12/26/2015)
I'm obviously living in the wrong part of the country (although I do have benefits, paid vacations, flexible hours, ability to work from home, and live...
--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)

December 27, 2015 at 3:28 pm

#1848190
RE: Salary vs contract rate?

JamesMorrison (12/26/2015)
I would say it should be about 20% more. Just my guess. I would like to hear other opinions on this.
Instead of relying on us amateurs, the absolute best...
--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)

December 26, 2015 at 4:21 pm

#1848139
RE: Maintenance Plans are not working as scheduled

stephend 55510 (9/24/2015)
I have a full backup that runs on a schedule once a month, differential that runs daily, and transaction logs that also runs daily. All backups 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)

December 26, 2015 at 4:12 pm

#1848138
RE: Salary vs contract rate?

I'm obviously living in the wrong part of the country (although I do have benefits, paid vacations, flexible hours, ability to work from home, and live close enough to work...
--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)

December 26, 2015 at 10:07 am

#1848117
RE: Comma separated values

sandeepmittal11 (12/26/2015)
Refer below post to understand how to display row values as a single comma separated values
Display row values as a single comma separated values
Again, not a bad article but...
--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)

December 26, 2015 at 10:03 am

#1848116
RE: The Most Common Query Blunders...

Jason A. Long (12/25/2015)
Jeff Moden (12/25/2015)
Jason A. Long (12/25/2015)
The one I came across a couple days ago...
WHERE LEN(t.SSN) = 9
as opposed to
WHERE t.SSN LIKE [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]
The LEN check doesn't do 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)

December 26, 2015 at 9:39 am

#1848115
RE: LEAP and LAG behind the scenes

sandeepmittal11 (12/26/2015)
Refer below post:
Lead and Lag functions in SQL Server
Not bad, Sandeep. Just a couple of comments...
It would be helpful if you added a bit more narrative to explain....
--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)

December 26, 2015 at 9:31 am

#1848112
RE: The Most Common Query Blunders...

Jason A. Long (12/25/2015)
The one I came across a couple days ago...
WHERE LEN(t.SSN) = 9
as opposed to
WHERE t.SSN LIKE [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]
The LEN check doesn't do it alone. It could allow...
--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)

December 25, 2015 at 3:40 pm

#1848086
RE: Omitting 'DISTINCT'

sql_only (12/25/2015)
I have the following code which is returning the required result, however I think I am coding it wrong because it runs really slow on large data-sets and 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)

December 25, 2015 at 3:08 pm

#1848084
RE: Merry Christmas

For a more Yellow star (although terribly washed out thanks to transparency)...
DECLARE @g TABLE (g GEOMETRY, ID INT IDENTITY(1,1));
-- Adjust Color
INSERT INTO @g(g) SELECT TOP 29 CAST('POLYGON((0 0,...
--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)

December 25, 2015 at 3:04 pm

#1848083
RE: Merry Christmas

annjunk (12/25/2015)
Thanks! That is nice. I understand polygons with geometry, but can you please explain how you set the colors? Also, did you add the FROM sys.messages...
--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)

December 25, 2015 at 2:59 pm

#1848082
RE: How to use 'like' in a query

ScottPletcher (12/25/2015)
Since Transaction_Date contains the time, a query coded like this:
Activity.Transaction_Date BETWEEN '20151130' and '20151201'
Would return rows from 12/01/2015 at exactly midnight (if there were any). But that wouldn't...
--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)

December 25, 2015 at 2:00 pm

#1848074

Viewing 15 posts - 18,826 through 18,840 (of 59,098 total)