Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,801 through 22,815 (of 59,099 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Solomon Rutzky (9/9/2014)
In the end, isn't this why Microsoft gave us CLR Integration?
Heh... yeah... just like they gave us the ability to write extended stored procedures. 😉 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)

September 10, 2014 at 1:10 am

#1744329
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

dwain.c (9/7/2014)
Jeff Moden (9/5/2014)
That took me by surprise the first time I worked with Oracle, as well. NULL same as '' not same as ' '.
The other thing that...
--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)

September 10, 2014 at 1:05 am

#1744328
RE: Pass entire where sentence to a store procedure

Matt Miller (#4) (9/8/2014)
Jeff Moden (9/8/2014)
adonetok (9/8/2014)
Is it possible to pass entire where sentence to a store procedure?
From app, I'll generate a where sentence like below:
where orderID = '123' 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)

September 9, 2014 at 9:00 am

#1744156
RE: sp_xp_cmdshell_proxy_account who has been granted to use it?

w.oldoerp (9/8/2014)
Thank you both for the answers.
Revoke was to easy 😉
We use xp_cmdshell in this Situation, because we found it the only way to start an Interface to SAP from...
--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)

September 8, 2014 at 2:52 pm

#1743963
RE: Denormalising Data

Here's another article that you might want to check out. It explains PIVOTs and the wonders of an "ancient" tool known as a CROSSTAB.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

September 8, 2014 at 2:30 pm

#1743958
RE: Problem with html table

rash3554 (9/8/2014)
Business needs. Non-IT/non-database people need to see this and we thought if we can do 10,000 in each html file. they can scan through it and report us 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)

September 8, 2014 at 2:24 pm

#1743956
RE: Pass entire where sentence to a store procedure

adonetok (9/8/2014)
Is it possible to pass entire where sentence to a store procedure?
From app, I'll generate a where sentence like below:
where orderID = '123' and orderCidy='London'
I created a store procedure...
--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)

September 8, 2014 at 12:42 pm

#1743940
RE: Problem with html table

rash3554 (9/7/2014)
Hi,
The table below has about 2 million rows.
I want to convert this to html table. I have non-english characters in the table & that is why I used nvarchar....
--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)

September 8, 2014 at 8:04 am

#1743872
RE: sp_xp_cmdshell_proxy_account who has been granted to use it?

First of all, you should never ever grant individual users the privs to use xp_CmdShell directly because it provides are very large escalation of privs. Always write the calls...
--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)

September 8, 2014 at 12:06 am

#1743769
RE: why don't we have two clustered index in a table?

Apologies for the brutal honesty but, if you're interviewing for the position of DBA or Database Developer, you either need to hit the books hard or consider another career.
If you're...
--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)

September 7, 2014 at 11:58 pm

#1743764
RE: What is extended proc sp_releaseschemalock

Shawn Wilson (9/5/2006)
I've seen this happen where there was a linked server query running and killed. However the connection persisted and was reporting it was at a 100 percent in...
--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)

September 6, 2014 at 10:21 pm

#1743697
RE: Data from one Table to Two Columns

Post withdrawn... I ended up posting pretty much the same code as Chris.
--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)

September 6, 2014 at 7:27 pm

#1743694
RE: help parsing a text field

I love problems like this because there are so many ways to accomplish them. I also like this particular post because it shows what normally occurs.... code written 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)

September 6, 2014 at 4:56 pm

#1743692
RE: The Real Scary DBAs

Oh, you've hit a real pain point for me. Rather than go into a rant about it, I'll just say I'm glad that someone finally wrote about this problem.
--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)

September 6, 2014 at 4:34 pm

#1743691
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

That took me by surprise the first time I worked with Oracle, as well. NULL same as '' not same as ' '.
The other thing that took me by...
--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)

September 5, 2014 at 6:29 pm

#1743646

Viewing 15 posts - 22,801 through 22,815 (of 59,099 total)