Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,129 total)

  • RE: A faster DBCC CHECKDB?

    Paul Randal (6/18/2014)

    Not unless you say WITH TABLOCK.

    Hmmm......one last question....all my data files are sitting on same drive....i know DBCC very high intensive.....i was thinking to let DBCC run in...

    June 18, 2014 at 11:48 am

    #1722921

  • RE: A faster DBCC CHECKDB?

    Paul Randal (6/18/2014)

    No - running DBCC CHECKDB on any copy of the database that is maintained by SAN replication, log shipping, mirroring, etc is not good enough. That tells you...

    June 18, 2014 at 11:13 am

    #1722907

  • RE: A faster DBCC CHECKDB?

    Paul Randal (8/22/2011)

    Nice - but really only the equivalent of BACKUP DATABASE ... WITH CHECKSUM.

    I would strongly advise not using this for the same reasons I strongly advise not using...

    June 18, 2014 at 10:43 am

    #1722879

  • RE: Comparing Different Data Types

    Ed Pollack (5/18/2014)

    Comments posted to this topic are about the item <A HREF="/articles/Data+Types/109214/">Comparing Different Data Types</A>

    Is there any benefit using CAST Vs Convert to explicitly convert the data types ,...

    May 21, 2014 at 9:47 am

    #1715423

  • RE: SQL Server 2012 AlwaysOn Groups and FCIs Part 4

    thank you for the wonderful post. I do have few questions:

    i) I was able to set AG with partial clustering ( no quorum ,shared resources), can i still set up...

    May 20, 2014 at 2:06 pm

    #1715133

  • RE: Why does my query use MAXDOP = 0?

    ChrisM@Work (3/11/2014)

    curious_sqldba (3/11/2014)

    ChrisM@Work (3/11/2014)

    curious_sqldba (3/11/2014)

    sqlbuddy123 (3/10/2014)

    MAXDOP =1 means disabling the parallelism. That's why SQL Server doesn't consider parallelizing the query.

    That's why I couldn't see that in the execution plan you...

    March 11, 2014 at 9:15 am

    #1696032

  • RE: Why does my query use MAXDOP = 0?

    ChrisM@Work (3/11/2014)

    curious_sqldba (3/11/2014)

    sqlbuddy123 (3/10/2014)

    MAXDOP =1 means disabling the parallelism. That's why SQL Server doesn't consider parallelizing the query.

    That's why I couldn't see that in the execution plan you posted.

    --

    SQLBuddy

    Exactly, but...

    March 11, 2014 at 8:36 am

    #1696011

  • RE: Why does my query use MAXDOP = 0?

    sqlbuddy123 (3/11/2014)

    curious_sqldba (3/11/2014)

    Exactly, but my plan is using MAXDOP =0 ( 24 cores) in my case. Did you notice this?

    Where did you find that ? I don't see any Parallelism...

    March 11, 2014 at 8:28 am

    #1696007

  • RE: Why does my query use MAXDOP = 0?

    ChrisM@Work (3/11/2014)

    curious_sqldba (3/11/2014)

    sqlbuddy123 (3/10/2014)

    MAXDOP =1 means disabling the parallelism. That's why SQL Server doesn't consider parallelizing the query.

    That's why I couldn't see that in the execution plan you posted.

    --

    SQLBuddy

    Exactly, but...

    March 11, 2014 at 8:27 am

    #1696006

  • RE: Why does my query use MAXDOP = 0?

    sqlbuddy123 (3/10/2014)

    MAXDOP =1 means disabling the parallelism. That's why SQL Server doesn't consider parallelizing the query.

    That's why I couldn't see that in the execution plan you posted.

    --

    SQLBuddy

    Exactly, but my plan...

    March 11, 2014 at 7:45 am

    #1695980

  • RE: Why does my query use MAXDOP = 0?

    curious_sqldba (3/7/2014)

    sqlbuddy123 (3/7/2014)

    curious_sqldba (3/7/2014)

    I don't have any query hints being used, at server level i have MAXDOP = 5 and CTP = 1, in the exec plan i see that...

    March 10, 2014 at 2:54 pm

    #1695766

  • RE: Why does my query use MAXDOP = 0?

    sqlbuddy123 (3/7/2014)

    curious_sqldba (3/7/2014)

    I don't have any query hints being used, at server level i have MAXDOP = 5 and CTP = 1, in the exec plan i see that query...

    March 7, 2014 at 3:34 pm

    #1695270

  • RE: replace () not working on nvarchar(max) column

    Sean Lange (3/4/2014)

    curious_sqldba (3/4/2014)

    Sean Lange (3/4/2014)

    curious_sqldba (3/4/2014)

    Sean Lange (3/4/2014)

    curious_sqldba (3/4/2014)

    Jack Corbett (3/4/2014)

    Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR...

    March 4, 2014 at 12:58 pm

    #1694052

  • RE: replace () not working on nvarchar(max) column

    Sean Lange (3/4/2014)

    curious_sqldba (3/4/2014)

    Sean Lange (3/4/2014)

    curious_sqldba (3/4/2014)

    Jack Corbett (3/4/2014)

    Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR function in the...

    March 4, 2014 at 12:39 pm

    #1694039

  • RE: replace () not working on nvarchar(max) column

    Sean Lange (3/4/2014)

    curious_sqldba (3/4/2014)

    Jack Corbett (3/4/2014)

    Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR function in the REPLACE, like this:

    DECLARE...

    March 4, 2014 at 12:23 pm

    #1694028

Viewing 15 posts - 271 through 285 (of 1,129 total)