Forum Replies Created

Viewing 15 posts - 1 through 15 (of 859 total)

  • RE: No Compelling Reason

    For my company it is cost. Sinking 7k a core for enterprise means its a long term expense that will be there for 4-5 years at least. We...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    September 18, 2014 at 9:54 pm

    #1746583

  • RE: Interesting DBCC CHECKDB Error - found 1 allocation errors and 0 consistency errors not associated with any single object.

    GilaMonster (10/17/2013)

    CapnHector (10/16/2013)

    EDIT: After looking at it some more it really looks like this IAM page is not tracking any allocated space since there are no single page allocations...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    October 18, 2013 at 1:33 pm

    #1659851

  • RE: Interesting DBCC CHECKDB Error - found 1 allocation errors and 0 consistency errors not associated with any single object.

    GilaMonster (10/17/2013)

    CapnHector (10/16/2013)

    What is perplexing me on the error message is that object ID 0 and index ID -1 make no sense as the objects do not exist (unless they...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    October 17, 2013 at 9:17 am

    #1659378

  • RE: Attachment file is invalid - db mail

    Not sure it matters but i noticed the following mismatch, NVARCHAR(MAX) for images and VARCHAR(12) for current_image

    declare @images nvarchar(max)

    set @images = ''''

    declare @current_image varchar(12)

    The other issue i see is...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    October 17, 2013 at 9:09 am

    #1659372

  • RE: Interesting DBCC CHECKDB Error - found 1 allocation errors and 0 consistency errors not associated with any single object.

    Well after much research and digging deeper into the storage internals than I ever have before, I am reasonably sure this IAM page does not track any data pages which...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    October 17, 2013 at 9:03 am

    #1659368

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/20/2013)

    hisakimatama (9/20/2013)

    *Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    September 20, 2013 at 1:40 pm

    #1652036

  • RE: Do not log job history

    another option i have seen is that if you have a job that is run once a minute and its not triggered by any thing (DB stats logging in my...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 20, 2013 at 2:03 pm

    #1599121

  • RE: sql not finishing or stuck

    opc.three (3/19/2013)

    Some itesm that jumped out at me readnig your post.

    I have four temp dbs (100 meg and three 200 meg--which I want to set all to 100)...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 20, 2013 at 2:00 pm

    #1599119

  • RE: Stop large queries from running

    sestell1 (3/18/2013)

    akberali67 (3/18/2013)

    Hi,

    I have a query window with a lot of code but I do not want to run it entirely in error, is there something I can place in...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 18, 2013 at 2:21 pm

    #1598165

  • RE: Big table

    not sure if it would increase the performance or not but another option is a filtered index (possibly one for each year?). Would deffiniatly need to test in DEV...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 14, 2013 at 1:29 pm

    #1597227

  • RE: Grant persmissions to database

    sqlfriends (3/14/2013)

    For my case, do you think if I use above grant to schema permissions, it is better to create a customized role first?

    Thanks

    My preferred method is to use Roles...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 14, 2013 at 1:17 pm

    #1597220

  • RE: Grant persmissions to database

    sqlfriends (3/14/2013)

    Chris Harshman (3/13/2013)

    sqlfriends (3/13/2013)

    ...They may need to read and write and also execute stored procedures in the databases...

    Typically when it comes to security you want to grant the least...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 14, 2013 at 11:35 am

    #1597174

  • RE: Daylight saving time and SQL agent job

    dan-572483 (3/12/2013)

    sqlfriends (3/12/2013)

    dan-572483 (3/12/2013)

    Good general rule: Jobs that need to run once but NOT more than once should not be scheduled between 1 & 3am on Sunday mornings.

    But I don't...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 14, 2013 at 11:16 am

    #1597164

  • RE: Does the adrenaline rush ever subside when rebooting a DB server.

    Jeff Moden (2/27/2013)

    CapnHector (2/27/2013)

    I work in a small shop as the accidental DBA and for the first time rebooted our production DB server after applying CU 9 to fix some...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 4, 2013 at 3:07 pm

    #1593189

  • RE: delete a large amount of rows in a table

    insanityflyff (2/27/2013)

    CapnHector (2/27/2013)

    Since you have multiple tables using the same exclusion data set i would create a work table with that data set and index it, then use a LEFT...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 27, 2013 at 3:46 pm

    #1591781

Viewing 15 posts - 1 through 15 (of 859 total)