Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,621 through 10,635 (of 59,095 total)

RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

VoldemarG - Monday, November 12, 2018 8:20 AM
Jonathan AC Roberts - Sunday, November 11, 2018 5:17 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)

November 12, 2018 at 12:11 pm

#2013255
RE: sql display milliseconds to date format

ferdie - Sunday, November 11, 2018 11:40 PM
Hi,
Anyone can help on sql how to display milliseconds to a date format?
DateCreated
-----------------
1539453603609
1539453605407
1540436130996
1542004320409
...
...
I need an...
--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 12, 2018 at 8:36 am

#2013223
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

Did that do what you needed it to do?
--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 12, 2018 at 8:10 am

#2013219
RE: Are the posted questions getting worse?

patrickmcginnis59 10839 - Monday, November 12, 2018 6:35 AM
I've got a few databases at work with the database name created 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 12, 2018 at 7:20 am

#2013215
RE: sql display milliseconds to date format

Eirikur Eiriksson - Monday, November 12, 2018 7:07 AM
Jeff Moden - Monday, November 12, 2018 5:43 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 12, 2018 at 7:16 am

#2013214
RE: Are the posted questions getting worse?

ThomasRushton - Monday, November 12, 2018 5:34 AM
As I've just found a database whose filenames (logical & physical) begin with a...
--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 12, 2018 at 6:26 am

#2013205
RE: Composite indexes; performance

Grant Fritchey - Monday, November 12, 2018 5:52 AM
Jeff Moden - Thursday, November 8, 2018 10:43 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 12, 2018 at 6:23 am

#2013204
RE: sql display milliseconds to date format

george_at_sql - Monday, November 12, 2018 4:00 AM
ferdie - Monday, November 12, 2018 12:24 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 12, 2018 at 5:43 am

#2013198
RE: Are the posted questions getting worse?

Lynn Pettis - Sunday, November 11, 2018 5:16 PM
I started putting brackets out of self defense, especially in my dynamic SQL...
--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 12, 2018 at 5:24 am

#2013194
RE: Placing data file , log file and temp file in 1 drive or separate drive ?

For the sake of "management purposes", people will have the SAN guy set up different "drive letters" so they can more easily keep track of their data files, log files,...
--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 11, 2018 at 6:59 pm

#2013176
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

p.s. SSIS, SSRS, SSAS, SSSB.... those are all "four letter words" to me. 😀
--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 11, 2018 at 6:50 pm

#2013175
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

VoldemarG - Sunday, November 11, 2018 6:16 PM
its only because this way it ieasier to output all text fields to text file...
--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 11, 2018 at 6:47 pm

#2013173
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

pietlinden - Sunday, November 11, 2018 3:25 PM
Why are you VARCHAR columns and then storing numbers in them? Why is a...
--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 11, 2018 at 5:32 pm

#2013164
RE: Placing data file , log file and temp file in 1 drive or separate drive ?

Everyone says that they're supposed to be on "separate drives". If these things are on a SAN, you'll have a bunch of "logical drives" and there's absolutely no guarantee that...
--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 11, 2018 at 5:21 pm

#2013161
RE: SELECT TOP 1 on Primary Key?

AdrianLParker+sqlservercentral.com - Sunday, November 11, 2018 3:15 PM
Jeff Moden - Sunday, November 11, 2018 1:43 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)

November 11, 2018 at 3:46 pm

#2013154

Viewing 15 posts - 10,621 through 10,635 (of 59,095 total)