Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,411 through 13,425 (of 59,095 total)

RE: UPDATE with JOINS and WHERE clause

JJR333 - Thursday, December 14, 2017 4:06 AM
drew.allen - Wednesday, December 13, 2017 3:21 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)

December 14, 2017 at 8:33 am

#1972154
RE: Is Rolling Back The Same as Failing?

mjh 45389 - Thursday, December 14, 2017 2:08 AM
New to this topic. Rollback is not failing. If there was no rollback option...
--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 14, 2017 at 8:23 am

#1972151
RE: SQL Server instance slowness

Having gone through it and the crushing affects that we eventually ran into on our production boxes, my first step is now to check if the connection strings are MARS...
--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 14, 2017 at 8:14 am

#1972148
RE: How to Automate the closing of a window?

Now... about those deadlocks you don't want to hear about... 😉
--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 13, 2017 at 7:45 pm

#1972060
RE: How to Automate the closing of a window?

sqlnoob2015 - Tuesday, December 12, 2017 4:17 PM
I'm pulling in sales numbers from a database that is updated every 15 minutes 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 13, 2017 at 7:42 pm

#1972059
RE: Trouble with script that dynamically imports flat file. cmdshell

Jeffery Williams - Wednesday, December 13, 2017 12:48 PM
bmg002 - Wednesday, December 13, 2017 12:42 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)

December 13, 2017 at 7:23 pm

#1972058
RE: Replacement for rowmodctr in sys.sysindexes?

Heh... although RowModCtr is deprecated, it's still what is used by Microsoft in the sp_updatestats sproc even in SQL Server 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)

December 13, 2017 at 7:17 pm

#1972057
RE: PRIME NUMBERS

Jason A. Long - Wednesday, December 13, 2017 2:18 PM
Jeff Moden - Wednesday, December 13, 2017 5:27...
--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 13, 2017 at 3:18 pm

#1972049
RE: Checksum_AGG, BINARY_CHECKSUM

susmitha117 - Wednesday, December 13, 2017 10:31 AM
Hi,
I am not getting the checksum_agg and binary_checksum. I understood that it is used 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)

December 13, 2017 at 11:49 am

#1972003
RE: Looking for an optimal solution

flownominal16 - Tuesday, December 12, 2017 1:12 PM
Preface:
I've been working on a particular problem past the threshold of time before I should...
--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 13, 2017 at 11:12 am

#1971999
RE: SQL Restore takes long time - how do I clear committed transactions from log ?

Gamleur84 - Thursday, December 7, 2017 11:50 AM
I am not concerned about the 500GB empty file.
You should be. Even with a log...
--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 13, 2017 at 11:04 am

#1971998
RE: Missing index question

Grant Fritchey - Wednesday, December 13, 2017 2:24 AM
A GIANT pinch of salt. The missing index DMVs do not relate the suggested...
--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 13, 2017 at 6:47 am

#1971943
RE: Reorganise indexes

Kris-155042 - Tuesday, December 12, 2017 9:57 PM
HI,
I got this from the ola.hallengren web site and when I run it, it doesn't appear...
--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 13, 2017 at 6:41 am

#1971941
RE: PRIME NUMBERS

Thank you both for the feedback.
--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 13, 2017 at 6:08 am

#1971935
RE: Advice for Newcomers

xsevensinzx - Wednesday, December 13, 2017 5:45 AM
Be a team player. Many will tell you to surround yourself with smart people; toss...
--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 13, 2017 at 6:05 am

#1971934

Viewing 15 posts - 13,411 through 13,425 (of 59,095 total)