Jeff Moden

Forum Replies Created

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

RE: how to find the lowest usage of a database

WhiteLotus - Tuesday, November 13, 2018 2:42 AM
Hi Guys
How do we find the lowest usage of a database ?
I need ...
--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 13, 2018 at 7:40 am

#2013321
RE: Replacing string in text file with another string

VoldemarG - Monday, November 12, 2018 2:59 PM
I finally got it working THIS WAY:
   public void Main()
        {
    string fileText;
    try
    {
      fileText = System.IO.File.ReadAllText(Dts.Variables["FullFilePath"].Value.ToString());
      fileText =...
--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 13, 2018 at 7:37 am

#2013320
RE: Are the posted questions getting worse?

Lynn Pettis - Monday, November 12, 2018 10:01 PM
Yes, that would be nice but the darling that did this in 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 13, 2018 at 6:39 am

#2013310
RE: Column names on INNER JOINS

jcelko212 32090 - Monday, November 12, 2018 5:04 PM
The legacy Sybase functions reflect a COBOL mentality, and not an SQL or RDBMS...
--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 13, 2018 at 6:34 am

#2013309
RE: Converting between binary hex and GUID (uniqueidentifier)

jay-h - Monday, November 12, 2018 12:31 PM
Ah the '1' argument is what I was missing.
CONVERT(VARBINARY(16),@BINSTR,1) OK_BIN
Thanks everyone
Except ou know it's always...
--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:52 pm

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

Jonathan AC Roberts - Monday, November 12, 2018 12:54 PM
Jeff Moden - Monday, November 12, 2018 12:11...
--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 1:52 pm

#2013268
RE: Are the posted questions getting worse?

jasona.work - Monday, November 12, 2018 11:31 AM
I think the only way you could move a datacenter in 3 hours without...
--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:17 pm

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

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