Forum Replies Created

Viewing 15 posts - 19,231 through 19,245 (of 49,552 total)

  • RE: Problem in passing of parameters in a stored procedure. Please help.

    There is absolutely no need for dynamic SQL here (and the problem was that there were no quotes around the concatenated string in the dynamic SQL.

    CREATE PROCEDURE SearchRecords

    @searchQuery AS NVARCHAR(100),

    @col...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 6:39 am

    #1471156

  • RE: SQL Server 2012 Beta Exam Results

    richard.woodward (4/10/2012)

    This was a bit of an anti-climax since I was expecting to see a PASS or FAIL. Was this a surprise to anyone else taking these beta exams?

    No. The...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 4:30 am

    #1471133

  • RE: Database-->Task-->Shrink-->Log-->Free Unused space; Recommended ?

    ajay.g (4/10/2012)

    So whenever any Delete operations applied on the DB, the space in the Log file will remain same, eventhough the record deleted.

    ???

    If you think, heavy transactions applied...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 4:26 am

    #1471132

  • RE: Get only 100 records in a transaction using LSN

    sai198503 (4/10/2012)

    For a single transaction i may get more than 400 records in one shot.for every single transaction i believe a new LSN will be created for each transaction.

    No, LSNs...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 4:23 am

    #1471131

  • RE: how to separate value columns my matching two flag

    yingchai (4/10/2012)

    Hi Cadavre,

    bbb will be Inbound and aaa will be Outbound.

    Which columns determine that?

    SQL does not have any concept of a row's position within a table, a table is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 4:21 am

    #1471130

  • RE: Are the posted questions getting worse?

    Is the program manager of the query optimiser team sufficient of an authority?

    http://blogs.msdn.com/b/conor_cunningham_msft/archive/2008/08/27/no-seatbelt-expecting-order-without-order-by.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 4:17 am

    #1471128

  • RE: Syntax help on how to change a column from asc to desc?

    GilaMonster (4/3/2012)

    btw, the way you do it is:

    ALTER TABLE ... DROP CONSTRAINT (to drop the primary key constraint)

    ALTER TABLE ... ADD CONSTRAINT (recreate the primary key as you want it)

    Won't...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 2:03 am

    #1471098

  • RE: Replication of the SQL-Server

    Is SQL Agent running?

    Are all the replication agents running?

    What does replication monitor show?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 2:02 am

    #1471097

  • RE: query help

    You say it's not homework, then you say it's practice for the next class. How is that not homework?

    First thing, how do you get the list of students with the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 2:00 am

    #1471096

  • RE: Backup and Restore permission to user

    Is the folder on the local machine or elsewhere? If elsewhere, you'll have to use a domain account for SQL Server, local system doesn't have any rights outside of the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 10, 2012 at 1:58 am

    #1471094

  • RE: Replication of the SQL-Server

    Without a lot more detail on what steps you did, what you checked, what (if any) errors, etc, no, no ideas.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 9, 2012 at 5:46 pm

    #1471007

  • RE: query help

    Not doing your homework for you...

    What have you got so far and what precisely are you struggling with?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 9, 2012 at 5:45 pm

    #1471006

  • RE: query help

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Is this homework?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 9, 2012 at 4:54 pm

    #1470991

  • RE: DB whitespace

    So they'd rather see free space wasted at a disk level than free space 'wasted' in a database?

    Seriously, unless there's huge space free in the DB, there is no gain...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 9, 2012 at 2:12 pm

    #1470919

  • RE: DB whitespace

    Why do you want to reclaim it?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 9, 2012 at 1:44 pm

    #1470909

Viewing 15 posts - 19,231 through 19,245 (of 49,552 total)