Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,366 total)

  • RE: Strange Blocking

    TheSQLGuru (9/22/2016)

    What was the ACTUAL blocked resource? Are you absolutely certain it was blocking and not latch contention or something else?

    I like sp_whoisactive to see lots of details about such...

    September 22, 2016 at 2:47 am

    #1902372

  • RE: Clustered Index Scan or Index Seek + Key Lookup

    GilaMonster (8/28/2016)

    Depends on the table size and number of rows needing a lookup. Test for your data set and see which works better for you.

    Thanks Gail.

    For large data scan is...

    August 28, 2016 at 2:42 am

    #1897978

  • RE: sort_in_tempdb

    GilaMonster (8/24/2016)

    Depends whether you want the index creation to use TempDB for sorting or not.

    That option isn't persisted anywhere, it's effective only for the create/alter that it's specified on and...

    August 25, 2016 at 1:16 am

    #1897394

  • RE: msdb.dbo.suspect_pages

    ElSuket (8/18/2016)

    Hi,

    The documentation reads :

    Contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are...

    August 18, 2016 at 6:50 am

    #1896135

  • RE: Cannot connect from passive node to SQL Server Cluster

    Allow the TCP Port 1433 and UDP Port 1434 and you will be able to connect.Make sure SQL browser is running.

    Exactly this. Thanks!

    Glad to hear its working for you...

    August 18, 2016 at 2:18 am

    #1896086

  • RE: msdb.dbo.suspect_pages

    Experts please help on this

    August 17, 2016 at 11:45 pm

    #1896074

  • RE: Cannot connect from passive node to SQL Server Cluster

    Igor Micev (8/16/2016)

    RVarn (8/15/2016)

    Try using the IP address of the virtual instance with a comma and the port number where the server name goes in SSMS on the inactive node....

    August 16, 2016 at 4:18 am

    #1895588

  • RE: Job Execution Failed

    Sue_H (8/10/2016)

    The user needs access to at least one mail profile and needs to be a member of DatabaseMailUserRole in msdb.

    Sue

    Thanks Sue,

    As i mentioned earlier i haven given all...

    August 15, 2016 at 12:29 am

    #1895370

  • RE: Clustering SQL Agent

    shahgols (8/13/2016)

    Hi all,

    I'm a clustering newbie, have a task to set up clustering and part of the requirement is to cluster the jobs as well. So, if server...

    August 14, 2016 at 4:12 am

    #1895345

  • RE: Collation Error 468

    info.sqldbamail (8/11/2016)

    Hello All,

    I am having default Collation as Latin1_CP1_CI_AS on my server and databases but when i am trying to open a new query window it is throwing an error

    Cannot...

    August 14, 2016 at 2:53 am

    #1895344

  • RE: Query Execution Time

    GilaMonster (8/7/2016)

    The times for the individual statements within the procedure, not time to read tables.

    Thanks Gail.

    August 9, 2016 at 3:07 am

    #1894480

  • RE: Clustering Key

    Phil Parkin (8/7/2016)

    VastSQL (8/7/2016)

    Phil Parkin (8/7/2016)

    VastSQL (8/7/2016)

    Have a table with below structure

    Column_nameTypeLength

    AGENT_ID float8

    AGENT_CODEnvarchar510

    ENGnvarchar510

    we have a procedure which is the one that will be accessing this table by the column AGENT_CODE,...

    August 9, 2016 at 3:06 am

    #1894479

  • RE: Clustering Key

    Phil Parkin (8/7/2016)

    VastSQL (8/7/2016)

    Have a table with below structure

    Column_nameTypeLength

    AGENT_ID float8

    AGENT_CODEnvarchar510

    ENGnvarchar510

    we have a procedure which is the one that will be accessing this table by the column AGENT_CODE, the table is...

    August 7, 2016 at 7:10 am

    #1894216

  • RE: Query Execution Time

    GilaMonster (8/7/2016)

    VastSQL (8/7/2016)

    SQL Server Execution Times:

    CPU time = 15 ms, elapsed time = 76 ms.

    That's the total time for the procedure.

    Thanks Gail ,and rest shown...

    August 7, 2016 at 6:01 am

    #1894214

  • RE: Quickest way to move jobs

    You can script out all jobs at once by listing the jobs in object explorer details-->select all jobs--> right click -->script jobs

    August 7, 2016 at 12:29 am

    #1894209

Viewing 15 posts - 271 through 285 (of 1,366 total)