Jeff Moden

Forum Replies Created

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

RE: 70-473 Anyone studying for this, or passed it?

Jeff Moden - Sunday, August 20, 2017 9:39 PM
Duran - Friday, August 4, 2017 9:12 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 4, 2017 at 2:52 pm

#1970622
RE: Mathematics/Algorithms in SQL

HappyGeek - Monday, December 4, 2017 11:19 AM
Jeff Moden - Monday, December 4, 2017 10:03 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 4, 2017 at 2:49 pm

#1970620
RE: Bending strings

Jeff Moden - Sunday, February 14, 2016 2:23 PM
Jeff Moden (1/22/2015)
Steve Jones - SSC Editor (1/22/2015)
bump
<HeadDesk> My apologies. Major side...
--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 4, 2017 at 10:19 am

#1970566
RE: Bad Scalar Functions (or other UDF)

Steve Jones - SSC Editor - Friday, May 20, 2016 10:18 AM
Thanks, Jeff. Hoping for a few pieces. We...
--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 4, 2017 at 10:15 am

#1970563
RE: Mathematics/Algorithms in SQL

karthik M - Tuesday, November 29, 2016 3:36 AM
All,I am looking for some article which explain what are all the mathematics concepts...
--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 4, 2017 at 10:03 am

#1970561
RE: Need vertical table as horizontal table in SQL

kbhanu15 - Monday, December 4, 2017 5:20 AM
Hi Team,
can you please help me to get
create table company
(
name varchar(100)
)
insert into company
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 4, 2017 at 8:29 am

#1970541
RE: Bulk insert into table from csv

jaryszek - Monday, December 4, 2017 7:32 AM
Hi Guys,
thank you for helping me,
my code is:
USE QlikView
GO
CREATE TABLE tbl_Slownik
(
ID INT IDENTITY(1,1),
UniqueID...
--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 4, 2017 at 8:22 am

#1970540
RE: Is This Database Being Used?

Yuri Padorin - Monday, December 4, 2017 7:32 AM
Surprised you didn't mention it, but I use an extended events session that 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)

December 4, 2017 at 8:19 am

#1970539
RE: Need vertical table as horizontal table in SQL

aaron.reese - Monday, December 4, 2017 7:32 AM
pedant 🙂
😀
--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 4, 2017 at 7:45 am

#1970531
RE: Bulk insert into table from csv

@jaryszek ,
You need to generate and post the full CREATE TABLE statement for your target table for us to help further. ...
--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 4, 2017 at 7:06 am

#1970516
RE: Need vertical table as horizontal table in SQL

aaron.reese - Monday, December 4, 2017 5:24 AM
SQL does not give you tables, it gives you data sets
Not sure I agree with...
--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 4, 2017 at 6:08 am

#1970490
RE: Shrinking Transaction Log Files

Lj Burrows - Monday, December 4, 2017 2:54 AM
I would also want to add that clearing the log is done by backing...
--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 4, 2017 at 5:51 am

#1970486
RE: Using CSS to control formatting in dbmail

aaron.reese - Monday, December 4, 2017 5:29 AM
Kudos for getting it to work but I can't help feeling that you are building...
--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 4, 2017 at 5:43 am

#1970483
RE: Is This Database Being Used?

No matter which method you use to determine if a database is being used, it's not a good idea to immediately kill the database. To Dave's point, I'll typically take 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)

December 4, 2017 at 5:37 am

#1970479
RE: Not Useless Features

Steve Jones - SSC Editor - Friday, December 1, 2017 11:34 AM
MattF - Friday, December 1, 2017...
--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 2, 2017 at 9:21 am

#1970411

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