Forum Replies Created

Viewing 15 posts - 45,691 through 45,705 (of 49,552 total)

  • RE: String compare: 'a' = 'a' ==>True or False?

    SQL ignores trailing spaces when comparing strings. It's probably because of the char data type, which is space padded to max size

    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 15, 2008 at 5:04 am

    #842938

  • RE: After creating DB | Need to set the DB as db_owner

    The proc doesn't assign rights to the DB. It just makes it the login's default database. You'll have to grant any rights you want the login to have.

    After running that,...

    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 15, 2008 at 5:02 am

    #842936

  • RE: Deadlocks

    David Griffiths (7/15/2008)

    I understand that covering indexes will often give performance benefits. However, I didn't understand that they were a requirement to prevent deadlocks until I discovered this behaviour for...

    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 15, 2008 at 4:57 am

    #842933

  • RE: After creating DB | Need to set the DB as db_owner

    EXEC sp_defaultdb <Login Name>, <Database Name>

    Run it after both the login and the database exist

    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 15, 2008 at 4:40 am

    #842927

  • RE: Error: 18456, Severity: 14, State: 16

    When a database is set to autoclose, it is shut down when the last user disconnects. That's what's causing the cache flush. SQL's removing anything related to that DB from...

    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 15, 2008 at 4:36 am

    #842924

  • RE: Monthly SQL Crashes

    Stu (7/15/2008)

    although it still comes up with "A significant part of sql server process memory has been paged out" in the error log, but I'm just going to ignore this...

    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 15, 2008 at 4:30 am

    #842922

  • RE: Monthly SQL Crashes

    onlo (7/15/2008)

    What is "CU4" ?

    Cumulative update 4. Big collection of hotfixes since SP2. Currently the latest is cumulative update 8 (CU8)

    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 15, 2008 at 4:27 am

    #842920

  • RE: Pointing multiple SQL Servers at a single MDF (on a SAN) with Read Only access

    Not possible in SQL 2000. SQL requires exclusive access to its data files

    In SQL 2005, if all the databases are readonly (all of them) it's possible to do, though it's...

    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 15, 2008 at 1:44 am

    #842864

  • RE: File Encryption

    Could it be permissions?

    When you run it at the command prompt, you're running under your security credential. When you run it through xp_cmdshell, you're running it under the SQL Server...

    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 15, 2008 at 1:39 am

    #842861

  • RE: DBCC command turning up repeatedly in Profiler

    Shouldn't do.

    What user and application are you seeing those statements from? What SPID?

    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 15, 2008 at 1:35 am

    #842860

  • RE: I cannot select distinct when I inner join to other tables.

    NText works just fine in SQL 2005 (although it is deprecated).

    The blob datatypes (text, ntext, image) cannot be directly compared (including by a distinct) in any version of SQL that...

    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 15, 2008 at 1:33 am

    #842858

  • RE: change nonclustered index to clustered index in sql server 2000 database table

    kiran (7/14/2008)

    I have posted in different forum

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

    Replies to th following thread please

    http://www.sqlservercentral.com/Forums/Topic533714-145-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 15, 2008 at 1:28 am

    #842855

  • RE: alter non-clustered index on primary key

    It's an index enforcing the primary key. To drop it, you will have to use ALTER TABLE ... DROP CONSTRAINT rather than DROP INDEX

    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 15, 2008 at 1:27 am

    #842854

  • RE: clustered index and pK

    They are unrelated terms.

    A primary key is the identifier of the row. It must be unique, it must have no nulls and it's used to enforce the entity integrity of...

    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 15, 2008 at 1:24 am

    #842851

  • RE: query

    Run profiler against your system for a while (an hour or so) and then examine the saved trace to identify the queries with the highest duration, reads and CPU.

    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 15, 2008 at 1:19 am

    #842849

Viewing 15 posts - 45,691 through 45,705 (of 49,552 total)