|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Clearing Backup History | |
If I want to clear the backup history for only the Scratch database from my instance, and not remove history for the Sales database, how do I do this? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Removing Ghosts Which command would I use to immediately remove ghost records from a page that have not been cleaned up by the background process? Answer: sp_clean_db_file_free_space Explanation: Of all these answers, only sp_clean_db_file_free_space is a real procedure. This will clean the ghost records from pages. Ref: sp_clean_db_file_free_space() - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-clean-db-file-free-space-transact-sql?view=sql-server-2017 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
AlwaysOn AG versus FCI Licensing - AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) Checking to see the licensing cost for 2 and 3. Would there be licensing cost for secondary replica or the cost would be for secondary server only? Please advise? FCI is for HA scenarios. An AG synchronous secondary replica, co-located with the primary, is for […] |
Powershell for Automating SQL Server Restore. - Team, Has anybody written a Windows Powershell Script to Automate the SQL Server Restore process. I am looking for following Input Parameters:- DB Name Backup Path The script should be able to script out the Logins before starting the Restore process. I am looking for to Restore the Databases using it's most Recent Backup copy. […] |
Verifying Backup Integrity. - Team, If DBCC CHECKDB is successful; do we still need to perform Verify Backup Integrity while taking the DB Backups. As far as i believe; if DBCC CHECKDB is successful then it means that the Database is free from any sort of corruption. In that case; there shouldn't be a need to perform Verify Backup […] |
Updates are failing - Hi All, We are facing a roadblock in production server, hope experts can give some solution here. we are having a 900GB MS-CRM on premise database with replication in place. In every 6-8 hours interval DB is declining all updates from application, unable to find the exact reason. any updates to any table is giving […] |
FO cluster.... Sql browser behaviour - Apologies if this topic has been cleared away many times. I can't locate the specifics of this if so. A new Sql 2017 Ent FO cluster default instance (1433) named instance 1 (1434) named instance 2 (1435) named instance 3 (1436) named instance 4 (1437) named instance 5 (1438) I can connect to the default […] |
SQL Server 2016 - Administration |
Cluster with Multipal Editons - Can I have a AG cluster with six nodes , three with Sql2014 and three with Sql 2016 or 2017 ?, if yes, is this supported configuration ? |
Create table structure if the source table structure changes - Hi, I want to implement a logic where I need to check if the table that I'm archiving from source database is exists or it's structure changed and if Yes, then drop and recreate the table structure in archive database. Can you please advise the best way to achieve this? |
Archiving data - Hi, I'm trying to archive tables that have data older than 6 months into an Archive database from source database. There are many parent child tables and I've created them in Archive database with the same structure. I've created a stored procedure similar to the one explained here at: http://vyaskn.tripod.com/sql_archive_data.htm It works fine few runs […] |
SQL Server 2016 - Development and T-SQL |
Disappearing posts - Hi all I've tried to post an issue that got marked a SPAM (for no reason that I could see, although I did try to edit it to correct some typos). The forum will not allow me to post the question again as it's saying "Duplicate post" but I can't see it. The post […] |
Development - SQL Server 2014 |
How to find materialized/indexed views in a database? - My manager tasked me to find all materialized views in our database. In SQL Server i guess it translates to "indexed" views. But anyway, I checked sys.views, sys.objects and there is nothing there that can indicate it, all views are shown the same V. Is there is anything else in dictionary objects that I should […] |
If we pass the DB name paramter should take the backup in the same server - Hi Team, Please help me on this below metioned code. Requirement: If we pass the DB name should take the Full or Diff or Tlog backups in deafult location where the data files existed in the same server. First it should check the DB size and drive space is avaialble then it create or disply […] |
SQL 2012 - General |
No answer from answers.microsoft.com on this problem yet... - I posted the below in the answers.microsoft.com forums, but after three days have yet to receive a reply. Perhaps I posted to the wrong forum there: *********************************************************************** Below is from answers.microsoft.com *********************************************************************** looked at this thread... https://answers.microsoft.com/en-us/education_ms/forum/all/excel-2016-what-is-the-connection-string-for/75eeba94-bb05-4c86-8195-185d07e7ea49 So I tried using the Excel 2007 connection string: EXEC sp_addlinkedserver @server = 'ExcelLinkSrv2', @srvproduct = 'Excel', […] |
Reporting Services |
ssrs 2012 subreport is running really slow - I have an existing ssrs 2012 report that is running really slow this year. Last year it did not run as slow. Basically there is a driver report and this driver report can run up to 9 subreports. The number of subreports that are executed depend upon how many reports the user selects to run. […] |
Disaster Recovery |
Attaching Multiple MDF and having LDF regenerated - There are a bunch of posts for attaching a single MDF and having the LDF regenerated using sp_attach_single_file_db. Can anyone see anything wrong with this approach for doing the same thing with multiple MDFs? 1. Detach the database 2. Delete or move the log file to a new location so it will not be found. 3. […] |
Administering |
FUll Text Index Very slow - I am using full text indexing for partial match and Today it started to be very slow when I use the following queries It takes more than 1 min to return the results. SELECT * FROM [Syn].[CustomerNamesSyn] AS Customer WITH(NOLOCK) WHERE CONTAINS(Customer.CustomerName, ‘ ”any input string *” ’) The full text index is set […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |