Jeff Moden

Forum Replies Created

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

RE: Start of month last year

craig.jenkins - Thursday, September 28, 2017 12:57 AM
Thank you all for the support all sorted. Appreciate it
Two way street here... please post...
--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:46 pm

#1961811
RE: Database get faster after restart sql service

Stop rebuilding/reorganizing indexes. It's a waste of time, clock cycles, and disk space.
--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:33 pm

#1961810
RE: What else can take up space in a database besides tables

Steve-443559 - Friday, September 29, 2017 7:02 AM
ok, i found something about text fields. that is likely it.
Two way street here... tell...
--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:29 pm

#1961809
RE: sa password fault - Possibly OK after restart

Of bigger concern... why do you have the SA login enabled? The general recommendation is to always disable the SA login to help prevent getting hacked.
--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:15 pm

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

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