Forum Replies Created

Viewing 15 posts - 45,781 through 45,795 (of 49,552 total)

  • RE: How do I truncate a Dimension table with foreign keys to the Fact table?

    You can either drop the foreign keys, truncate the table and then recreate the foreign keys, or you can use DELETE FROM instead of TRUNCATE 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

    July 11, 2008 at 3:25 am

    #841320

  • RE: How do I truncate a Dimension table with foreign keys to the Fact table?

    Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.

    No replies to this thread please, direct replies to:

    http://www.sqlservercentral.com/Forums/Topic532206-147-1.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

    July 11, 2008 at 3:24 am

    #841319

  • RE: query for getting yesterday date entry

    Could you post the query that you are using?

    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

    July 11, 2008 at 1:54 am

    #841292

  • RE: query for getting yesterday date entry

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to:

    http://www.sqlservercentral.com/Forums/Topic532181-323-1.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

    July 11, 2008 at 1:51 am

    #841291

  • RE: Encrypt and Dcrypt data

    SQL 2000 has no built in encryption/decryption mechanisms.

    p.s. SQL 2000 posts should go in the SQL 2000 forums

    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

    July 11, 2008 at 12:53 am

    #841271

  • RE: Checkpoints and Performance

    John Rowan (7/10/2008)

    This sounds like a disk bottleneck to me. You've got your OS, paging file, and DB files all on one physical disk. Regarless of how you...

    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

    July 11, 2008 at 12:36 am

    #841265

  • RE: moving database to another machine

    JeeKay (7/10/2008)

    I did not say DELETE log file. What i said was to have that removed from the list of files when you attach it.

    Apologies. I misread.

    However, if 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

    July 11, 2008 at 12:32 am

    #841263

  • RE: Cluster consuming more memory

    How are you checking the memory used?

    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

    July 11, 2008 at 12:24 am

    #841260

  • RE: CU KB948109 wouldn't install

    I've noticed a large number or issues reported on this update.

    Not just failures to install, but problems with the SQL instances after the install.

    There are some interesting...

    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

    July 11, 2008 at 12:22 am

    #841258

  • RE: Select Into not getting indexes and constraints

    Select into just creates a new table matching the number and types of the columns in the select statement.

    It does not create constraints, indexes, defaults or anything else other...

    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

    July 11, 2008 at 12:19 am

    #841257

  • RE: Coming In August

    Jeff Moden (7/10/2008)

    I, too, can't wait until the split of Date and Time... leaves much opportunity to easily get to 15,000 posts in a hurry explaining to people how 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

    July 11, 2008 at 12:16 am

    #841256

  • RE: DBCC commands

    They are extremely resource intensive. You should not run them when you have users accessin the DB. If you have downtime over a weekend, run the checkdb then

    You should (imho)...

    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

    July 11, 2008 at 12:15 am

    #841255

  • RE: Coming In August

    cmille19 (7/10/2008)

    One other feature with SQL 2008, which is seldom mentioned is the new multi-server query in SSMS 2008.

    Works against 2000, 2005, and 2008 servers.

    It works to SQL...

    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

    July 11, 2008 at 12:08 am

    #841252

  • RE: Indexes & FillFactor

    PeterG (7/10/2008)

    The database grows every week so it sounds like i don't have to worry about shrinking. Auto shrink is on. Turn it off??

    Yes. That's the reason your indexes...

    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

    July 10, 2008 at 11:41 pm

    #841245

  • RE: failed login attemps as sa from multiple ips

    ltoso (7/10/2008)

    Hi,

    another question poped into my mind, if we rename the sa account will the sa account privileges be transfered for all databases to the new account the we have...

    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

    July 10, 2008 at 11:38 pm

    #841243

Viewing 15 posts - 45,781 through 45,795 (of 49,552 total)