Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,721 through 15,735 (of 59,097 total)

RE: HOW TO RUN THE SAME SCRIPT TO RETRIEVE DATA FROM MULTIPLE DATABASES

JALLY - Monday, February 6, 2017 3:16 PM
Greetings,
i have a challenge, who can point me or show me the simplest how 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)

February 6, 2017 at 3:42 pm

#1926989
RE: Deleting a row(s)

Now that you've got a couple of answers, I have to ask... who is fixing the original code that caused this problem to begin 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)

February 6, 2017 at 7:44 am

#1926864
RE: Importing data from Excel using ForEach Loop

delaine.gocke - Friday, August 29, 2008 7:38 AM
Any suggestions?
BAAA-HAAA!!! Yeah... Do it in T-SQL instead. 😉
--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)

February 6, 2017 at 7:41 am

#1926863
RE: Your Favorite Feature that Needs Work

roger.plowman - Monday, February 6, 2017 7:02 AM
I wouldn't mind a better syntax for upsert. I mean, the current one is just...
--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)

February 6, 2017 at 7:38 am

#1926862
RE: Today's Random Word!

Manic Star - Monday, February 6, 2017 6:56 AM
Kaye Cahs - Monday, February 6, 2017 6:53 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)

February 6, 2017 at 7:35 am

#1926860
RE: Truncating transaction logs

Tatay_2016 - Saturday, February 4, 2017 5:25 PM
I have a MS SQL 2008 database, remote hosted. Recently the host upgraded the...
--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)

February 6, 2017 at 7:31 am

#1926857
RE: Close Encounters of the CEIP Kind

Gary Varga - Monday, February 6, 2017 4:42 AM
I am a little concerned that this is hidden. I can even understand this...
--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)

February 6, 2017 at 7:22 am

#1926855
RE: Best way to determine to Clustered index keys

goher2000 - Sunday, February 5, 2017 11:50 PM
I would (assuming one node can handle the workload cuz in my environment it does...
--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)

February 6, 2017 at 6:49 am

#1926845
RE: How does SSMS knows about the scalar functions ?

karenworld - Sunday, February 5, 2017 11:44 PM
Hi expert,
I have this reference code which make use of Scalar functions and stored procedure.
The...
--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)

February 6, 2017 at 6:43 am

#1926844
RE: Query to take the backup

ramyours2003 - Thursday, February 2, 2017 7:50 AM
I need a query to take the differential backup of all the databases in 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)

February 5, 2017 at 11:16 pm

#1926784
RE: same query, different behavior on different networks

Have you verified that the table in both "networks" has the same number of rows and have the exact same rows? I know you say you use the same copy...
--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)

February 5, 2017 at 11:08 pm

#1926783
RE: Newbie Help - SQL Query

dump 10119 - Sunday, February 5, 2017 1:40 AM
Can somebody point me in the right direction please ?
NTILE is what you're looking...
--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)

February 5, 2017 at 11:05 pm

#1926782
RE: Defferance Count days within one year

ALDHEEB - Sunday, February 5, 2017 8:24 AM
Thanks a lot Mr Eirikur EirikssonThe table and columns oready i haveNo need creat...
--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)

February 5, 2017 at 12:08 pm

#1926768
RE: Importing data using bcp

smatu - Saturday, February 4, 2017 2:04 PM
HI all:
Thanks so much for all of your help;
Problem

The issue I had with extracting my...
--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)

February 4, 2017 at 6:24 pm

#1926743
RE: Stored Proc not Working after migration - CONTAINSTABLE

IIRC, you'll need to rebuld the full text indexes in their entirety.
EDIT... Crud... didn't see Lowell's post, which says the same thing.
--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)

February 4, 2017 at 4:24 pm

#1926742

Viewing 15 posts - 15,721 through 15,735 (of 59,097 total)