Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,501 through 10,515 (of 59,095 total)

RE: Are the posted questions getting worse?

Lynn Pettis - Monday, November 26, 2018 2:36 PM
Well, I have grand kids between 6 and 3 years old, so 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)

November 27, 2018 at 10:22 pm

#2014746
RE: Small negative numbers

Heh... I also find it interesting that most people didn't bark out an "It Depends". Right-sizing is certainly important but so are other considerations such as implicit casts during joins,...
--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)

November 27, 2018 at 10:13 pm

#2014744
RE: Building Better Training Opportunities

Heh... there's nothing more challenging than real life. If you want some problems to work on for training, look at the code you have. Develop a "Continuous Improvement Project" where...
--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)

November 27, 2018 at 10:10 pm

#2014743
RE: What can be the benefits of copy_only backup

I think the biggest benefit is that you can move a "copy only" file anywhere you want it, lose it, or delete it, and it won't affect the possible restores...
--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)

November 27, 2018 at 9:36 pm

#2014741
RE: Converting Binary Numbers To Hex

Steve Jones - SSC Editor - Tuesday, November 27, 2018 9:35 AM
Jeff Moden - Tuesday, November 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)

November 27, 2018 at 9:31 pm

#2014740
RE: Converting Binary Numbers To Hex

I'm curious, Steve. With the understanding that the largest positive value you can calculate for BIGINT only occupies 63 bits (and you are only taking positive values into consideration in...
--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)

November 27, 2018 at 9:23 am

#2014677
RE: Converting Binary Numbers To Hex

Phil Factor - Tuesday, November 27, 2018 5:45 AM
Yes, it is an interesting topic with some useful applications
I did a bit on...
--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)

November 27, 2018 at 8:45 am

#2014669
RE: Inserting a new row into a table using a cursor

jcelko212 32090 - Monday, November 26, 2018 12:02 PM
josetur12 - Saturday, November 24, 2018 11: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)

November 26, 2018 at 3:04 pm

#2014585
RE: OPENROWSET

Budd - Monday, November 26, 2018 9:28 AM
WHT DOES THIS--
select top 1 a.* into #t
from openrowset('SQLNCLI', 'Server=localhost;Trusted_Connection=yes;','SET NOCOUNT ON;SET FMTONLY OFF;...
--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)

November 26, 2018 at 2:35 pm

#2014582
RE: OPENROWSET

Phil Parkin - Monday, November 26, 2018 9:39 AM
Why are you using OPENROWSET to do this and not issuing the commands directly?
Heh......
--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)

November 26, 2018 at 2:34 pm

#2014581
RE: parse string and check for valid date

Bruin - Monday, November 26, 2018 9:45 AM
How could that be accomplished(example) if no header available.
Thanks.
Read the first row anyway just 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)

November 26, 2018 at 2:32 pm

#2014577
RE: Are the posted questions getting worse?

Lynn Pettis - Monday, November 26, 2018 2:25 PM
Anyone else just hear the adult noises from a Charlie Brown movie when Mr....
--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)

November 26, 2018 at 2:31 pm

#2014576
RE: High memory utilization on SQL Server

Sreekanth B - Monday, November 26, 2018 10:36 AM
Jeff Moden - Monday, November 26, 2018 9: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)

November 26, 2018 at 1:04 pm

#2014567
RE: Reindexing and Log files

scarr030 - Monday, November 26, 2018 10:42 AM
Maybe I'm misunderstanding your post, but the reindexing job wasn't running, yet the logs...
--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)

November 26, 2018 at 1:01 pm

#2014566
RE: Reindexing and Log files

scarr030 - Monday, November 26, 2018 8:58 AM
Okay, well the reindexing job was not causing the issue. The job only runs once...
--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)

November 26, 2018 at 10:02 am

#2014544

Viewing 15 posts - 10,501 through 10,515 (of 59,095 total)