Forum Replies Created

Viewing 15 posts - 46 through 60 (of 88 total)

  • RE: A Genetic Algorthm Sample in T-SQL

    youngi (1/14/2010)


    Pieter

    The first square 0,0 is the rule has n=2;s=1;e=1;w=2;c=1

    as per

    --1100010010

    --1101101111

    ...

    this then selects the gene number 206 (from 2*81+1*27+1*9+2*3+1*1+1) from the dna. The rules are not in order of execution...

  • RE: CDC and reindexing error

    You know, it's been so long I forgot what this was about. I got the error after setting up change data capture on a table. If I tried...

  • RE: DDL log

    Richard M. (11/9/2009)


    @ben: would you mind sharing the exact steps setting it up, users and access? As explained in my original post, that's what we did successfully on the test...

  • RE: DDL log

    I use service broker to write all DDL to a central repository. It works well but was kind of difficult to get going at first.

  • RE: Sending Event Notification service broker messages to remote server

    Matthew Bates (9/2/2009)


    Ben,

    I'd be interested to see any scripts you might have. I'm trying to centralize event collection for a number of servers as well.

    Thanks!

    Do you have service broker...

  • RE: SSRS 2008 SP1 Will not use available memory and hits pagefile

    I don't think it's even using the pagefile. It's creating very large >1GB files in C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\RSTempFiles as soon as it hits the 800MB memory mark....

  • RE: Out of Memory in SSRS 2008

    I was getting out of memory errors even though there is 3.5GB of memory free on the server. After I applied SP1, the errors went away but now the...

  • RE: Sending Event Notification service broker messages to remote server

    Do you have anything working?

  • RE: Sending Event Notification service broker messages to remote server

    I'll put something together for you.

  • RE: Sending Event Notification service broker messages to remote server

    I figured it out. If any one needs to do this, I can post some scripts. This is really a great way to capture events to a single...

  • RE: SQL Agent can't run SSIS Package

    mashadaG (10/3/2008)


    Hi

    I am having the same problem, not sure what I am doing wrong

    Here is my error output, hope somebody can make heads and tails of? My package is trying...

  • RE: Security

    Lee From Bangalore (5/13/2009)


    Hi Roy,

    Thanks for reply,

    All the users are in os administrator's group, if I remove sysadmin role to BUILTIN\Administrators group all the users will loss the

    Sysadmin role...

  • RE: Security

    Lee From Bangalore (5/10/2009)


    Hi RoY,

    With out removing the 'Sysadmin' role for BUILTIN\Administatrors' group

    Can I Create Group in Local system and assign the users and gave the permissions to the group...

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Simple enough reason. Thanks.

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Jeff Moden (5/6/2009)


    [font="Courier New"]  USE AdventureWorks

    ;WITH cteNames AS

    (

     SELECT FirstName + ' ' + LastName AS FullName

       FROM AdventureWorks.Person.Contact

      WHERE FirstName + ' ' + LastName LIKE '%[^- .''A-Z]%'

    )

     SELECT n.FullName,

            SUBSTRING(n.FullName,t.N,1) AS BadChar,

            t.n AS BadCharPosition,

            ASCII(SUBSTRING(n.FullName,t.N,1)) AS BadCharNum

       FROM cteNames n

      CROSS JOIN Util.dbo.Tally t

      WHERE t.N <= LEN(n.FullName)

        AND SUBSTRING(n.FullName,t.N,1) LIKE '[^- .''A-Z]'[/font]

    I was playing around with this and can't figure out why the "-" in the where clause has to come before all the...

Viewing 15 posts - 46 through 60 (of 88 total)