Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,691 through 15,705 (of 59,063 total)

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
RE: Obfuscating/masking data at column level

To the best of my knowledge, there is no way to do this in 2012 and certainly no way to do any kind of obfuscation that someone with the right...
--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:22 pm

#1926741
RE: Copy and rename a file using stored procedure in SQL server 2005

Ed Wagner - Saturday, February 4, 2017 2:03 PM
Jeff Moden - Saturday, February 4, 2017 11:47 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 4, 2017 at 3:41 pm

#1926740
RE: Close Encounters of the CEIP Kind

Thanks for the very timely article, Rodney. I agree that my right index finger will feel a great loss and not being able to turn it all off during installation.
--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 3:35 pm

#1926739
RE: Copy and rename a file using stored procedure in SQL server 2005

anilkumarg 33214 - Friday, February 3, 2017 4:03 PM
Jeff Moden - Saturday, August 16, 2008 7:57 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)

February 4, 2017 at 11:47 am

#1926733

Viewing 15 posts - 15,691 through 15,705 (of 59,063 total)