Forum Replies Created

Viewing 15 posts - 5,446 through 5,460 (of 9,715 total)

  • RE: SQL timeouts and disconnects?

    Run PerfMon and a server-side sql trace. You might also check the default trace, see if it has enough back log to show you what was going on the last...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 28, 2011 at 5:42 am

    #1359955

  • RE: Are the posted questions getting worse?

    GilaMonster (7/28/2011)

    Brandie Tarvin (7/28/2011)

    So, are there any pastries or donuts at the water cooler today? I am in desperate need of sugar.

    I have hot cross buns. And I'm not sharing.

    Grrrrrrr!

    😛

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 28, 2011 at 5:17 am

    #1359942

  • RE: Query is not summarizing results

    I'm seeing two things. 1) In your result set, you refer to customer 9181, who doesn't exist in the test data. I'm assuming you meant 9151 and this is just...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 28, 2011 at 5:13 am

    #1359939

  • RE: Query is not summarizing results

    Eugene Elutin (7/28/2011)

    1. If you re using SSRS to produce report, grouping can be done in SSRD itself

    FYI: I agree with the above statement. In fact, in SSRS, you can...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 28, 2011 at 5:00 am

    #1359934

  • RE: Query is not summarizing results

    I'm taking a look at this now.

    Just an FYI: Your DROP TABLE script will error out for those of us who don't have your table in our dbs. If you...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 28, 2011 at 4:57 am

    #1359931

  • RE: Are the posted questions getting worse?

    WhineWhine, RantRant, ComplainComplain.

    Why does morning have to come so early? Can't it wait until I wake up for real?

    [/rant]

    So, are there any pastries or donuts at the water cooler today?...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 28, 2011 at 4:48 am

    #1359928

  • RE: Except vs. Left Join vs. Not Exists

    Paul,

    Thank you for that post. It was very informative.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 28, 2011 at 4:39 am

    #1359922

  • RE: Convert() Functionality -> MS webpage error?

    Ah. Thank you for pointing that out.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 12:07 pm

    #1359581

  • RE: sys.objects$ (with a Dollar sign)

    I don't see either view or table called sys.objects$ (just did the Resource user db on my local dev copy).

    Lowell, make sure to rename the db before you try...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 11:55 am

    #1359570

  • RE: sys.objects$ (with a Dollar sign)

    Lowell (7/27/2011)

    so is that the super secret resource database? how can i select from it, if i reeeallly wanted to?

    Bad Lowell. We're not supposed to be selecting from Microsoft's secret...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 11:32 am

    #1359542

  • RE: Today's Random Word!

    ...but I still love you guys. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 11:10 am

    #1359518

  • RE: Today's Random Word!

    Spam.

    This thread and The Thread are killing my inbox!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 11:10 am

    #1359516

  • RE: sp_send_dbmail

    An ANSI character set is a set of numbers that represent every letter in the alphabet and every number from 0-9. They also represent punctuation marks, spaces, tabs, line breaks,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 11:04 am

    #1359512

  • RE: Stored proc returning puzzling error - Invalid column name

    Glad we could help. And very glad it wasn't something worse.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 10:55 am

    #1359505

  • RE: select SERVERPROPERTY('COLLATION')

    chandan_jha18 (7/27/2011)

    Lowell (7/27/2011)

    based on this ms doc, where changing the server collation requires a rebuild:

    http://msdn.microsoft.com/en-us/library/ms179254.aspx,

    i'm guessing that the server collation is actually the collation of the resource database, regardless...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 27, 2011 at 7:22 am

    #1359227

Viewing 15 posts - 5,446 through 5,460 (of 9,715 total)