Forum Replies Created

Viewing 15 posts - 22,456 through 22,470 (of 59,099 total)

  • RE: Export to excel row colors

    Heh... and people ask me why I use T-SQL to build HTML for my morning reports. We're going through our first setup of SSRS 2012 at work. There...

    --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)

    November 18, 2014 at 9:00 am

    #1759318

  • RE: Remove Character from specific Column

    ahfb (11/18/2014)

    Hi Firends

    How to remove Character From Column,Just Character.

    I want to work with number.

    Tnx For Help

    Do you mean you want to remove all non-numeric-digits from the column? And, like...

    --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)

    November 18, 2014 at 8:50 am

    #1759313

  • RE: How do you pad left like using T-SQL query?

    Alex Jordan (11/17/2014)

    Trying to pad zero's to the left of number to find n.Num LIKE

    SELECT * FROM tblNumbers n WHERE n.Num LIKE 'RIGHT('00000' + CONVERT(VARCHAR, CONVERT(INT, '1234')), 5)%' ORDER 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)

    November 17, 2014 at 9:35 pm

    #1759148

  • RE: Monitoring Tool For SQL Server

    rajan.nithin (11/17/2014)

    Hi,

    Can somebody help me by suggesting the best Free Monitoring tool for SQL Server.

    How many servers? I ask because it's tough to eyeball more than one server at...

    --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)

    November 17, 2014 at 9:11 pm

    #1759146

  • RE: System Database Locations: Why?

    andre.quitta (11/17/2014)

    I had my infrastructure manager recently ask me why the system databases are in a different directory than the user databases.

    Contrary to what the others have said and 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)

    November 17, 2014 at 8:50 pm

    #1759142

  • RE: SQL Management Studio 2005 _ JOB

    artbalauro (11/17/2014)

    Hi there,

    Just want to ask if theres a way on sql management studio 2005, to create one job for one database having steps and scheds ( daily, weekly, monthly...

    --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)

    November 17, 2014 at 8:00 pm

    #1759139

  • RE: Joining the results of two queries without creating temporary tables.

    MMartin1 (11/17/2014)

    dogramone (11/16/2014)

    Are you making a stored procedure call here? I'd recommend it and then make the first line "set nocount off" and the last "set noucount on". ...

    --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)

    November 17, 2014 at 7:25 pm

    #1759136

  • RE: Are the posted questions getting worse?

    spaghettidba (11/17/2014)

    Steve, spam deletion in a good thing, but preventing spam is better in my opinion.

    I just registered to the site with one of my addresses and it simply asks...

    --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)

    November 17, 2014 at 11:56 am

    #1759059

  • RE: Where are the DBA's!?

    schwizla (11/17/2014)

    Hey everyone. Does anyone have any idea roughly how many SQL DBA's there are globally or how they are geographically dispersed? I am thinking that really the only way...

    --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)

    November 17, 2014 at 7:54 am

    #1758992

  • RE: Passing Integers in my query

    Ah, thanks.

    I guess I'm going to have to figure out something to make a DelimitedSplit8K that works for things > 8K characters because doing a REPLACE to build the XML...

    --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)

    November 17, 2014 at 7:09 am

    #1758963

  • RE: Normalizing Performance

    I'll also add that I've seen many well intentioned good folks spend a huge wad of money on brand new servers with tons of memory and very high performance SANs,...

    --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)

    November 16, 2014 at 5:57 pm

    #1758858

  • RE: Joining the results of two queries without creating temporary tables.

    thomaswellington (11/16/2014)

    I am not calling a stored procedure in my query. (I don't think I can call any stored procedures from the data base.) I just want 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)

    November 16, 2014 at 5:36 pm

    #1758857

  • RE: Rebuild Index first or Update statistics first?

    smtzac (11/16/2014)

    I am planning to use Maintenance plan to rebuild index and update statistics.

    I know, rebuild indexes also update index statistics not the column. if I run rebuild index first...

    --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)

    November 16, 2014 at 5:30 pm

    #1758856

  • RE: Passing Integers in my query

    Eirikur Eiriksson (11/16/2014)

    Quick suggestion for a solution, many ways of doing this though

    😎

    DECLARE @ProductID XML;

    SET @ProductID = CONVERT(XML,REPLACE(

    '

    ' + '2674,2711,2756,2818,2845,2889,2891,2920,3623,3768,3866,3878,3889,4084,4091,4113,4742,4753,5310,5313,5505,5512,5542,5569,5620,5781,5926,6012,6082,6090,6091,6117,6118,6207,6226,6233,6298,6316,6383,6477,6523,6589,6601,6715,6728,6785,7216,7326,8096,8643,9836,10335,10387,10403,10957,11007,11031,11184,11490,11722,11857,12105,12121,12126,12130,12190,12744,13144,13523,13665,13693,14865,15293,15294,15302,15724,15784,16175,16307,16843,16846,16995,17184,18133,18877,18911,19263,19402,19666,19955,20601,21484,22620,22622,23298,24815,24821,25148,26194,26976,27078,27333,27572,27761,27803,27806,27825,27830,29380,29478,30278,31263,31742,31745,32548,32625,32719,33525,33565,34581,34674,34861,34910,35415,35780,35999,37080,38366,38953,39843',',','

    ') + '',0);

    ;WITH PRODUCT_IDS AS

    (

    SELECT

    ...

    --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)

    November 16, 2014 at 5:21 pm

    #1758855

  • RE: Group by question

    As a bit of a sidebar, ID1 thru 4 should probably be INT rather than VARCHAR according to your test data. It'll save space, perhaps some performance, and save...

    --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)

    November 16, 2014 at 4:51 pm

    #1758853

Viewing 15 posts - 22,456 through 22,470 (of 59,099 total)