Forum Replies Created

Viewing 15 posts - 136 through 150 (of 213 total)

  • RE: Clustered Index Internals

    "Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives." :w00t:

    Are you serious? What if I only have one disk (physical or logical (like...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    December 9, 2009 at 2:49 am

    #1089698

  • RE: Indexed View

    Ray Laubert (12/8/2009)

    Thanks, that is what I would have expected. CharIndex would create a situation that invalidates the Index View and basically forces SQL to the underlying tables.

    But...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    December 9, 2009 at 1:46 am

    #1089681

  • RE: Indexed View

    vk-kirov (12/8/2009)

    mohd.nizamuddin (12/8/2009)

    However, in the example the functions Count(*), SUM, MAX, MIN etc are not a deterministic function.

    This is incorrect. Check BOL (Deterministic and Nondeterministic Functions): http://msdn.microsoft.com/en-us/library/ms178091.aspx

    All of the aggregate...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    December 8, 2009 at 5:39 am

    #1089129

  • RE: T-SQL

    Please give bitbucket and Lynn a break! It is hard to write questions to QoT and I have never and never will write a QoT due to all the preasure...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    November 18, 2009 at 12:34 am

    #1080715

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    I actually answered true, and here is why, if you run this:

    select getdate(), getutcdate()

    you may get a result like this:

    2009-11-17 06:16:57.527 2009-11-17 13:16:57.527

    They appear different, but are actually...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    November 17, 2009 at 6:46 am

    #1080196

  • RE: T-SQL

    rene-500237 (11/17/2009)

    If the UTC time is marked as UTC then I would say TRUE otherwise FALSE.

    I agree, everyone does not live in GMT zone or install our OS with GMT...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    November 17, 2009 at 1:08 am

    #1080075

  • RE: How to Identify the user who runs high usage queries and Kill the process

    ebenraja (10/29/2009)

    Hello friends,

    I do have a 'SQL user' who runs a lot of queries that causes performance issues to the database machine. I want to write a query that would...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    October 30, 2009 at 7:30 am

    #1073110

  • RE: How to Identify the user who runs high usage queries and Kill the process

    jcrawf02 (10/29/2009)

    I can just see me being the only one on in the middle of the night, running 'SELECT TOP 10 employee FROM staff' and wondering why it keeps failing...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    October 30, 2009 at 7:25 am

    #1073105

  • RE: Varchar or Char?

    Fatal Exception Error (10/16/2009)

    I based my answer on reality. In reality data is not immutable. What is true today probably won't be true six months down the...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    October 16, 2009 at 6:52 am

    #1066841

  • RE: Varchar or Char?

    Hugo Kornelis (10/16/2009)

    That's reallly a shame, as the only good reasons to use varchar instead of char are a difference of more than 2 between average and maximum length; or...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    October 16, 2009 at 5:02 am

    #1066807

  • RE: Varchar or Char?

    diamondgm (10/16/2009)

    Firstly, we assume that the average is the result of an even spread (that the average length is in fact 8.5 - we only need an average of 8...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    October 16, 2009 at 1:28 am

    #1066714

  • RE: Linked server from 64-bit SQL 2008 to Sybase

    Thank you!! This solved my issue and you saved us a lot of money.

    Harold Joubert (9/27/2009)

    I have a 64-bit Windows 2003 server with SQL 2005 Standard (64 bit). trying to...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    October 13, 2009 at 5:39 am

    #1065136

  • RE: Indexes

    As you all pointed out Bool does not exist in SQL Server, and I replaced it with a char(1). In my environment (SQL server 2008 on a server with 4...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    September 22, 2009 at 1:18 am

    #1056582

  • RE: Reclaiming freed space

    The answer option with a clustered index included dropping of same because it had to be assumed that the schema should remain unchanged. In an idea world, a table with...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 26, 2009 at 7:04 am

    #1044813

  • RE: Question of the Day for 30 Dec 2004

    I got 3.4 in SQL server 2008, but I expected to get 3.399999

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 18, 2009 at 11:00 am

    #1041019

Viewing 15 posts - 136 through 150 (of 213 total)