Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 5,678 total)

  • RE: Looping a select statement to return one table

    Chrissy321 (3/29/2011)

    Actually the late, middle and early sample data was not from the original poster. I was just trying to use my intuitive powers to provide some code that might...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 5:44 pm

    #1305209

  • RE: Query to show not canceled bills

    jhors_g (3/29/2011)

    Ok, thank you very much for your answer, you're right.

    well, I have 3 tables in sql, a bill called, detallefactura and abonofactura, what I do is this to show...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 5:01 pm

    #1305204

  • RE: How to query for number of contiguous historic days where widget count = 0

    This isn't the *prettiest* code, but it functions. I modified the source data to include two clientID's to prepare the code for that. Interesting challenge. I'm hoping...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 4:50 pm

    #1305200

  • RE: Looping a select statement to return one table

    It helps. Can I ask a question? Why a table valued function? How specifically are you planning on using this data?

    The query you want (as a proc)...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 4:17 pm

    #1305193

  • RE: Query to show not canceled bills

    jhors_g (3/29/2011)

    Good afternoon

    please necito query a guide, I am developing an application portfolio, my intension is that the bills that are being paid by a client such invoice is not...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 3:23 pm

    #1305166

  • RE: Greetings from a new (future) SQL DBA.

    First: Welcome.

    steven.hulse (3/29/2011)

    I’ve played a little with the free versions of SQL Server but nothing of any depth. I’m somewhat familiar with the lingo used and know a little SQL....

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 3:04 pm

    #1305158

  • RE: Poor database design

    KevinGurney (3/29/2011)

    Also, there may be a little bit of back-end tweaking that can be done, whilst using views to present the same logical output to the application. Not knowing the...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 2:51 pm

    #1305154

  • RE: Tell Me What I Need To Know

    jcrawf02 (3/29/2011)

    If you don't know what your boss needs to know, that implies that you don't know what is important in your own job, and would be First Fail candidate....

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 29, 2011 at 11:37 am

    #1305052

  • RE: Restore failed for Server

    <EDIT SNIP TRIM WHACK HACK... I'm not sure it was 2k'able anyway...>

    EDIT: Annnnddd, this thing's over a month old. Sorry for helping with the Necro here.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 28, 2011 at 5:46 pm

    #1304627

  • RE: Temp DB

    Raghavender (3/28/2011)

    and one more question:

    For eg: if we have 5 cpus in our server, suggested tempdb files will be 5, is it minimum or maximum ?

    Neither, it's a starting point....

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 28, 2011 at 2:50 pm

    #1304591

  • RE: Temp DB

    Raghavender (3/28/2011)

    In between, this is other question on TempDB only:

    If we add multiple datafiles to tempdb database we need to keep all datafiles of same size.

    Can any body tell me...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 28, 2011 at 1:50 pm

    #1304557

  • RE: Temp DB

    Brandie Tarvin (3/28/2011)

    [Jim].[dba].[Murphy] (3/27/2011)

    Also, even though tempdb is recreated each time SQL Server starts, unlike a brand new user database, the new tempdb file settings, including it's size is...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 28, 2011 at 12:46 pm

    #1304523

  • RE: Are the posted questions getting worse?

    GSquared (3/28/2011)

    Stefan Krzywicki (3/26/2011)

    Jeff Moden (3/26/2011)

    Gianluca Sartori (3/25/2011)

    GilaMonster (3/25/2011)

    Koen Verbeeck (3/25/2011)

    Maybe a blog post that Microsoft has purchased MySQL from Oracle and that it is integrating it with SQLServer.\

    I like...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 28, 2011 at 6:26 am

    #1304310

  • RE: T-SQL problem. Is it possible to get the result that I am looking for?

    Jeff Moden (3/27/2011)

    Craig Farrell (3/27/2011)

    Look into the OUTPUT clause...

    Isn't this an SQL Server 2000 post? 🙂

    Daaammmiiittt... you're right, Jeff... and I pointed that out in the first place! D'oh.

    OUTPUT...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 27, 2011 at 8:20 pm

    #1304146

  • RE: T-SQL problem. Is it possible to get the result that I am looking for?

    hmbtx (3/27/2011)

    Craig:

    Thanks. The script worked just fine.

    Am I correct that your original script that listed the counts in error cannot also correct the count?

    Put another way, is there a way...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    March 27, 2011 at 2:45 pm

    #1304123

Viewing 15 posts - 3,541 through 3,555 (of 5,678 total)