Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,076 through 21,090 (of 59,072 total)

RE: XML Nodes to retreive the child and its list of values.

Alan.B (4/8/2015)
Alan.B (4/8/2015)
pawan.clong10 (4/8/2015)
HI Alan Thanks for that quick help.
i really appreciated. well, i am actually able to retrieve the data
However, the data is coming with the same token Names...
--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 8, 2015 at 2:56 pm

#1789706
RE: Employee status on first and last day of a pay period

CELKO (4/8/2015)
What math do you on the employee identifier? None! It should never be a numeric;
Absolute rubbish and you know it, Joe. What would you use 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)

April 8, 2015 at 2:26 pm

#1789697
RE: Movie Rental Database

You should also have a status table to provide the DRI necessary for the status of each DVD. Likewise, you should also have a category table for the same...
--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 10:44 pm

#1789412
RE: Movie Rental Database

As a bit of a sidebar, if this is a typical problem being taught nowadays, then it's no wonder the industry is in a world of hurt when it comes...
--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 10:33 pm

#1789411
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

Viewing 15 posts - 21,076 through 21,090 (of 59,072 total)