Forum Replies Created

Viewing 15 posts - 346 through 360 (of 5,841 total)

  • RE: Trying to find the correct occurance!

    ScottPletcher - Wednesday, March 8, 2017 10:53 AM

    Are you allowed to create a split function in the tempdb db?  Ask them.  It...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 8, 2017 at 12:04 pm

    #1932379

  • RE: capture data changes on tables

    savibp3 - Wednesday, March 8, 2017 11:47 AM

    I need to stored procedure to capture data changes like insert update and delete on...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 8, 2017 at 12:03 pm

    #1932378

  • RE: Trying to find the correct occurance!

    Have whoever owns the server create a new database for you to do the work. If you are allowed to "blow up" tempdb with a mistake you should be able...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 8, 2017 at 7:50 am

    #1932307

  • RE: SSMS 2014 running slow

    John Mitchell-245523 - Wednesday, March 8, 2017 3:39 AM

    Have you tried applying SP2?  Better still, why not go straight to SSMS 2016?

    John

    +1,...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 8, 2017 at 6:31 am

    #1932276

  • RE: The Accidental DBA - Wait Stats

    Middle and senior IT management at your company needs to be taken out behind the wood shed and soundly thrashed. Their decisions and failure to act are a root cause...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 7, 2017 at 8:09 am

    #1932049

  • RE: Index Size Difference

    Rebuild your nonclustered index and report the size back.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 7, 2017 at 7:52 am

    #1932045

  • RE: Primary key violation on INSERT, even though TABLOCKX is held

    Jon 0x7f800000 - Monday, March 6, 2017 10:21 AM

    Hi Kevin. I was also paranoid about the optimizer ignoring the SELECT. I checked...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 10:42 am

    #1931879

  • RE: Primary key violation on INSERT, even though TABLOCKX is held

    Jon 0x7f800000 - Monday, March 6, 2017 9:47 AM

    Hi Ken. Thanks for the suggestion. I read a nice article about a cleaner...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 10:09 am

    #1931869

  • RE: De-Concatenate multi-select picklist and transform into target multi-select picklist values

    aldous.chris - Monday, March 6, 2017 8:17 AM

    Hi All, 

    Thank you for your quick responses. Apologies for the lack of detail in my previous post.

    A...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 8:58 am

    #1931845

  • RE: Cursor Insert into table with IDENTITY crisis

    John Mitchell-245523 - Monday, March 6, 2017 7:55 AM

    Do you have any control over the structure of the ssf_widget_history table?  If so,...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 8:01 am

    #1931814

  • RE: Database Mirroring and Transaction Log Backups

    Brandie Tarvin - Monday, March 6, 2017 7:36 AM

    TheSQLGuru - Monday, March 6, 2017 7:29 AM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 7:46 am

    #1931800

  • RE: The Accidental DBA - Wait Stats

    stephen.plant2 - Monday, March 6, 2017 7:12 AM

    Thanks for the replies, every day is a school day.

    I am trying to get some...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 7:40 am

    #1931796

  • RE: checkdb "Multiple IAM pages for object"

    sgt500 - Monday, March 6, 2017 7:24 AM

    just tried to rebuild the pk of an empty table (the one in the first...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 7:35 am

    #1931791

  • RE: Database Mirroring and Transaction Log Backups

    Brandie Tarvin - Monday, March 6, 2017 7:08 AM

    Quick question for you all. Does the secondary database in Database Mirroring require direct access...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 7:29 am

    #1931787

  • RE: Stored Procedure in SQL for Wonderware Historian not Working*********URGENT

    Whenever doing dynamic SQL, PRINT is your friend!! I NEVER execute something I am creating dynamically without first making sure it can be copied/pasted in SSMS and actually give a...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 6, 2017 at 6:56 am

    #1931777

Viewing 15 posts - 346 through 360 (of 5,841 total)