Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,186 through 31,200 (of 59,101 total)

RE: To Create PDF from SQL stored procedure

juratan (2/12/2012)
It is possible and works. The solution is not advanced, but stable. In our company, using SQL is generated thousands of pdf's. TSQL Procedure communicates with Webservice, who runs...
--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)

February 12, 2012 at 2:50 pm

#1446072
RE: One thing I keep missing in SQL

CELKO (2/12/2012)
My wife is an ordained Soto Zen Priest who could beat you with a stick, so I am a pussy cat. I do it to get the attention 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)

February 12, 2012 at 2:44 pm

#1446071
RE: One thing I keep missing in SQL

CELKO (2/12/2012)
CREATE TABLE Foobar
( num INTEGER NOT NULL PRIMARY KEY);
GO
INSERT INTO Foobar
VALUES (1), (2), (3), (4), (5);
GO
SELECT num,
MAX(num)
OVER (ORDER BY num
...
--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)

February 12, 2012 at 12:48 pm

#1446058
RE: Backup to network drive

hai21century (2/12/2012)
Thank you Jeff for your response.
Sorry for misstating, in fact the server service runs under built-in local system account instead of local admin. My question is: Is there any...
--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)

February 12, 2012 at 9:21 am

#1446047
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Thanks for the feedback, Solomon. Mighty kind of you to spend the time you did explaining what you thought.
Shifting gears a bit... On the subject of 3rd party CLR...
--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)

February 11, 2012 at 11:43 pm

#1446003
RE: Are the posted questions getting worse?

Roy Ernest (2/10/2012)
Couple of weeks back I told you all that I got a great review from work. Now they have changed my role. They want me to manage 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)

February 11, 2012 at 10:48 pm

#1446002
RE: Internationalization

dishamparikh.88 (2/11/2012)
I need to build my website in dual language, 1 is English an other is gujarati(an indian language)...nw my query is is sql server-2005 supports storage of data 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)

February 11, 2012 at 10:36 pm

#1446000
RE: Securing data from internal theft

No one get's an internet connection, all USB ports are phyiscally removed as are all other ports that could be used for memory such as flash cards, all media drives...
--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)

February 11, 2012 at 10:24 pm

#1445999
RE: Backup to network drive

Just grant the user name for the SQL Service the privs to read and write to folder on the network drive and use a UNC name instead of a shared...
--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)

February 11, 2012 at 10:16 pm

#1445998
RE: Totaling 1 row's #'s from a distinct related row

pharmboy4u (2/11/2012)
Thanks Jeff.
The problem is my test code must not adequately reflect the issue I'm having. My issue is still separating the 'sums' as I posted just prior 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)

February 11, 2012 at 10:14 pm

#1445997
RE: the TSQL code for this query...is needed.

Mmmmmm.... Porkchops marinated in beer. 😀
Hey, Graham... here's a little tip for you to try...
SET STATISTICS IO, TIME ON;
...
some code to be measured
...
SET STATISTICS IO, TIME OFF;
I know, I know......
--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)

February 11, 2012 at 10:11 pm

#1445996
RE: Tab delimited report

Yes. My recommendation is don't use a report builder for this. Either use SSIS or build a stored procedure to do 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)

February 11, 2012 at 9:58 pm

#1445994
RE: OLTP, OLAP and none of the above

Just my 2 cents on the subject. You can't actually have OLAP without OLTP. The data has to come from somewhere. OLAP is "just" an analysis tool.
--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)

February 11, 2012 at 9:56 pm

#1445993
RE: Can I get three examples of ETL?

PaulB-TheOneAndOnly (2/11/2012)
Just loading a table hardly qualifies as ETL.
Seriously? You don't think that taking a mega-row text file from something like Double-Click.Net and loading it into a table qualifies...
--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)

February 11, 2012 at 9:53 pm

#1445992
RE: What is the benefit of SSIS with respect to ETL?

PaulB-TheOneAndOnly (2/11/2012)
...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.
Gosh... it's a whole lot more than that. ETL...
--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)

February 11, 2012 at 9:48 pm

#1445991

Viewing 15 posts - 31,186 through 31,200 (of 59,101 total)