Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,536 through 17,550 (of 59,069 total)

RE: I am really getting depressed

susmitha117 (6/3/2016)
I have been trying for a job since 6 months. I am experienced tableau developer with SSIS and SQL. Also, Did certification last year. I don't get calls. 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)

June 3, 2016 at 10:15 pm

#1883241
RE: BCP from SQL To Excel

PJ_SQL (6/3/2016)
I have this script below which is working fine, but the user wants file as .xls.
When I change the variable to set @file2 ='C:\Test.xls' ,it generates the file. When...
--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, 2016 at 9:12 pm

#1883240
RE: one ssis package to load all .csv files into relevant tables

arkiboys (6/3/2016)
Hi,
How is it possible to use just one package to load all the .csv files into the related tables?
thank you
Unless the format of all the files were structurally identical,...
--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, 2016 at 9:00 pm

#1883239
RE: Can is stop DBCC CLEANTABLE

jude.pieries (6/3/2016)
I am in the middle of claiming space from a table using DBCC CLEANTABLE (after dropping a variable length column from it ) . Its been running for more...
--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, 2016 at 8:54 pm

#1883238
RE: Looking for a way to find a process/trigger/whatever that is removing entries from a table

roy.tollison (6/3/2016)
Thanks for all the info/help. We found the issue with the 3rd party sp that was looking for orphaned entries in the lock table based upon the session_id. 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)

June 3, 2016 at 8:45 pm

#1883237
RE: Create or update rows on the basis of time interval

arihantjain121189 (6/2/2016)
Now I got a new values for attribute B on different intervals which are as:
create table input
(Id int,
A int,
B ...
--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, 2016 at 8:43 pm

#1883236
RE: Need to split the row values

p.shabbir (6/3/2016)
These records are loaded while processing the text file using ssis. If the file is missing delimiter, the next row will append it to the current row.Hence, records are...
--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, 2016 at 8:34 pm

#1883235
RE: Temp DB filling on simple update statement?

krypto69 (6/2/2016)
This was a one time update.
Heh... you can't imagine how many times I've seen supposedly "one time" things suddenly become a requirement. 😉 The company missed 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)

June 3, 2016 at 3:34 pm

#1883222
RE: More than a two-part column name - Depricated Features

gideon_king (6/3/2016)
Thank you all for answering this silly question;
Helping the optimizer, reducing clutter, and standardizing code are all things that I can live with.
thx:-)
Nah... it wasn't a silly...
--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, 2016 at 11:59 am

#1883174
RE: Bias, the Serial Killer of Diversity

David.Poole (5/27/2016)
If you turn up to an interview as Britain's worst presented compost heap then more fool you. You don't know who you are going to meet, whether visitors...
--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 2, 2016 at 9:27 pm

#1882979
RE: Full Text Indexing build very slow

Siqing LU (6/2/2016)
HI,
We are creating a full text index in the document table, which is using filestream to store doc or pdf files. the filestream size is about 150GB,...
--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 2, 2016 at 7:30 pm

#1882975
RE: Temp DB filling on simple update statement?

krypto69 (6/2/2016)
Hi Jeff,
Well it is fixed. Thanks everyone. I did run it with Gail's suggestion and it used about 30G worth of temp db space.
So for us, that 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 2, 2016 at 7:17 pm

#1882974
RE: Calculate time difference based on condition - SQL Server

subramanian.esakkimuthu 40485 (6/2/2016)
you got the answer or you are still looking for the answer
Please use the other thread that JLS provided. This one is a duplicate..
--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 2, 2016 at 7:16 pm

#1882973
RE: How to place a file into a file directory.

hoseam (6/2/2016)
Hi
I have this code, which is just a part of my code:
SET @Attachment = @FilePath + @ReportFileName
SELECT
@SQLCommand = 'BCP "SELECT * FROM ##!TableName!" QUERYOUT ' +
@FilePath +...
--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 2, 2016 at 7:07 pm

#1882972
RE: Get date range of last quarter

Lynn Pettis (6/2/2016)
The following should help:
d e c la r e -- spaced to post from work
@ThisDate date = getdate();
select
@ThisDate,
...
--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 2, 2016 at 6:55 pm

#1882970

Viewing 15 posts - 17,536 through 17,550 (of 59,069 total)