Forum Replies Created

Viewing 15 posts - 47,731 through 47,745 (of 49,552 total)

  • RE: Many to Many joins,insert

    Hmmm, that too!

    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

    January 10, 2008 at 2:06 am

    #766512

  • RE: Total columns in a table

    With the varchars, the total space used on disk is 2 + number of characters in the field.

    so a varchar(200) that has in it 'abc' only takes 5 bytes to...

    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

    January 10, 2008 at 12:20 am

    #766493

  • RE: User Defined Data Types

    You'll have to write a trigger for each table.

    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

    January 10, 2008 at 12:04 am

    #766492

  • RE: Many to Many joins,insert

    miltiadis (1/9/2008)

    Thank you all guys especially SSCrazy

    i think my database schema is good now and i am over exaggerating thinks in order to learn 🙂

    Pleasure.

    p.s. SSCrazy is a title, not...

    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

    January 9, 2008 at 11:52 pm

    #766490

  • RE: SQL NOOB IN NEED OF HELP!!!!

    Is this related to the original question? If so, then none. Stats aren't going to help when stuff is missing from a table (which was the original problem)

    If not (and...

    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

    January 9, 2008 at 11:48 pm

    #766487

  • RE: DB OWNER Role member and DROP DATABASE

    It's not a new thing in SQL 2005. From SQL 2000 BoL:

    DROP DATABASE permissions default to the database owner, members of the sysadmin and dbcreator fixed server roles, and are...

    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

    January 9, 2008 at 11:42 pm

    #766485

  • RE: SQL SERVER 2008

    Download Virtual PC from microsoft. It's free. You can then download the virtual drives that Grant linked to and you can have 2008 running in a virtual machine with no...

    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

    January 9, 2008 at 11:23 pm

    #766481

  • RE: Joining Tables in SQL Server Express

    It think you're wanting something like this?

    SELECT substring (TAG , 10,30) as 'ALARM NAME', VALUE as '1=ON',

    CONVERT(CHAR(27),(TIME),109) as 'DATE & TIME'

    FROM dbo.UNIT_1_EMPTY_TABLE

    UNION ALL

    SELECT substring (TAG , 10,30) as...

    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

    January 9, 2008 at 11:22 pm

    #766480

  • RE: Joining Tables in SQL Server Express

    You could install management studio express on each of the machines. If you have a machine with IIs installed, you could use reporting services. That way the clients access 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

    January 9, 2008 at 1:32 pm

    #766389

  • RE: Concurrency and locking

    Do your select with an update lock and with rowlock. Add a TOP 1 to the select. Try adding an index on JobStatus, JobID if there isn't one already

    Also...

    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

    January 9, 2008 at 1:00 pm

    #766379

  • RE: SQL2000 Corrupt table and point in time recovery question.

    Unless it was a log record that was corrupt, you should be able to roll all the logs forward, right up to the last. If you backed up the tail...

    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

    January 9, 2008 at 12:55 pm

    #766374

  • RE: Modify sys.sp_columns system stored procedure

    Also note that the system procs aren't actually in the user databases, though they appear to be. They're in the hidden resource database.

    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

    January 9, 2008 at 8:42 am

    #766252

  • RE: Truncate all Transaction Logs on the server

    Everyone else covered the how, so I'll cover they why.

    Be aware that by doing this you are breaking the log chain and preventing yourself from being able to do restores...

    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

    January 9, 2008 at 8:41 am

    #766250

  • RE: SQL SERVER 2008

    Ouch. I always use VPCs for this kinda thing. Reinstalling takes far too long.

    Got katmai running in a VPC on my laptop. Runs supprisingly well, though I haven't tried to...

    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

    January 9, 2008 at 7:10 am

    #766162

  • RE: changes objects ?

    Easiest thing is just search and replace before you save the script

    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

    January 9, 2008 at 6:15 am

    #766120

Viewing 15 posts - 47,731 through 47,745 (of 49,552 total)