Forum Replies Created

Viewing 15 posts - 61 through 75 (of 381 total)

  • RE: Mirroring and SQL Agent Jobs

    Gazareth (2/6/2012)

    Erm, guesses, but are you referencing tables by 4-part names? Or the jobs not targeted at the local server?

    Jobs aren't mirrored as they're stored in the msdb database...

    February 6, 2012 at 10:41 am

    #1443317

  • RE: Error when executing procedures in linked server.

    Gianluca Sartori (1/26/2012)

    Did you try:

    EXECUTE database.schema.procedurename AT linkedservername

    Doe this work?

    I believe that you are required to use the fully qualified name when calling a linked server.

    EXEC [linkedserver].[database].[schema].[object]

    So in your case

    EXEC...

    January 26, 2012 at 7:11 am

    #1438758

  • RE: reducing DB size

    Steve,

    Would this be an option for SHARD? I know the database doesn't support it, but I have seen some stuff on CodePlex for .NET and the process.

    Thoughts?

    Fraggle

    January 25, 2012 at 2:56 pm

    #1438474

  • RE: Error when executing procedures in linked server.

    Gianluca Sartori (1/25/2012)

    EXEC master.dbo.sp_serveroption @server=N'LINKEDSERVERNAMEGOESHERE', @optname=N'rpc', @optvalue=N'true'

    GO

    EXEC master.dbo.sp_serveroption @server=N'LINKEDSERVERNAMEGOESHERE', @optname=N'rpc out', @optvalue=N'true'

    GO

    Hope this does the trick.

    Gianluca

    This is the code for creating the linked server. I...

    January 25, 2012 at 2:55 pm

    #1438473

  • RE: Canadian Postal Code and US Zip

    Before even looking at this, from the sounds of it, you are running this against a table of values, not a single value. Is this correct? If so,...

    January 25, 2012 at 10:04 am

    #1438300

  • RE: Error when executing procedures in linked server.

    Can you provide a code same. Specifically how you are trying to call the stored procedure?

    Thanks,

    Fraggle

    January 25, 2012 at 10:01 am

    #1438296

  • RE: reducing DB size

    Three things here.

    1) Both of the guys above make valid points.

    2) Shrinking database can cause performance issues, so be aware of that.

    3) To find the tables taking up...

    January 25, 2012 at 9:55 am

    #1438293

  • RE: TempDB Log Growth Help

    padhis (1/22/2012)

    analyze which Transact-SQL statements are the top consumers of tempdb

    SELECT t1.session_id, t1.request_id, t1.task_alloc,

    t1.task_dealloc, t2.sql_handle, t2.statement_start_offset,

    t2.statement_end_offset, t2.plan_handle

    FROM (Select session_id, request_id,

    SUM(internal_objects_alloc_page_count) AS...

    January 22, 2012 at 12:50 pm

    #1436913

  • RE: TempDB Log Growth Help

    GilaMonster (1/22/2012)

    What's the value of log_reuse_wait_desc for tempDB?

    NOTHING is what it is set to. So pretty much a completely useless description.

    Fraggle

    January 22, 2012 at 12:47 pm

    #1436911

  • RE: Is there a more efficient alternative to WHILE LOOPS and CURSORS

    I won't say this is correct simply b/c we don't have any data to test and I am not sure I 100% understand what you are trying to do. ...

    January 18, 2012 at 2:56 pm

    #1435552

  • RE: Count Function

    jennigirl (1/18/2012)

    I was able to get the query results I need, but I am looking to now present the results as the total count of trouble tickets assigned to each...

    January 18, 2012 at 8:13 am

    #1435278

  • RE: Stored Procedures usage in SQL Server 2000 version

    I would try using server side profiler that will write to a flat file. Once done, you can aggregate the data from the file how ever you want.

    Fraggle

    January 17, 2012 at 3:47 pm

    #1434914

  • RE: Nested Set Optimization Fun and Sunshine

    Well since I am still waiting on QA and didn't want anyone to wait much longer (ok, so before I forgot), I figured I would post what I have.

    If anyone...

    January 17, 2012 at 8:05 am

    #1434625

  • RE: Nested Set Optimization Fun and Sunshine

    CELKO (1/4/2012)

    Fraggle-805517 (12/29/2011)

    Ok, so I understand the breadcrumbs now. However, I am not seeing how they will eventually get me the Left/Right node for the nested set? .

    I prefer...

    January 4, 2012 at 7:05 pm

    #1428772

  • RE: Nested Set Optimization Fun and Sunshine

    CELKO (1/4/2012)

    I have the same fear of downloads as everyone else. But in the nested sets model, the tree structure is in one table and the nodes are in another....

    January 4, 2012 at 6:31 pm

    #1428766

Viewing 15 posts - 61 through 75 (of 381 total)