Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,221 through 14,235 (of 59,097 total)

RE: Best method for coding stored proc SQL to get next key to avoid DUPs

Express12 - Friday, September 29, 2017 12:28 PM
Developer called. She need best practice to accommodate the following:
TableXYZ has a numeric KEY...
--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)

October 1, 2017 at 6:10 pm

#1961807
RE: Need to Change Compatibility Level of Lots of Databases

Just a bit of an FYI, I've not found it necessary to set the SINGLE USER mode in 2012 or 2016.
--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)

October 1, 2017 at 5:56 pm

#1961806
RE: deleting duplicate rows based on a condition

TheCTEGuy - Saturday, September 30, 2017 6:20 AM
ALERT - Deleting a value from a table should always be TRY CATCHED 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)

October 1, 2017 at 5:30 pm

#1961804
RE: The Worms-eye View

"DevOps" is not a process. It's a culture. It may support a process but it is not a process.
I also disagree with your notion of overspecialization. For example, someone...
--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)

October 1, 2017 at 5:26 pm

#1961803
RE: select from flat file

I need a bit more info to help. Are the columns separated by TABs or are they positional in that each field starts at the same character position for every...
--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)

October 1, 2017 at 5:02 pm

#1961802
RE: [Solved] Unpivot?

Vegeta7 - Sunday, October 1, 2017 4:32 PM
Thank you so much Jeff Moden! 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)

October 1, 2017 at 4:59 pm

#1961801
RE: Since looping is bad, how should I accomplish what I am trying to do?

rmcfaden - Saturday, September 30, 2017 9:04 AM
Jason,
OMG! 300K+ records output in 6 seconds versus what I was doing which took between...
--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)

October 1, 2017 at 4:38 pm

#1961800
RE: Since looping is bad, how should I accomplish what I am trying to do?

bmg002 - Friday, September 29, 2017 10:55 AM
If I understand your request properly, I THINK that this will do exactly what 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)

October 1, 2017 at 4:22 pm

#1961798
RE: [Solved] Unpivot?

The 3rd insert to your test data doesn't match your graphics so I made a change to the test data.

CREATE TABLE dbo.TableA
...
--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)

October 1, 2017 at 4:16 pm

#1961797
RE: select from flat file

MinhL7 - Sunday, October 1, 2017 2:45 PM
How do select from a flat file?

SELECT Field1
,Field2
,Field3
FROM OPENROWSET(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)

October 1, 2017 at 3:34 pm

#1961795
RE: Code-first vs database-first, any new developments?

David Burrows - Friday, September 29, 2017 1:51 AM
Jeff Moden - Thursday, September 28, 2017 3:59 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)

September 29, 2017 at 6:36 am

#1961607
RE: A New New World

Stefan LG - Thursday, September 28, 2017 11:00 PM
It was interesting that you mentioned Red Mars (by Kim Stanley Robinson) since 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)

September 28, 2017 at 11:47 pm

#1961519
RE: Adding second data file to quickly growing msdb

Eliyahu - Thursday, September 28, 2017 4:01 AM
Our SQL Server sends out a lot of emails. The msdb.data file grew up to...
--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)

September 28, 2017 at 4:33 pm

#1961497
RE: Create and Alter Table Permission only for specific schema

ejoell 66477 - Wednesday, September 28, 2011 2:22 PM
Grant create table to usernameGrant alter to username
Heh....
GRANT Perpetual Headaches to DBA
--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)

September 28, 2017 at 4:21 pm

#1961495
RE: SQL Server 6.5 available for download with manuals

patrickpartin - Thursday, September 28, 2017 3:10 PM
jefersonsenci - Wednesday, May 24, 2017 1:26 AM
Hi...
--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)

September 28, 2017 at 4:18 pm

#1961494

Viewing 15 posts - 14,221 through 14,235 (of 59,097 total)