Forum Replies Created

Viewing 15 posts - 61 through 75 (of 141 total)

  • RE: SSIS 2012 - Create Catalog

    Good question and learnt something after hunting through articles on the web. I love doing research like this!

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: Foreign key

    Nice question - confused me at first until I realised no key was being created in table 2.

    This type of question really shows that's it worth reading something carefully!

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: General Qestions

    k.subramanyam1017 (5/21/2012)


    Hi friends,

    could u please any one tell me the these questions

    1) what is your company file architecture and how much data u r handle.

    2) how...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: parse string

    I think this last group of posts shows that there are several ways to attack this (including my inefficient loop).

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: parse string

    pnpsql (5/15/2012)


    i need to parse a string like

    [p]a]a]s]s][p

    when a [ sign occurs then next letter need to be convert in upper case and when a ]sign occurs the

    next...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: parameters in sql job

    One way I have accomplished this in the past is to store the parameter in a table and alter the stored procedure to read the parameter from the table.

    As far...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: Accessing SQL Server through a web page

    rd_dart (5/2/2012)


    Hi,

    I have a query regarding SQL Server. Currently I am using SQL Server 2005 Express and I have a couple of databases for various clients. This database is hosted...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: Capacity Planning - Mostly disk usage- Tool

    Have you had a look at RedGate SQL Monitor or the Idera products?

    They both provide a good set of admin tools for reporting of disk, CPU and memory but I'm...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: SYSLanguages on SQL 2012

    Good question thanks. I must admit though my answer was more luck than judgement but hey, I've learn't something too!

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: NULLS

    Thank you all again for your feedback - ISNULL and COALESCE befuddled me for a while!

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: NULLS

    Thank you all for the comments and especially to Hugo.

    I love SQLServerCentral.com - I learn something new every day and the help and assistance of other members is readily available.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Great article Jeff. I used the splitter today to break apart filenames - amazing performance for our test runs. Can't wait to let it loose across the live data on...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: getting average disk IO

    Take a look at http://sqlserverperformance.wordpress.com/2010/03/08/easy-ways-to-detect-io-pressure-in-sql-server-2008/ for some examples.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: SSRS Report Manager URl prompt for credentials in Firefox

    Microsoft don't support other browsers very well when it comes to SSRS - I've had no end of issues with rendering, buttons not appearing etc.

    It's a cheap way out but...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • RE: Beginner learning, Advise needed - SQL?

    Hi Lee,

    The Firebrand page is interesting, especially the statement "You’ll be T-SQL trained in just 2 days"; I've been using SQL for a few years and am learning new things...

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

Viewing 15 posts - 61 through 75 (of 141 total)