Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,711 through 25,725 (of 59,099 total)

RE: The Ratio

John Mitchell-245523 (10/7/2013)
David.Poole (10/7/2013)
Jeff Moden (10/5/2013)
Heh... you have to trust me on this... You DON'T actually want them to do their own backups. 😉
Backups fine, restores...not so...
--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)

October 7, 2013 at 4:08 pm

#1656559
RE: Are the posted questions getting worse?

L' Eomot Inversé (10/6/2013)
There are a number of firms that stick to offering low amounts in the hope of persuading government that because they get no useful applicants there must...
--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)

October 6, 2013 at 4:50 pm

#1656203
RE: single quotes

Just a reminder to remember not to use anything from the parameters in direct concatenation in the dynamic SQL. Poorly formed dynamic SQL is still the leading cause 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)

October 6, 2013 at 4:38 pm

#1656202
RE: split a comma delimited string into columns

mynkdby (10/3/2013)
DECLARE @p NVARCHAR(MAX)
SELECT @P = 'MONDAY,SUN,FUN,D'
DECLARE @STRSQL NVARCHAR(MAX)
SET @sql = 'SELECT ''' + REPLACE(@P,',',''',''') + ''''
EXEC( SQL)
Above Code is splitting the comma delimited string into four columns but how...
--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)

October 6, 2013 at 4:04 pm

#1656201
RE: split a comma delimited string into columns

mynkdby (10/4/2013)
Actually there can be any number of commas in between input parameter so in that only having 4 column thing is incorrect...
and the code you have provided that 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)

October 6, 2013 at 3:42 pm

#1656200
RE: split a comma delimited string into columns

J Livingston SQL (10/6/2013)
Hello
please see some code (still work in progress) below
the idea is to strip a csv column into separate columns:
the number of columns is indeterminate as is the...
--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)

October 6, 2013 at 3:34 pm

#1656199
RE: split a comma delimited string into columns

Sorry... deleted bad post.
--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)

October 6, 2013 at 3:28 pm

#1656198
RE: What is the most important to DBA (Windows Server or .Net)?

MohamedDBA (10/6/2013)
What is the most important thing to the DBA , is to know windows server deeply or to know .Net deeply like (VB , C#) what is more significant...
--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)

October 6, 2013 at 12:55 pm

#1656181
RE: single quotes

Lucky9 (10/6/2013)
i have a stored procedure where the customername parameter is a comma separated
i am calling that parameter in the dynamic where clause the problem is am getting the error...
--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)

October 6, 2013 at 12:25 pm

#1656179
RE: Recursive Stored Procedure

Both of the above methods leave you wide open to SQL Injection attacks.
With that in mind, let me ask... are all of the Academics_xx tables identical in every way except...
--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)

October 6, 2013 at 12:10 pm

#1656174
RE: Are the posted questions getting worse?

I'm not actually looking for a job but it's sometimes a good thing to check on what the going rates are for different jobs. I'm seeing a fair number...
--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)

October 6, 2013 at 11:32 am

#1656170
RE: Are the posted questions getting worse?

Greg Edwards-268690 (10/6/2013)
Jeff Moden (10/5/2013)
Speaking of "unbelievable", is [font="Arial Black"]THIS[/font] all that a Master's degree + the ability to walk on water is worth nowadays?
But they have phone reimbursement. ...
--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)

October 6, 2013 at 11:20 am

#1656169
RE: Slow Script

homebrew01 (10/6/2013)
What if you want to include non-matches against T3 ? Would you add to the WHERE clause ?
and T3.COL1 is NULL
and T3.COL2 is NULL
and T3.COL3...
--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)

October 6, 2013 at 11:14 am

#1656168
RE: Generate and send report via email in PDF format which method better

p.s. I forgot one caveat of sp_Send_DBMail... the default size of any attachment is only 1MB. Please lookup sp_Send_DBMail in "Books Online" and look for @file_attachments. according...
--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)

October 6, 2013 at 11:04 am

#1656166
RE: Generate and send report via email in PDF format which method better

Ah... understood. I thought you were trying to "illegally" bypass established protocols of development in your company. Thanks for the clarification.
I believe this could be done in a...
--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)

October 6, 2013 at 10:58 am

#1656165

Viewing 15 posts - 25,711 through 25,725 (of 59,099 total)