Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,206 through 14,220 (of 59,097 total)

RE: sa password fault - Possibly OK after restart

as1981 - Monday, October 2, 2017 2:33 PM
Hello,
Sorry, that wasn't intentional. I hadn't seen previous advice to disable SA so hadn't done...
--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 2, 2017 at 4:38 pm

#1961970
RE: Are the posted questions getting worse?

jasona.work - Monday, October 2, 2017 1:22 PM
jonathan.crawford - Monday, October 2, 2017 12:58 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)

October 2, 2017 at 2:27 pm

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

as1981 - Monday, October 2, 2017 2:15 PM
Jeff: Thanks.
Chris: Sorry I didn't see the notification for your post. Thanks, that's the account...
--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 2, 2017 at 2:25 pm

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

bmg002 - Monday, October 2, 2017 11:40 AM
Jeff Moden - Sunday, October 1, 2017 4:22 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)

October 2, 2017 at 2:19 pm

#1961953
RE: The Worms-eye View

David.Poole - Monday, October 2, 2017 8:33 AM
I think siloed thinking rather than over-specialization is the biggest threat.
+1000 to that. You've...
--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 2, 2017 at 10:06 am

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

rmcfaden - Sunday, October 1, 2017 11:26 PM
Jeff,
First let me say thank you for taking the time to reply to my 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 2, 2017 at 8:13 am

#1961873
RE: select from flat file

MinhL7 - Sunday, October 1, 2017 8:32 PM
It's not a good file and I need to filter the insert. Can you select...
--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 2, 2017 at 7:56 am

#1961866
RE: select from flat file

If your file is in good shape, then the following will work...
Create a staging table like this...

CREATE TABLE dbo.Test
(
Field1...
--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 7:43 pm

#1961815
RE: Insert fails when trying to create a table.

newdba2017 - Wednesday, September 27, 2017 1:03 PM
Phil Parkin - Wednesday, September 27, 2017 12:27 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)

October 1, 2017 at 7:23 pm

#1961814
RE: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

Jack 49290 - Thursday, March 30, 2017 3:45 PM
Can you please elaborate onQ1? Based on the chart at 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)

October 1, 2017 at 7:21 pm

#1961813
RE: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

billh-508166 - Wednesday, September 27, 2017 1:04 PM
A CLR is a better solution when date validation is required.
Why would you think...
--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:54 pm

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

Viewing 15 posts - 14,206 through 14,220 (of 59,097 total)