Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,106 through 21,120 (of 59,098 total)

RE: Slow down a transaction

If all of that is true, then just configure the key for the table to ignore dupes. Of course, that also depends on the hash algorithm that you're using....
--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)

April 7, 2015 at 6:01 pm

#1789382
RE: Are the posted questions getting worse?

Luis Cazares (4/7/2015)
Alan.B (4/7/2015)
Brandie Tarvin (4/3/2015)
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
No, it was never rescinded after Vatican II, almost everyone thinks it was though. Even my mother didn't believe me when 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)

April 7, 2015 at 5:43 pm

#1789375
RE: Are the posted questions getting worse?

Eirikur Eiriksson (4/7/2015)
Jeff Moden (4/7/2015)
I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades now and really beginning to work...
--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)

April 7, 2015 at 5:42 pm

#1789373
RE: How to eliminate OR condition

koti.raavi (4/7/2015)
First Apologies for delay in response:
Firstly Thanks to
GilaMonster,Jeff Moden,Eirikur Eiriksson,CELKO,Ed Wagner,MMartin1,MadAdmin for your valuable time
--Jeff I'm here 🙂
Yes, if we use 2 unions it will scan 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)

April 7, 2015 at 5:38 pm

#1789370
RE: Are the posted questions getting worse?

I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades now and really beginning to work with the system especially...
--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)

April 7, 2015 at 3:21 pm

#1789349
RE: How to eliminate OR condition

And now for the biggest question of them all...
Where the hell did the OP disappear to? :crazy:
--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)

April 7, 2015 at 8:03 am

#1789196
RE: Running Ola script and getting error

qur7 (4/6/2015)
Hi Jeff,
Thanks for the reply. so will this be correct version.
EXECUTE dbo.IndexOptimize
@Databases = USER_DATABASES, -databasename,
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@SortinTempdb = 'Y'
Regards,
I believe 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)

April 6, 2015 at 6:51 am

#1788895
RE: A Hazard of Using the SQL Update Statement

cbowman (4/6/2015)
Could this article be renamed to 'One of the Millions of Problems of NOT Knowing Your Data?'
Exactly. 🙂 +1000
--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)

April 6, 2015 at 6:48 am

#1788893
RE: How to eliminate OR condition

koti.raavi (4/5/2015)
Hi Everyone,
Please see below query
Select ID, ID1,Name, Cname from Customer where ID =(@IDSearch) or ID1 =(@Idsearch)
When i run above query took around 3 mins, 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)

April 5, 2015 at 7:20 pm

#1788828
RE: Running Ola script and getting error

qur7 (4/4/2015)
Hi All,
I am running Ola maintenance script with the following parameters which runs fine.
EXECUTE dbo.IndexOptimize
@Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@sortinTempdb =...
--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)

April 5, 2015 at 7:09 pm

#1788827
RE: Test backup restores (full + log) - restore databases automatically

efyuzegeekgurl (4/5/2015)
Hi Jeff
Thanks for replying
Thats a good point about not copying the backup file. You are right, I decided to go down the Powershell path because of wanting to 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)

April 5, 2015 at 6:42 pm

#1788826
RE: Conversion Failed Varchar to Int - Why ??

homebrew01 (4/5/2015)
I came across this bug earlier today and did fix the code. But I was puzzled about why it failed.
I hadn't really though about this:
" the case statement can...
--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)

April 5, 2015 at 6:02 pm

#1788824
RE: Running Total Performance

Eirikur Eiriksson (4/5/2015)
Jeff Moden (4/5/2015)
Eirikur Eiriksson (4/5/2015)
here is a partial testing code which strongly indicates that the original testing is somewhat flawed.
Sorry... I don't have the time to wade through...
--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)

April 5, 2015 at 5:37 pm

#1788822
RE: Running Total Performance

Eirikur Eiriksson (4/5/2015)
here is a partial testing code which strongly indicates that the original testing is somewhat flawed.
Sorry... I don't have the time to wade through a ton of undocumented...
--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)

April 5, 2015 at 5:20 pm

#1788816
RE: CSV import to SQL having issues with non character data (Date & Decimal)

Did you ever figure this out?
--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)

April 5, 2015 at 4:53 pm

#1788814

Viewing 15 posts - 21,106 through 21,120 (of 59,098 total)