Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,531 through 10,545 (of 59,095 total)

RE: SUM Function Group by Status and User displayed on columns

octavioromano - Thursday, November 22, 2018 1:29 PM
Beautiful, works like a charm.
Thanks a lot for your help.
Kind regards,
Octavio
The question now is, if...
--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 22, 2018 at 2:08 pm

#2014356
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

bdkdavid - Wednesday, November 21, 2018 5:37 PM
Hi Jeff and Sue,
Yes the 13 TB file is the mdf file. I just started...
--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 22, 2018 at 1:56 pm

#2014355
RE: Inner joins

drew.allen - Wednesday, November 21, 2018 11:33 AM
Jeff Moden - Wednesday, November 21, 2018 9:06 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 22, 2018 at 1:48 pm

#2014354
RE: parse string and check for valid date

Bruin - Wednesday, November 21, 2018 7:00 AM
Need an example of how to wrap the if statement checking if date exists 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)

November 22, 2018 at 1:41 pm

#2014353
RE: Natural Sort Order

Jason A. Long - Tuesday, November 20, 2018 10:50 PM
Of course, the mere fact that I can't think of a legitimate...
--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 22, 2018 at 1:38 pm

#2014352
RE: Break Problems Down

Frank W Fulton Jr - Tuesday, November 20, 2018 7:24 PM
Back in the Day when we used Punch Cards, Terminals and Teletypes,...
--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 22, 2018 at 1:30 pm

#2014350
RE: Exif data into a database.

ben.brugman - Thursday, November 22, 2018 3:07 AM
Ricky Lively - Wednesday, November 21, 2018 6: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)

November 22, 2018 at 1:04 pm

#2014346
RE: Obfuscating character columns

Hmmm... if an individual AgentName appears in all 200 databases in multiple tables and multiple times in those tables, wouldn't you want the obfuscation to be exactly the same for...
--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 21, 2018 at 5:13 pm

#2014305
RE: Database upgrade and migration to 2016 SQL Server

EMtwo - Wednesday, November 21, 2018 12:42 PM
Michael L John - Wednesday, November 21, 2018 8:56 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 21, 2018 at 3:48 pm

#2014298
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

bdkdavid - Wednesday, November 21, 2018 3:04 PM
Thank You, Sue and Ryan
The database is 13 TB in size already. They do alot...
--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 21, 2018 at 3:44 pm

#2014297
RE: How to study the layout of a database?

patrickmcginnis59 10839 - Wednesday, November 21, 2018 11:35 AM
Jeff Moden - Wednesday, November 21, 2018 8:35 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 21, 2018 at 1:22 pm

#2014286
RE: Inner joins

drew.allen - Wednesday, November 21, 2018 11:33 AM
Jeff Moden - Wednesday, November 21, 2018 9:06 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 21, 2018 at 1:03 pm

#2014285
RE: Getting the main course right

Heh... STUFFing on steroids!
For those in the U.S.A, have a great Thanks Giving! Everyone else... have a great weekend when it starts.
And, Steve, thanks for...
--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 21, 2018 at 10:47 am

#2014270
RE: Cursors are not supported on a table which has a clustered columnstore index

Michael L John - Wednesday, November 21, 2018 9:01 AM
irehman - Wednesday, November 21, 2018 8:57 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 21, 2018 at 10:41 am

#2014269
RE: Index and Search help

ScottPletcher - Wednesday, November 21, 2018 10:05 AM
Jonathan AC Roberts - Wednesday, November 21, 2018 8:32 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 21, 2018 at 10:31 am

#2014268

Viewing 15 posts - 10,531 through 10,545 (of 59,095 total)