Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,376 through 21,390 (of 59,098 total)

RE: BCP In error while trying to load server details from txt flat file to sql table

SQL-DBA-01 (3/4/2015)
declare @sql nvarchar(4000)
select @sql = 'bcp [DBNAME].[dbo].[servertable] in C:\folder\serverlist.txt -SLaptop-01 -T -E -n '
exec master..xp_cmdshell @sql
Getting the below error: Please suggest.
NULL
Starting copy...
SQLState = S1000, NativeError =...
--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)

March 4, 2015 at 8:14 pm

#1781816
RE: Dynamic Return type in a function

I have to agree with Chris. Use ISNULL or COALESCE instead. The code will be a lot faster than using a scalar function this way.
--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)

March 4, 2015 at 8:05 pm

#1781814
RE: File System Task - Source file wildcard?

Herpington_McDerpington (3/4/2015)
I'm working on an SSIS task for the following process.
Download FTP File with naming convention of "YESTERDAYSFILE_YESTERDAYSDATE_VARIABLETIMESTAMP.msg"
I've got this part working fine using a wildcard to select the file...
--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)

March 4, 2015 at 7:53 pm

#1781813
RE: Looking for last Month

DaveK2014 (3/4/2015)
I have a query that I need to run but I need it to look at Date A and if the month of Date A is last month 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)

March 4, 2015 at 7:47 pm

#1781811
RE: Why should i go for MS-SQL server not for Oracle and MySQL ?

theboyholty (3/4/2015)
It might be worth adding that Facebook runs on MySQL and PHP with in excess of 50 million transactions per second (as of a couple of years ago anyway).
But...
--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)

March 4, 2015 at 6:59 pm

#1781809
RE: replace() remove the last character of some values

SQL_NuB (3/4/2015)
Jeff Moden (3/4/2015)
What's wrong with just doing a replacement?
UPDATE tgt
SET Family = REPLACE(Family,'--','')
FROM dbo.yourtable
WHERE Family LIKE '%--%'
;
there are other...
--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)

March 4, 2015 at 4:26 pm

#1781797
RE: replace() remove the last character of some values

What's wrong with just doing a replacement?
UPDATE tgt
SET Family = REPLACE(Family,'--','')
FROM dbo.yourtable
WHERE Family LIKE '%--%'
;
--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)

March 4, 2015 at 3:18 pm

#1781791
RE: status suspended on command Killed/RolleBack

The 0% rollbacks will never end because there's nothing to do. If the SPID isn't consuming CPU or a shedload of data, you might leave it for the next...
--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)

March 4, 2015 at 1:52 pm

#1781762
RE: Why are cursors "more intuitive"

JeeTee (3/4/2015)
Hi All,
This is NOT a question about when to or not to use loops and cursors, but I have heard from several places that using cursors seems "more intuitive"....
--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)

March 4, 2015 at 1:40 pm

#1781757
RE: Job Interview question: slow queries

jitendra.padhiyar (3/4/2015)
Hello Jwiseh,
First go with Query execution plan, that is your query should be executed in minimum time. You can make your query better to have good execution time of...
--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)

March 4, 2015 at 8:54 am

#1781673
RE: Flip data in SQL

below86 (3/4/2015)
Why did the UNPIVOT not work for you?
Here is what I came up with:
SELECT l.ID, l.Name, l.YrMnth, l.Enrollment
FROM (SELECT ID, Name, [201401],[201402],[201403],[201404],[201405],[201406]
FROM #Table1) p
UNPIVOT (Enrollment FOR YrMnth IN ([201401],[201402],[201403],[201404],[201405],[201406])
)...
--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)

March 4, 2015 at 8:30 am

#1781665
RE: EXCEL HELL!!!

Thanks for the notes, Gosta.
This isn't actually for any application. It was actually an example spreadsheet that I saw on one of the threads that I've modified a bit....
--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)

March 4, 2015 at 8:26 am

#1781661
RE: Job Interview question: slow queries

jwiseh (3/4/2015)
Jeff Moden (3/4/2015)
Heh... whether you're interviewing for a Developer's position or a DBA's position, one of the most important things would be "communication". You and I have just...
--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)

March 4, 2015 at 2:20 am

#1781554
RE: BREAK

Heh... the correct answer is @j-2. 😛
Great question, BTW.
--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)

March 4, 2015 at 1:38 am

#1781549
RE: Job Interview question: slow queries

It's 3:30 AM here. I've gotta be up-and-at-em in a little over 3 hours. I'll be back but I need to know the answers to my questions about...
--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)

March 4, 2015 at 1:36 am

#1781548

Viewing 15 posts - 21,376 through 21,390 (of 59,098 total)