Forum Replies Created

Viewing 15 posts - 1 through 15 (of 360 total)

  • RE: procs transfer to new schema deletes permissions

    I thought of the same. However, it appears there are close to 4k procs and I am looking at transferring around 2.5k. I felt scripting out will be taking long...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: question on clustering and standard edition in sqlserver 2012

    Perry Whittle - Thursday, August 24, 2017 9:04 AM

    sasken - Thursday, August 24, 2017 8:41 AM

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: question on clustering and standard edition in sqlserver 2012

    anthony.green - Friday, August 25, 2017 5:30 AM

    May be reading this the wrong way but hopefully I got this right.

    Sounds to me...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: question on clustering and standard edition in sqlserver 2012

    OK Thanks. So a disk failure in this case should perform an automatic failover as the instances are different and so are the SANs. correct?

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: 24x7 availability with SQL Server 2012 Standard Edition

    mandated by upper management to reduce downtime.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: 24x7 availability with SQL Server 2012 Standard Edition

    Steve Jones - SSC Editor (5/24/2016)


    It's complex, and I think step #3 can perhaps be more difficult that you imagine. How are you sure the data is up to date?...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Hybrid model database design

    Eirikur Eiriksson (5/14/2015)


    Sapen (5/14/2015)


    Hello,

    I am using sql2012 se and we want to use couchbase to store some data as documents. So the database will be Hybrid(partly SQLServer and Partly couchbase)....

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Hybrid model database design

    Because we are on standard edition and not enterprise

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Function to determine business hours

    WHat should be modified here if starttime is 9:00AM and endtime is 6:00PM and lunch is 12:00PM to 1:00PM

    I will be passing the starttime and endtime as ('2015-01-01 10:20:01.001','2015-01-01 17:29:21.001')

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Calculating Working Hours

    Where shd i make changes to the script if work hours are 9:00AM to 6:00PM and Lunch hours are 12:00PM to 1:00PM?

    Thanks

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Drop Unused indexes?

    Alan.B (3/23/2015)


    Although the user seeks, user scans and userlookups are all 0 the user updates is definitely a lot. I am thinking to speed up updates on subscriber these indexes...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Appending backups

    roblew 15918 (3/23/2015)


    Just hit a issue where we had a 40gb backup file for a database with an mdf of less than 2gb and tran log less than half a...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Index performance - DeFragmented to Fragmented to 90%+

    Simply shrink the data file and it will cause fragmentation.

    You can insert,update and delete tons of data into this table and you will notice fragmentation. Script from Robert works...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: ONLY sysadmin permissions

    shahgols (3/20/2015)


    Hi everyone, I have been looking online for permissions that only sysadmin has, but couldn't come up with a list. What are the permissions that are only sysadmin?...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Should I run CHECKDB on SSISDB database

    Absolutely

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 15 posts - 1 through 15 (of 360 total)