Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,636 through 22,650 (of 59,102 total)

RE: Bending strings

Steve Jones - SSC Editor (10/13/2014)
Based on this, which is an interesting problem: http://www.sqlservercentral.com/Forums/Topic1625170-2799-1.aspx
Show how to move rows to a delimited string and then summarize.
What would you suggest as 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 13, 2014 at 9:16 am

#1752012
RE: How to use stuff function in this case

What has become a classic method for doing this may be found at the following URL...
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--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 13, 2014 at 9:12 am

#1752011
RE: Arithmetic overflow error converting varchar to data type numeric.

Absolutely no idea without you posting the query.
--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 13, 2014 at 7:52 am

#1751987
RE: Function

monique 88355 (10/13/2014)
Hi
Thank you so much! You are awesome!
Can I just ask one more thing?
I've added ', ' to my query [@RetVal = @RetVal + c.Descr + ', ']...
--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 13, 2014 at 7:50 am

#1751986
RE: Document, then Install

To me, installing a system and then documenting it means that there was little or no planning for the new system. That's means that a whole lot of things...
--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 13, 2014 at 7:47 am

#1751984
RE: Best way to insure proc makes it

I guess my question would be, why aren't you running this from the external server instead of having to use DTC?
--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 13, 2014 at 7:42 am

#1751983
RE: Standard Edition - SORT_IN_TEMPDB

DBA_Learner (10/13/2014)
That's great. Thank you for information.
Also, since my server is of Standard edition and not having any RCSI enabled or having Index rebuild ONLINE option, installing below hot fix...
--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 13, 2014 at 7:37 am

#1751981
RE: Log Shipping Files getting huge and difficult to transfer

alejandro-jasso (10/8/2014)
Hi,
Currently I have 2 SQL 2008 Standard Edition servers with one DB that is configured to do log shipping between them. These 2 servers are is same network 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 12, 2014 at 9:44 pm

#1751895
RE: xp_cmdshell / file level permissions

Jason Shadonix (10/12/2014)
I share your concerns, and appreciate you pointing this out, but unfortunately (as I'm sure you experts know) there are some cases where we have no choice 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)

October 12, 2014 at 8:42 pm

#1751892
RE: find if log backup can be run

Mad-Dog (10/12/2014)
Hi,
if i set database from full recovery into simple and then back to full recovery i can't run the TLog backup until i run Full or Diff DB backup.
what...
--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 12, 2014 at 2:09 pm

#1751886
RE: The wisdom of developers

sqldriver (10/12/2014)
Jeff Moden (10/12/2014)
sqldriver (10/9/2014)
They insisted something was wrong and that it was always faster. I told them to come back when they found it faster their way.
That's kind...
--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 12, 2014 at 1:54 pm

#1751884
RE: xp_cmdshell / file level permissions

@jason,
Don't do it the way you're doing it. YOU MUST NOT GRANT NON-SYSTEMADMINS PRIVS TO RUN XP_CMDSHELL DIRECTLY!!! Please, please, PLEASE! For the good of yourself 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)

October 12, 2014 at 10:34 am

#1751873
RE: Standard Edition - SORT_IN_TEMPDB

DBA_Learner (10/11/2014)
I got SQL Standard edition of version 2008R2 with a large database table. Initally, when I used to run below index fragmentation script from Microsoft [http://msdn.microsoft.com/en-us/library/ms188917%28v=sql.105%29.aspx], I see after...
--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 12, 2014 at 9:58 am

#1751871
RE: smtp mail

p.s. And, not to be insulting in any way, shape, or form, if you don't know what the product called "Books Online" actually is, please post back. It'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)

October 12, 2014 at 9:46 am

#1751869
RE: smtp mail

ramana3327 (10/12/2014)
Hi All,
I need to find when we did subscription, why the person didn't receive email.
How to find the ssrs report emails are working?
When we subscribed the report it will...
--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 12, 2014 at 9:44 am

#1751868

Viewing 15 posts - 22,636 through 22,650 (of 59,102 total)