Forum Replies Created

Viewing 15 posts - 826 through 840 (of 5,678 total)

  • RE: Create SSIS packages in VS 2010 for SQL Server 2008 R2

    Basically, as said above, you don't. You use VS 2k8 for SQL 2k8 and 2k5 for 2k5. 2010 is for SQL 2012.

    - 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

    February 12, 2013 at 2:01 pm

    #1587190

  • RE: Display two fields of two UNRELATED tables WITHOUT crossjoin

    dgowrij (2/5/2013)

    Hi Lynn,

    Just to understand, Could you please explain how the query works? Especially the part

    (SELECT 1) dt1(n)

    CROSS APPLY (SELECT COUNT(*) FROM dbo.Customers) dt2(q1)

    ...

    - 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

    February 5, 2013 at 5:45 pm

    #1584682

  • RE: CXPacket and PAGEIOLATCH_EX or SH

    I have seen heavy maxdop interfere with writes and I/O, but it would have to be an extreme case for me to look towards that as a culprit. If...

    - 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

    February 5, 2013 at 5:14 pm

    #1584676

  • RE: Performance Issue - understanding query plans

    nick.mcdermaid (2/5/2013)

    OK, I have reposted an unsanitised query, the sqlplan file, the DDL, and a picture of part of the query plan.

    The .sqlplan you posted is the estimated plan, 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

    February 5, 2013 at 5:07 pm

    #1584672

  • RE: How have Trigger's example after insert send to mail on outlook?.

    Lowell (2/1/2013)

    Craig I think that was true with SQL2000, and the old SQL Mail, but the 2005 and above database mail via msdb.dbo.sp_send_dbmail is already an asynchronous service broker...

    - 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

    February 1, 2013 at 2:45 pm

    #1583598

  • RE: How have Trigger's example after insert send to mail on outlook?.

    I want to throw in a warning here. Sending emails via triggers means that if the exchange server goes down... so does your database. Also any transaction has...

    - 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

    February 1, 2013 at 1:37 pm

    #1583588

  • RE: To the experienced SQL people out there: How are you titled/how do you title yourself?

    Danah (1/30/2013)

    Titles seem to mean a lot in Australia, because employers use the average salary for a title to figure out what the market rate for a position should be....

    - 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

    January 30, 2013 at 5:37 pm

    #1582738

  • RE: Effective Date

    Can you script your schema and some sample data for product_prices?

    This seems like a typical logging table selection, but I want to make sure I understand your data layout precisely.

    Edit:...

    - 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

    January 30, 2013 at 3:27 pm

    #1582722

  • RE: Optimize a Query.

    Would need, at the least, to see the .sqlplan and the tables/indexes. Check out the second link on the left side of my signature for all the pieces that...

    - 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

    January 30, 2013 at 3:25 pm

    #1582721

  • RE: To the experienced SQL people out there: How are you titled/how do you title yourself?

    Danah (1/29/2013)

    - DBA: focusing on administration and maintenance of all SQL instances, performance, permissions, disaster recovery, capacity planning and all the usual stuff (this was my original job title 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

    January 30, 2013 at 1:47 pm

    #1582706

  • RE: Corrupted Database

    @SQLFRNDZ (1/29/2013)

    I haven't queried that and I would try querying that in an hour or so.

    Could you please tell me what about it?

    It's one of the easiest ways to get...

    - 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

    January 29, 2013 at 5:42 pm

    #1582435

  • RE: Passing a pre-set parameter to a Stored Proc

    ReamerXXVI (1/29/2013)

    How can I pass a pre-set parameter to a stored proc, for example;

    DECLARE @param1 VARCHAR(MAX)

    SET @param1 = 'value1, value2, value3'

    EXEC usp_doStuff @command1 = 'Some stuff goes here', @command2 =...

    - 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

    January 29, 2013 at 5:41 pm

    #1582434

  • RE: What Gives Better Performance?

    AndrewSQLDBA (1/29/2013)

    He was trying to convince me that char is better performing than varchar

    There is a small area where CHAR performs better storage-wise than VARCHAR because of field size settings,...

    - 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

    January 29, 2013 at 5:39 pm

    #1582433

  • RE: Heavy PAGEIOLATCH_SH wait type on Update Statistics

    Um, lot of factors. I wouldn't say the I/O subsystem is bad. All the wait means is that it's waiting for the drive to send it data. ...

    - 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

    January 29, 2013 at 4:21 pm

    #1582425

  • RE: Creating a new table" My own" using existing data???

    jbalbo (1/29/2013)

    yes keywords etcc..

    I did write a small view then created a job then creates a table from the view

    Since its a report server I can run the job...

    - 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

    January 29, 2013 at 4:20 pm

    #1582423

Viewing 15 posts - 826 through 840 (of 5,678 total)