Forum Replies Created

Viewing 15 posts - 16 through 30 (of 69 total)

  • RE: Which way is better? To join or not to join or does it matter?

    One more case when optimizer is not able to decorrelate subquery is an assert impact.

    Interesting! so what is a scenario when the optimizer compiles both a correlated subquery query and...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 26, 2012 at 10:15 am

    #1553282

  • RE: How to copy a System Stored Procedure to another server

    However, sometimes the SP's get updated on the Production Server. What I want is that those updates are copied automatically to the Report Server. Once a day, for example in...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 26, 2012 at 8:26 am

    #1553204

  • RE: Which way is better? To join or not to join or does it matter?

    looks like im off to hit the books on correlated subqueries now. then go yell at the guy i heard it from.

    +1 to that...

    Could've swore I've read in...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 26, 2012 at 3:24 am

    #1553073

  • RE: The client was unable to reuse a session with SPID 799, which had been reset for connection pooling.

    Please suggest what could be the reason for same and if there is a possibility we can fix this without restarting sql server

    Hi,

    I have experienced this in the past for...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 25, 2012 at 7:19 am

    #1552682

  • RE: Login restriction

    kk.86manu (10/25/2012)

    Thanks for your reply

    Unfortunately i am still not able to do this.Please see the details below

    Scenario:

    I have a login test_login which has role as db_datareader and db_datawriter.

    Created this stored...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 25, 2012 at 5:09 am

    #1552635

  • RE: Login restriction

    The user has permissions to execute the stored procedure.The stored procdure is having CREATE,ALTER TABLE, ALTER PARTITIONS statements in it?

    Just to clarify, these are DDL statements and not DML.

    Difference here[/url]

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 25, 2012 at 4:58 am

    #1552626

  • RE: Brent Ozar's SQL Server on VMWare Training Video or a Book?

    :blush:

    Thanks for taking the time to answer my post Brent.

    The resources you provided look very interesting. Definitely bookmarked!

    Personally I do enjoy SQL material delivered through video, in fact I tend...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 24, 2012 at 5:05 pm

    #1552475

  • RE: Search functionality issue.

    SQLCrazyCertified (10/23/2012)

    "The Search functionality in (database name/application) QA is not working correctly. Index tables are not refreshed when new activities are added into the system via the GUI, and cannot...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 23, 2012 at 2:18 pm

    #1552064

  • RE: Can a JOIN be alias?

    Luis Cazares (10/23/2012)

    There's no need to create a view. You'll end up with millions of views that you won't use.

    +1

    or even use a CTE.

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 23, 2012 at 12:19 pm

    #1552037

  • RE: Can a JOIN be alias?

    icata (10/23/2012)

    Something like this

    select join_alias.col11, join_alias.col21 from

    (table1 a INNER JOIN table2 b ON a.col11=b.col21) join_alias

    Hope it makes sense.

    Please let me know.

    Don't think it exists in a format similar to the...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 23, 2012 at 11:42 am

    #1552023

  • RE: SSRS linked server to MySQL parameter problems

    kmiles (10/21/2012)

    It returns no rows, with no errors, when passing the parameter. I tried it also without the quotes and nothing changed. I may have to do as you suggested...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 21, 2012 at 12:47 pm

    #1551180

  • RE: How do you set relations in sql for tables

    lonhanner (10/21/2012)

    I have several tables and need to set relationships. How do you do this with the sql server manager?

    Here is an article on creating foreign key relationships in SQL...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 21, 2012 at 12:36 pm

    #1551179

  • RE: Failed to lock variable "User::Server_list" for read access with error 0xC0010001

    Abu Dina (10/19/2012)

    I opened the package in NotePad++ but when I search for the variable it's not there!

    This is just typical SSIS bull$h!t.

    Hmm strange, only other thing I can think...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 19, 2012 at 8:03 am

    #1550883

  • RE: Failed to lock variable "User::Server_list" for read access with error 0xC0010001

    Abu Dina (10/19/2012)

    Yea thanks. I've been trying to view the XML but Visual Studio seems to crash. It's a large package with many components.

    I will keep trying and see what...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 19, 2012 at 7:46 am

    #1550873

  • RE: Failed to lock variable "User::Server_list" for read access with error 0xC0010001

    Maybe I'm missing something but is there a way to make SSIS display all variables used?! The package does contain a lot of components so maybe I've missed one somewhere...

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

    October 19, 2012 at 6:42 am

    #1550837

Viewing 15 posts - 16 through 30 (of 69 total)