Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,796 through 18,810 (of 59,072 total)

RE: The Most Common Query Blunders...

Grant Fritchey (12/28/2015)
Jeff Moden (12/28/2015)
Grant Fritchey (12/28/2015)
I have two presentations I do on best practices. Both slide decks are available on slideshare.net. That could act as a guide. Just give...
--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 28, 2015 at 9:04 am

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

Grant Fritchey (12/28/2015)
I have two presentations I do on best practices. Both slide decks are available on slideshare.net. That could act as a guide. Just give me some attribution if...
--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 28, 2015 at 7:44 am

#1848250
RE: Help me about Attach database

johnwalker10 (12/27/2015)
As the message already says, restore the database from the backup.
Or
- Detach the database
- Rename/Move the log file
- Attach the MDF database file without the LOG file; a new...
--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:20 pm

#1848207
RE: Salary vs contract rate?

BWAAAA-HAAA!!! To0 funny! But, Nah... a "wheelie" on a unicycle is the hop you need to do to go up the stairs.
--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:15 pm

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

Viewing 15 posts - 18,796 through 18,810 (of 59,072 total)