Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,921 through 49,935 (of 59,091 total)

RE: database tuning engine problem

Unfortunately... no... I don't. Sounds like you have everything you need to run it correctly.
--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 18, 2008 at 7:16 am

#830384
RE: Theoretical question about importing from Excel using SSIS

GSquared (6/17/2008)
Matt Miller (6/17/2008)
I've done something like that with DTS a few times. For better or worse - I found it easier to have DTS handle the importing 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)

June 18, 2008 at 7:13 am

#830380
RE: Limitation fo AND's and OR's

karthikeyan (6/18/2008)
I have executed a query which has more number of ( around 500) string's in the IN clause. (All of us know IN will be treated internally as OR...
--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 18, 2008 at 7:05 am

#830366
RE: Double Check

Syed (6/17/2008)
Also one problem with documentation (atleast places i have worked) is that initially documentation is created but after some time process is changed and no one updates the documentation....
--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 18, 2008 at 6:59 am

#830362
RE: never heard of built-in function row_number?

Very well said.
--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 17, 2008 at 11:25 pm

#830207
RE: Data extraction from a concatenated field

Please see the following for how to do a numbered "split"
http://www.sqlservercentral.com/articles/T-SQL/63003/...
--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 17, 2008 at 11:21 pm

#830206
RE: database tuning engine problem

You may not have the privs to run 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)

June 17, 2008 at 11:14 pm

#830201
RE: PatIndex on varbinary Column

Open a Word document in a text editor like Notepad and let me know if you think a search for any word would actually work...;)
--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 17, 2008 at 11:12 pm

#830200
RE: performing a DIR command from a sproc without using XP_CmdShell

I suppose you could have someone write a CLR for this particular functionality.
--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 17, 2008 at 11:10 pm

#830198
RE: Gouping Related Stored Procedures

You could assign them to "owners" other than DBO...
--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 17, 2008 at 11:07 pm

#830197
RE: Generate 5 digit random numbers

ola_blixten (6/17/2008)
Hey!
My case:
I want to generate 5 digit random numbers which should start with:
00001
00002
00003.....
and 2 digit for week so from 1-52
and 1 digit for year, from 0-9
And everyting should be...
--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 17, 2008 at 11:06 pm

#830196
RE: CSV data import/export via a stored procedure?

OpenRowSet will not create a new file. It can be used to populate an existing file. Same goes with a text based linked server.
Bulk Insert will certainly do...
--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 17, 2008 at 11:02 pm

#830195
RE: What is the difference between SQL Server 2000 SP3 vs. SP4 ?

There were also some security enhancements that smack of deprecations... for example... sp_MakeWebTask now requires SA Privs to use...
--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 17, 2008 at 10:54 pm

#830193
RE: Alternate for Varchar(8000)

You could always store the document(s) in a file and store the file path/name in the database. Kind of a universal solution for all RDBMS's...
--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 17, 2008 at 10:52 pm

#830191
RE: Large File Transfer Tool

Well... that's a mighty nice gesture. Thanks...
I do have a couple of things to share...
http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/
--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 17, 2008 at 10:46 pm

#830189

Viewing 15 posts - 49,921 through 49,935 (of 59,091 total)