Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,441 through 13,455 (of 59,101 total)

RE: Advice for Newcomers

1. Learn enough about the problem you're trying to solve to actually be able to ask a question about it.
2.. You're not "entitled". Eventually, you have to learn 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)

December 12, 2017 at 12:41 pm

#1971824
RE: Bulk insert into table from csv

jaryszek - Tuesday, December 12, 2017 8:23 AM
Columns in CSV were in different order then columns in my SQL tables...
Jacek
I've had 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)

December 12, 2017 at 12:39 pm

#1971822
RE: Tempdb

giri10488 - Tuesday, December 12, 2017 12:00 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 12, 2017 at 7:54 am

#1971744
RE: Bulk insert into table from csv

jaryszek - Tuesday, December 12, 2017 12:05 AM
hi Guys,
thank you for helping me!
Problem was very simple! From QlikView imported data was 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)

December 12, 2017 at 7:46 am

#1971741
RE: Find and count Incomplete records in a table

Steve Jones - SSC Editor - Tuesday, December 12, 2017 2:09 AM
Nice enhancement, Jeff. I knew someone might come up 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)

December 12, 2017 at 7:43 am

#1971739
RE: Please help with xp_cmdshell

ZZartin - Monday, December 11, 2017 9:09 AM
Jeff Moden - Monday, December 11, 2017 9:07 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 11, 2017 at 8:33 pm

#1971693
RE: Calculating varying process capacity

drew.allen - Monday, December 11, 2017 8:45 AM
Jeff Moden - Sunday, December 10, 2017 10:10 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 11, 2017 at 3:56 pm

#1971678
RE: Intellisense broken?

Heh... you titled this post "Intellisense broken?"
My answer is "Yes... just like 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)

December 11, 2017 at 2:14 pm

#1971666
RE: STRING_SPLIT with no delimiter

J Livingston SQL - Monday, December 11, 2017 1:02 PM
Jeff Moden - Monday, December 11, 2017 10:29...
--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 11, 2017 at 1:33 pm

#1971661
RE: Are the posted questions getting worse?

Phil Parkin - Monday, December 11, 2017 9:03 AM
Jeff Moden - Monday, December 11, 2017 8:54 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 11, 2017 at 10:34 am

#1971609
RE: STRING_SPLIT with no delimiter

werner.grimmer - Monday, December 11, 2017 10:25 AM
I tried the answer on SQL Server 2016, the result is only one A?
THX
There's something...
--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 11, 2017 at 10:29 am

#1971606
RE: cost threshold for parallelism setting

vsamantha35 - Sunday, December 10, 2017 9:40 PM
Hi All,
I want to change "cost threshold for parallelism" from 5 to 25 as 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 11, 2017 at 9:17 am

#1971588
RE: "Tag" highest value in the month

saravanatn - Monday, December 11, 2017 7:42 AM
Hi,
You are right. I made a small mistake.Below query gives accurate results. But you...
--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 11, 2017 at 9:13 am

#1971587
RE: "Tag" highest value in the month

Simple SQL Tips - Monday, December 11, 2017 7:27 AM
Jeff, After reading up on CTE and understanding what you provided, that's exactly...
--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 11, 2017 at 9:11 am

#1971586

Viewing 15 posts - 13,441 through 13,455 (of 59,101 total)