Forum Replies Created

Viewing 15 posts - 1 through 15 (of 243 total)

  • RE: Retrieve rows only if the difference in two rows is less than 2

    nmalepati (5/11/2010)

    Hello All,

    I have a table that has data in below format:

    UserID PackageID ...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    May 14, 2010 at 3:34 am

    #1167394

  • RE: Query perfomance Issue

    imran_ghainsh (5/14/2010)

    I made a Stored Procedure as Process with Table Index but when I Executed it on my Local PC it takes 50 Second for 27000 Records Process but while...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    May 14, 2010 at 3:30 am

    #1167390

  • RE: Migrate from MSSQL 2000 to MSSQL 2005 in the same server

    bengchoo.kuah (5/12/2010)

    Hi, we need to migrate our Production server from MSSQL 2000 to MSSQL 2005.

    This has to be done on the same server itself. Can anyone advise what is the...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    May 14, 2010 at 3:24 am

    #1167387

  • RE: email excel report

    bobby.creech (3/26/2010)

    ok, I've got a report on the report server that gets clients by state, either individual or all. very simple report, client name and state.

    they would like this...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    April 14, 2010 at 7:47 am

    #1151341

  • RE: Set Dynamic from address in Sp_Send_DbMail

    sananthakumar (4/13/2010)

    I am using Sp_Send_DbMail to send the mails. Everything works fine. But When we try to change the from address from code it wont allow and also through the...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    April 14, 2010 at 7:31 am

    #1151327

  • RE: How to find out total disk space and availabe disk space

    To run xp_fixeddrives , you have require system admin rights.

    vinayak_mohan (8/12/2009)

    Hello guys,

    The Stored procedure "xp_fixeddrives" will give you the free space on the disk. Is there any other sp which...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 18, 2009 at 1:24 am

    #1093904

  • RE: Which Join having more I/O and CPU Cyecle ?

    Yes, i have read all the difference.

    As per Loop join have more and cpu cycle i think, Am i right?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    August 27, 2009 at 5:03 pm

    #1045977

  • RE: SQL Server Health , DashBorad and Status report

    I require urgently ....

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    May 28, 2009 at 12:12 am

    #1001228

  • RE: uncommittable transaction is detected at the end of batch. the transaction is rolled back

    we have compare two databases both are same on both servers.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    May 6, 2009 at 8:13 am

    #989564

  • RE: SQL Injection

    SQAPro (2/11/2009)

    Paresh Prajapati (2/11/2009)

    SQAPro (2/11/2009)

    That's not a 'valid' IP, it's one of the ones that is reserved for special or future uses..

    http://www.iana.org/assignments/ipv4-address-space/

    You sometimes see that IP used by trojans or...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    February 11, 2009 at 10:49 pm

    #942616

  • RE: How to identify the objects which are altered based on date?

    Erode P. Satheesh (2/10/2009)

    Thanks Paresh Prajapati. I checked only in sys.sysobjects before posting :rolleyes:.

    Thanks GSquared, I will consider using DDL Triggers. Can you help me with best practice documents?

    Thanks for...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    February 11, 2009 at 5:57 am

    #942037

  • RE: SQL Injection

    SQAPro (2/11/2009)

    That's not a 'valid' IP, it's one of the ones that is reserved for special or future uses..

    http://www.iana.org/assignments/ipv4-address-space/

    You sometimes see that IP used by trojans or botnets as a...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    February 11, 2009 at 5:55 am

    #942036

  • RE: SQL Injection

    SQAPro (2/10/2009)

    Paresh Prajapati (2/10/2009)

    SQAPro (2/6/2009)

    What are the first two octets of of the IP address?

    Did you try running it through one of the whois links provided above?

    Only I know that...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    February 10, 2009 at 10:32 pm

    #941820

  • RE: How to identify the objects which are altered based on date?

    Satheesh Kumar (2/10/2009)

    How can I find out the objects (sp/tables) which are altered on a particular date or when it is last altered?

    -- Tables

    select * from sys.objects where type =...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    February 10, 2009 at 8:53 am

    #941319

  • RE: SQL Injection

    SQAPro (2/6/2009)

    What are the first two octets of of the IP address?

    Did you try running it through one of the whois links provided above?

    Only I know that from Network people...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    February 10, 2009 at 8:46 am

    #941306

Viewing 15 posts - 1 through 15 (of 243 total)