Jeff Moden

Forum Replies Created

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

RE: General question on tuning

sqlgrease - Friday, December 15, 2017 9:59 AM
I tune for response time first and resource usage second for on premise.
Although 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)

December 15, 2017 at 10:03 am

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

sqlnoob2015 - Thursday, December 14, 2017 3:20 PM
Jeff Moden - Wednesday, December 13, 2017 7: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 14, 2017 at 9:11 pm

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

Frank W Fulton Jr - Thursday, December 14, 2017 3:49 PM
Anyone who says he/she has never had a failure is not being...
--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 9:06 pm

#1972235
RE: SQL Server instance slowness

Jeffery Williams - Thursday, December 14, 2017 8:24 AM
Jeff Moden - Thursday, December 14, 2017 8:14 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)

December 14, 2017 at 11:06 am

#1972181
RE: Are the posted questions getting worse?

ZZartin - Thursday, December 14, 2017 9:17 AM
Brandie Tarvin - Thursday, December 14, 2017 5:48 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)

December 14, 2017 at 10:43 am

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

SQL Guy 1 - Thursday, December 14, 2017 7:57 AM
Thanks all for valuable replies. I modified the query in this way:
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)

December 14, 2017 at 10:36 am

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

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