Browse the archive
Question In our AlwayOn environment I have two SQL servers 2014 Ent.edition (SERVER A, and SERVER B). I setup a transaction replication for [database A ], pointing to listener which shouldn't cause any issue if a failover happened. Tested, worked just fine …
Continue readingQuestion I am using SQL Server Express edition, so there is no features for backup plan, I want to take databases backup using bat script, and create a scheduler to be run everyday. I have created .bat file but need to place a time stamp at the end of backup …
Continue readingQuestion In SQL Server, if the Database is in Read_only mode, can we drop/remove unused roles? Please let me know. Thanks in advance Asked2017-04-17byBharath Kuamr reddy Answer If a database is in READ_ONLY mode, it is completely read-only. The read-only-ness …
Continue readingQuestion Let's imagine a stored procedure that retreives data and do some kind of pagination. This procedure has some inputs describing which set of data we want and how we sort it. Here is a very simple query, but let's take it as an example.
Continue readingQuestion I just got a Sql Server 2016 Availability Group setup (A Primary, a Syncronous Secondary and a Async Secondary). I have five databases on the servers. I setup an application to run queries against the server (using Entity Framework with a "failover …
Continue readingQuestion We have a 120GB database. There was table with 60GB of data which is useless and we have truncated it. Now database size is 120GB with free space 60GB. The database will not grow up to 60GB in at least 3 months. So can we shrink the data file.
Continue readingOver on Stack Exchange, someone asked why their transaction log was growing very fast during a full backup. An interesting tidbit to this question is that the database is in SIMPLE recovery – so the log should stay tiny, right? Wrong. While taking a full …
Continue readingQuestion I am having trouble getting a trigger to work. What it needs to do is to prevent any customer with last name Glass from being inserted into the database. This is what I have: CREATE TRIGGER no_last_name_glass_trg ON customer AFTER INSERT,UPDATE AS …
Continue readingQuestion This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink the log file - that is not the question. If you feel like answering that one should not do it- that has been confirmed many times yes and it is …
Continue readingQuestion I'm creating a query that has a column of dates stored as a VARCHAR in the format DD-MMM-YYYY. Could you tell me how I can convert this into date format please? I don't want to alter the original table in any way, as it's not mine to tinker!
Continue reading
