Forum Replies Created

Viewing 15 posts - 31 through 45 (of 120 total)

  • RE: How to Import data from S3 directly into my sqlserver database on amazon EC2

    Thanks,

    Actually I am new to it and haven't used this tool.

    I will test it.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    October 2, 2013 at 10:29 am

    #1655272

  • RE: Executing Dynamic SQL

    Nice one..

    Used it frequently

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 26, 2013 at 2:36 am

    #1653453

  • RE: Deletes takes a long time, but CPU, Disk and RAM untroubled...why ?

    greg.bull (9/24/2013)

    3) How could it be being blocked, I wonder ?

    If you have FK keys referencing this table then there are chances that you can experience blocking.

    what is the value...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 25, 2013 at 5:28 am

    #1653069

  • RE: TempDB - same files

    It depends on the setup.

    I would prefer to put the datafiles on separate drives.If i have 4 data files then 2 datafiles on one drive and 2 on other.

    You need...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 25, 2013 at 4:27 am

    #1653047

  • RE: Indexes missing after restoring a database to a different server

    Fishbarnriots (9/25/2013)

    The backup file is then copied to Server B and restored.

    hopefully you have restored all the required files including log files 😉

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 25, 2013 at 2:33 am

    #1653006

  • RE: CTE

    Mr. Kapsicum (9/24/2013)

    but what about ;(semi colon) of WITH ?

    i guess, it should generate an error? :discuss:

    It worked because "with ABC_CTE as" is the first statement in the batch.Go separates...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 25, 2013 at 1:15 am

    #1652971

  • RE: Dynamic Query

    ksatpute123 (9/24/2013)

    I had to think about it for a while before answering. Good one.

    same here.Thanks Smith

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 24, 2013 at 1:53 am

    #1652589

  • RE: SSRS 2008 Tool Tip Issue

    on thing you can try out

    insert new Image tooltip.

    If new Image tool tip works fine then you need to tally the properties of new Image tooltips and Old Image tooltips.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 24, 2013 at 1:48 am

    #1652586

  • RE: For Each Loop Uploads the Same File Infinitely

    use breakpoints to debug connection settings

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 21, 2013 at 4:41 am

    #1652127

  • RE: COALESCE

    Nice question,Normally asked in interviews

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 20, 2013 at 7:01 am

    #1651899

  • RE: Varchar to numeric ???

    Sean Pearce (9/20/2013)

    The ISNUMERIC function tells you if you have a valid int, numeric or float. 8E10 is a valid float.

    declare @varchar varchar(50)

    select @varchar = '8E10'

    select @varchar

    select isnumeric(@varchar)

    select convert(float, @varchar)

    go

    thanks...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 20, 2013 at 6:25 am

    #1651881

  • RE: Beginners Question on Table-Valued Functions

    user defined functions in sql server doesn't allow you to perform ddl/dml operations on permanent tables

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 20, 2013 at 5:14 am

    #1651853

  • RE: Reduce the size of database

    I didn't say that shrink work only on log file ,it can work on both.

    but none is advisable until necessary.

    back to your question:

    you can use dmvs to find missing,unused indexes

    you...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 20, 2013 at 4:55 am

    #1651850

  • RE: Reduce the size of database

    Shrink release the unused space from the databases.

    There could be multiple reasons your report is running slow.

    Either improper/bad/missing index,

    bad queries.

    to reclaim the space first check the db log size and...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 20, 2013 at 4:39 am

    #1651845

  • RE: Second Highest

    Jeff Moden (9/16/2013)

    psingla (9/16/2013)

    hopefully following will help

    http://pramodsingla.wordpress.com/category/interview-questions-2/

    siggemannen (9/16/2013)

    DENSE_RANK should do it 😉

    Or SELECT 'me' if you're a bit on the joking side...

    Or:

    SELECT MAX(salary)

    FROM t

    WHERE salary < (SELECT MAX(salary) FROM t)

    Neither...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    September 16, 2013 at 8:01 am

    #1650454

Viewing 15 posts - 31 through 45 (of 120 total)