Forum Replies Created

Viewing 15 posts - 331 through 345 (of 1,155 total)

  • RE: Database backup

    olegas.domanskis (3/5/2014)

    Process ID and trace shows

    Microsoft SQL Server VSS Writer

    And that's it.

    No idea who is initializing the backup.

    It could be a 3rd party backup. What was output...

    March 5, 2014 at 11:27 am

    #1694435

  • RE: ssrs - email subscription

    I think you can use the shared datasource for your dataset within a report and schedule it as a normal report. Are you having any issue with this ?

    --

    SQLBuddy

    March 5, 2014 at 11:18 am

    #1694431

  • RE: Get Object Name from database_id, file_id, Page_id

    EdVassie (3/5/2014)

    I have Buffer Pool Extension enabled and want to get the object name for all pages shown in sys.dm_os_buffer_descriptors.

    When a page is in the BPE and no longer in...

    March 5, 2014 at 11:10 am

    #1694429

  • RE: Restoring a database on clustered sql server

    sql_novice_2007 (3/5/2014)

    When I run the following query I got the result 0 which means AlwaysOn Avaialability groups is disabled.

    SELECT SERVERPROPERTY ('IsHadrEnabled');

    Does that mean restoring on one Node is good enough?

    Thanks.

    Yes...

    March 5, 2014 at 10:06 am

    #1694399

  • RE: Writing to Windows Event Log using TSQL

    rerichards (3/5/2014)

    So I assume that the answer to my question is: "It is not possible to write a message to the Windows Event Log using TSQL without "Error" being a...

    March 5, 2014 at 10:05 am

    #1694398

  • RE: Restoring a database on clustered sql server

    Just do it on the active node.

    --

    SQLBuddy

    March 5, 2014 at 9:50 am

    #1694388

  • RE: SQL 2012 Upgrade Advisor trace files and SQL batch files

    Try to run a trace during the busiest part of the day\season so that you could capture most of your business queries. That can help you in identifying any deprecated\discontinued...

    March 5, 2014 at 9:48 am

    #1694386

  • RE: Blades recommended for Dell chassis running SQL Server

    NJDave (9/26/2013)

    Hello - I was asked to find "what blades are recommended for Dell chassis running SQL Server"

    I don't have hardware experience and was hoping I could get some input.

    Thank...

    March 5, 2014 at 9:30 am

    #1694376

  • RE: BIDS looking for ideas.

    CptCrusty1 (3/5/2014)

    Unfortunately, I don't know how to write Visual anything these days... script task looks like a wash.

    I could write a SQL Script to do it, then the...

    March 5, 2014 at 9:02 am

    #1694360

  • RE: High Memory is 70% & growing Fast

    praneethydba (3/5/2014)

    HI,

    I am checking the memory utilisation from task manager.

    My concern is how to & where to check the problem, as my db server memeory is increasing gradually..

    Thanks

    Praveen

    Check this

    DBCC...

    March 5, 2014 at 8:46 am

    #1694347

  • RE: BIDS looking for ideas.

    You can use a script task to find if the file is empty and then use precedence constraints to direct the control to a Send Mail task reporting package failure.

    Or...

    March 5, 2014 at 8:36 am

    #1694343

  • RE: UPDATE STATISTICS on SQL 2k8 R2

    An index rebuilds updates the statistics on index columns, but not columns that are not included in indexes. Automatic or manual statistics created on the table (instead of an...

    March 5, 2014 at 8:27 am

    #1694333

  • RE: Database backup

    Run profiler during the backups and check for the Applicatio Name\Host name. That will give clue about the source of these backups.

    Using this query might also help you ..

    ...

    March 5, 2014 at 8:12 am

    #1694323

  • RE: High Memory is 70% & growing Fast

    praneethydba (3/5/2014)

    HI Experts,

    My database server memory utilisation is growing faster from past 1 week. it remained same for 1 week around 55% and now it is going to 70% and...

    March 5, 2014 at 8:04 am

    #1694314

  • RE: Create 100GB database with dummy data...

    Thanks sqlbuddy, unfortunately access to production is limited (even for me!) and it is 600GB in size, and ideally I would like to run CHECKDB with and without WITH PHYSICAL_ONLY...

    March 4, 2014 at 1:44 pm

    #1694080

Viewing 15 posts - 331 through 345 (of 1,155 total)