Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,346 through 21,360 (of 59,072 total)

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

Wayne West (3/5/2015)
podmate (3/4/2015)
...I would write a screed about how slow SSRS is, how bloated the report files are and how painful the report builder/bids tools are to use, 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 5, 2015 at 8:41 am

#1781951
RE: EXCEL HELL!!!

P Jones (3/5/2015)
When people tell me they have spreadsheets they want importing into sql, I usually ask them if they can supply it as csv because it saves any problems...
--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 5, 2015 at 8:30 am

#1781945
RE: EXCEL HELL!!!

Koen Verbeeck (3/5/2015)
P Jones (3/5/2015)
That said we do often import spreadsheets in SSIS, but you have to remember that the excel connector decides the field types based on the first...
--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 5, 2015 at 8:21 am

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

Phil Parkin (3/5/2015)
Hi Jeff, have a quick read here and you'll see that the answer is 'yes'.
Thanks, Phil. I really appreciate 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 5, 2015 at 8:18 am

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

Viewing 15 posts - 21,346 through 21,360 (of 59,072 total)