Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,661 through 18,675 (of 59,072 total)

RE: Where to start...

Edvard Korsbæk (1/5/2016)
So, what would you recommand for reading to come a bit further than i am today?
A lot of good books and articles have already been cited 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 1:29 pm

#1850679
RE: CXPACKET very high (average 55 %)

river1 (1/8/2016)
Hi
CXPACKET11143860.7210627025.50516835.2297746866455.110.01140.01090.0005
the values for CXPACKET are very high.
We had the parallelism in 6, then we changed to 1. No good still
Any idea ?
Thanks
A lot of times, CXPACKET is just a...
--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 1:15 pm

#1850674
RE: CPU question

mxy (1/8/2016)
I have few questions about CPU details displayed in SET statistics TIME ON. Query runs fast, what does CPU time represent. Can we convert that value to a percentage...
--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 1:10 pm

#1850672
RE: CLR concatenate function without duplicate values

krypto69 (1/8/2016)
Hi,
I have a CLR that uses a concatenate function:
https://www.mssqltips.com/sqlservertip/2022/concat-aggregates-sql-server-clr-function/
(andy)
The problem is I am getting duplicates - I know it's supposed to return duplicates, and I know you can eliminate...
--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 1:05 pm

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

Viewing 15 posts - 18,661 through 18,675 (of 59,072 total)