Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,736 through 15,750 (of 59,098 total)

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
RE: Best way to determine to Clustered index keys

Robin35 - Friday, February 3, 2017 5:11 PM
Jeff Moden - Friday, February 3, 2017 4:15 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:43 am

#1926732
RE: Importing data using bcp

phil.doensen - Friday, February 3, 2017 9:30 PM
Jeff Moden - Friday, February 3, 2017 3:56 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:38 am

#1926731
RE: 1 Tb is How many rows in a databse

susmitha117 - Friday, February 3, 2017 7:35 AM
How many rows does a database contain in 1TeraByte?
Heh.... "42".
--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 3, 2017 at 4:18 pm

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

Robin35 - Friday, February 3, 2017 11:04 AM
GilaMonster - Friday, February 3, 2017 8: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)

February 3, 2017 at 4:15 pm

#1926718
RE: Importing data using bcp

We've been guessing long enough. Please post your unadulterated BCP command with the obvious exception of obfuscating ServerName, Login, and Password. Also, for imports, BCP may be the wrong tool. ...
--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 3, 2017 at 3:56 pm

#1926716
RE: All indexes in one small table are taking too long to rebuild

Heh... stop rebuilding indexes. It's not worth it and only causes blocking the next day. I haven't rebuilt indexes on my production box for over a year (last date was...
--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 3, 2017 at 3:49 pm

#1926714
RE: Are the posted questions getting worse?

Luis Cazares - Friday, February 3, 2017 7:37 AM
Jeff Moden - Friday, February 3, 2017 7:21 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 3, 2017 at 8:36 am

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

One of the most informative videos I've ever seen on the subject is by Kimberly Tripp and can be found at the following URL...
https://www.youtube.com/watch?v=QjCEkI8Qm5c
It should...
--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 3, 2017 at 8:31 am

#1926626
RE: Interview Question

susmitha117 - Friday, February 3, 2017 7:48 AM
Hi. Recently I have attended a couple of interviews. I have faced a similar question...
--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 3, 2017 at 8:27 am

#1926621
RE: Are the posted questions getting worse?

djj - Friday, February 3, 2017 6:14 AM
Thank you, everyone.
Not a lot of postings with my skill level as I have...
--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 3, 2017 at 7:21 am

#1926587

Viewing 15 posts - 15,736 through 15,750 (of 59,098 total)