Jeff Moden

Forum Replies Created

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

RE: Table Creation - Tool

I especially hate it when a Developer that doesn't know, creates tables using Visual Studio or has VS auto-magically create the tables from objects because almost everything comes out as...
--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)

January 8, 2016 at 12:57 pm

#1850663
RE: Finding Jobs Based on Mail ID Used in DB Mail

balu.arunkumar (1/7/2016)
Hi,
I have added my mail ID in all automated reports which is sending through DB mail. Now i want to remove my mail id from all automated reports.
But 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)

January 8, 2016 at 12:51 pm

#1850661
RE: Clustered and NonClustered Index

Jacob Wilkins (1/8/2016)
This seems relevant as well: http://www.sqlskills.com/blogs/kimberly/nonclustered-indexes-lookup-key-btree/
Cheers!
Excellent reference. You can't do much better that getting it straight from the horse's mouth. Thanks, Jacob.
--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)

January 8, 2016 at 12:42 pm

#1850658
RE: Clustered and NonClustered Index

Hugo Kornelis (1/8/2016)
Okay, did a small test and confirmed that my faith in Gail was justified (and my faith in my own understanding of index internals was not). After creating...
--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)

January 8, 2016 at 12:41 pm

#1850656
RE: Clustered and NonClustered Index

Hugo Kornelis (1/8/2016)
er.mayankshukla (1/8/2016)
I need an explanation may be pointing to some whitepaper for the explanation of below:
In a unique non clustered index, the clustered key comes to leaf level...
--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)

January 8, 2016 at 8:26 am

#1850549
RE: Need help in Query Please help!!!

Hugo Kornelis (1/8/2016)
Zohaib Anwar (1/8/2016)
Sean Lange (1/7/2016)
Zohaib Anwar (1/7/2016)
Hi,
I am trying to build attached query that is mentioned in the word document. I am struck on one point that is...
--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)

January 8, 2016 at 7:36 am

#1850529
RE: BCP error -Unable to open BCP host data-file

They would be correct on that quote problem. Apologies for missing 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)

January 8, 2016 at 7:25 am

#1850519
RE: BCP error -Unable to open BCP host data-file

sql_only (1/8/2016)
Jeff Moden (1/8/2016)
sql_only (1/8/2016)
I want to import data to my database via bcp like this
bcp mydb.dbo.mytable in 'C:\_value_.txt' -S mypc\instancename -T
But the error I keep getting is unable 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)

January 8, 2016 at 7:05 am

#1850508
RE: Creating Seperate Schema

johnwalker10 (1/7/2016)
Why should I create separate schemas?
There may be an impact on the performance of the query optimizer, albeit a small one, depending on your coding style
Do you...
--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)

January 8, 2016 at 6:56 am

#1850503
RE: BCP error -Unable to open BCP host data-file

sql_only (1/8/2016)
I want to import data to my database via bcp like this
bcp mydb.dbo.mytable in 'C:\_value_.txt' -S mypc\instancename -T
But the error I keep getting is unable to open BCP host...
--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)

January 8, 2016 at 6:43 am

#1850494
RE: Send email from T-SQL

Rich Mechaber (1/8/2016)
Thanks for posting this, Jeff. I doubt I'll have occasion or need to use it, but I'm always interested in unusual ways of cat skinning. 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)

January 8, 2016 at 6:40 am

#1850493
RE: Page split with Clustered index

imct1960 (1/8/2016)
Thanks Jeff, I was reading the article today and was hoping for a conclusion.
It does annoy me, the accusations of thread resurrection. If the new info. is...
--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)

January 8, 2016 at 5:54 am

#1850478
RE: Creating Seperate Schema

SQL!$@w$0ME (1/7/2016)
Why should I create separate schemas?
Depending on what you need to protect from group to group, the use of schemas can make privs a bit easier to assign...
--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)

January 8, 2016 at 5:40 am

#1850475
RE: the use of CTEs

Jason A. Long (1/7/2016)
Jeff Moden (1/7/2016)
Can't argue that without an example. I'll have to check on some of the execution plans on my prod system. I'm pretty sure...
--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)

January 8, 2016 at 5:37 am

#1850473
RE: the use of CTEs

Hugo Kornelis (1/8/2016)
Jeff Moden (1/7/2016)
Alan.B (1/6/2016)
You can't write a recursive CTE with using pre-CTE features.
Technically correct because only an rCTE can be an rCTE but the rather well advertised...
--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)

January 8, 2016 at 5:31 am

#1850471

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