Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,461 through 20,475 (of 59,072 total)

RE: Test connection failed because of an error in initializing provider

I don't even know how to spell "SSIS" but let me bump this for you. Everyone keeps telling me how easy SSIS is so this should be an easy...
--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)

June 4, 2015 at 6:07 pm

#1803207
RE: The right way to query an extended events session?

The more I see about XE, the less I like it.
--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)

June 4, 2015 at 6:02 pm

#1803206
RE: Trying to get running Total in SQL Server

j-1064772 (6/3/2015)
No need to respin the same wheel over and over again.
]
BWAAA-HAAAAA!!!!! If that were true, there would be no use for forums at all because everything that can be...
--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)

June 4, 2015 at 6:01 pm

#1803205
RE: Help with date table

Shifting gears a bit... constantly recalculating that which will not change seems very expensive to me (in this case). Why not make another smaller table with the start and...
--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)

June 4, 2015 at 5:53 pm

#1803204
RE: Avoid LEFT join

HelloHai (6/4/2015)
Yes i want all columns from invoice table,
You query has no limiting criteria on either the invoice or customer table which means that the best you can do...
--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)

June 4, 2015 at 5:24 pm

#1803198
RE: Populating SQL tables with entries from Windows folders

lenrigby (6/4/2015)
Thanks all for replying.
I used Colin's code to give me what I needed and it ran on average 3 mins duration per folder of 500k files. This was...
--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)

June 4, 2015 at 4:04 pm

#1803188
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Leo Peysakhovich (6/4/2015)
Nice article. Thanks for taking time to write it.
But why temp tables were analyzed the way it should not be used. It is very bad way 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)

June 4, 2015 at 1:51 pm

#1803161
RE: Balance Sheet Query showing wrong amounts on VAT accounts only

raimon.tadya (6/4/2015)
Hi All
I have a query that Im using to calculate cumulative balances for Balance Sheet accounts and I need the script to be able to calculate the cumulative balance...
--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)

June 4, 2015 at 9:27 am

#1803052
RE: Are the posted questions getting worse?

Shifting gears a bit...
Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a thing would be insane.
--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)

June 4, 2015 at 9:22 am

#1803050
RE: json into sql server

manub22 (6/4/2015)
Yes Jeff,
The currently released version of SQL Server 2016 is CPT2, where you can only export SQL table rows in JSON string format.
I've put this in a blog post...
--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)

June 4, 2015 at 9:20 am

#1803048
RE: json into sql server

manub22 (6/4/2015)
Well with SQL Server 2016 you can import a JSON string into a SQL table. JSON in SQL will just work like XML with similar semantics.
This feature is coming...
--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)

June 4, 2015 at 8:57 am

#1803037
RE: SSMS truncating PowerShell output

pdanes (6/3/2015)
Mode con works, Format-Table -wrap still truncates. Thank you both.
You bet. Thanks for the feedback.
What I don't like about PoSh output is that it will vary the width...
--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)

June 4, 2015 at 8:54 am

#1803033
RE: "log shipping" by hand - SQl 2008 R2

citrowske (6/3/2015)
they are just providing us one nightly full backup and trans log backups every 15 minutes through our sftp site.
It doesn't sound to me like you need any type...
--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)

June 4, 2015 at 8:41 am

#1803026
RE: how to match two different date columns in same table and update third dat column

Learner44 (5/30/2015)
i got almost 90% but need a help to finish it...
here is what I got,
use AdventureWorks2012
CREATE TABLE tbl
([MemberCode] int, [ClaimID] int, [StartDate] date, [EndDate] date, [CaseDate] date);
INSERT INTO tbl
([MemberCode],...
--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)

June 3, 2015 at 10:55 pm

#1802868
RE: ETL question: which option is better for performance

dbodell (6/3/2015)
I am writing an ETL that will update records in a table that is fairly sizable. It has up to 10million records (not BIG data but big enough)....
--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)

June 3, 2015 at 10:32 pm

#1802866

Viewing 15 posts - 20,461 through 20,475 (of 59,072 total)