Viewing 15 posts - 18,661 through 18,675 (of 59,072 total)
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 1:29 pm
river1 (1/8/2016)
HiCXPACKET11143860.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
Change is inevitable... Change for the better is not.
January 8, 2016 at 1:15 pm
mxy (1/8/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2016 at 1:10 pm
krypto69 (1/8/2016)
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 1:05 pm
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 12:57 pm
balu.arunkumar (1/7/2016)
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 12:51 pm
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 12:42 pm
Hugo Kornelis (1/8/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2016 at 12:41 pm
Hugo Kornelis (1/8/2016)
er.mayankshukla (1/8/2016)
In a unique non clustered index, the clustered key comes to leaf level...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2016 at 8:26 am
Hugo Kornelis (1/8/2016)
Zohaib Anwar (1/8/2016)
Sean Lange (1/7/2016)
Zohaib Anwar (1/7/2016)
I am trying to build attached query that is mentioned in the word document. I am struck on one point that is...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2016 at 7:36 am
They would be correct on that quote problem. Apologies for missing that.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2016 at 7:25 am
sql_only (1/8/2016)
Jeff Moden (1/8/2016)
sql_only (1/8/2016)
bcp mydb.dbo.mytable in 'C:\_value_.txt' -S mypc\instancename -T
But the error I keep getting is unable to...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2016 at 7:05 am
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 6:56 am
sql_only (1/8/2016)
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 6:43 am
Rich Mechaber (1/8/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2016 at 6:40 am
Viewing 15 posts - 18,661 through 18,675 (of 59,072 total)