Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,761 through 14,775 (of 59,097 total)

RE: Deadlock on TempTable in SP

jayoub - Friday, July 14, 2017 10:39 AM
I spoke to the developer and he want to deal with by adding the WITH...
--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)

July 14, 2017 at 12:47 pm

#1950997
RE: Flat File with out headers

darsha.shashank - Friday, July 14, 2017 9:41 AM
Hello,
I have flat file of 45GB which is been split into 173 files(each as 255mb...
--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)

July 14, 2017 at 11:43 am

#1950988
RE: primary key with null

I'm thinking that this is actually a pretty easy problem to solve. The use of a PK constraint says that you cannot include NULLable columns. So..... use an AK (alternate...
--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)

July 14, 2017 at 6:57 am

#1950922
RE: Delete query taking too long

savibp3 - Friday, July 14, 2017 5:42 AM
I have a history table which takes 15 mins to complete.
Delete from table_name where dt_bus...
--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)

July 14, 2017 at 6:51 am

#1950917
RE: Cool Projects

Aaron N. Cutshall - Friday, July 14, 2017 5:39 AM
Jeff Moden - Saturday, August 24, 2013 4:08...
--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)

July 14, 2017 at 6:40 am

#1950915
RE: The Panjandrum Conundrum

Phil Factor - Thursday, July 13, 2017 9:30 AM
OK. I should have said 'everyone except perhaps Jeff.'
Heh... CORRECT! 😉
...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)

July 13, 2017 at 12:39 pm

#1950822
RE: Collapsing Hierarchy of messages into single row

Michael Esposito - Wednesday, July 5, 2017 11:52 AM
I added it to my original post. Thanks for the tip!!
Here's another tip. Test...
--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)

July 13, 2017 at 12:07 pm

#1950810
RE: What do you do when you make a mistake?

Julie Breutzmann - Thursday, July 13, 2017 10:32 AM
hakim.ali - Thursday, July 13, 2017 9:36 AM
--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)

July 13, 2017 at 11:44 am

#1950803
RE: The Panjandrum Conundrum

and everyone loves the String_Split() function in SQL Server 2016
Maybe others do but I don't. Don't get me wrong... I very much appreciate it's...
--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)

July 13, 2017 at 8:38 am

#1950756
RE: Index-Filegroup (how many Files)

Perry Whittle - Tuesday, July 11, 2017 5:18 AM
Jeff Moden - Friday, July 7, 2017 9:26 AM
--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)

July 13, 2017 at 1:27 am

#1950681
RE: SQL 2016 SP1 CU2 - sudden and unexplained shutdowns

Bleeping DBA - Wednesday, July 5, 2017 4:49 PM
GilaMonster - Wednesday, July 5, 2017 1:40 AM
--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)

July 13, 2017 at 12:11 am

#1950676
RE: What do you do when you make a mistake?

What do I do when I make a mistake? Own it. I first let the right people know that a mistake was made and what it affected. I also let...
--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)

July 12, 2017 at 11:53 pm

#1950674
RE: task => generate script with tool sqlCmd

Grant Fritchey - Wednesday, July 12, 2017 9:57 AM
Jeff Moden - Wednesday, July 12, 2017 9:05 AM
--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)

July 12, 2017 at 11:05 pm

#1950673
RE: task => generate script with tool sqlCmd

Grant Fritchey - Wednesday, July 12, 2017 8:52 AM
Jeff Moden - Wednesday, July 12, 2017 8:10 AM
--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)

July 12, 2017 at 9:05 am

#1950569
RE: Trigger for Auditing

TheSQLGuru - Monday, July 10, 2017 1:28 PM
I don't like the unnecessary TOP 1 1 you have in your code, although fortunately...
--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)

July 12, 2017 at 8:57 am

#1950564

Viewing 15 posts - 14,761 through 14,775 (of 59,097 total)