No announcements
-
0 VotesWhile creating the database it automatically set other then default collation.
Hi all, While creating the database by one of my application during installation, it automatically set other then default collation. May I know how to change the behavior of setting ...Unanswered | 1 Replies | 176 Views | Created by Arivazhagan K - Friday, December 20, 2019 9:08 AM | Last reply by Dawn Yang - Monday, December 23, 2019 5:22 AM
-
0 Votes
SQL Server 2017 maintenance plan missing on Linux Server
Hi, I have installed SQL Server 2017 on Linux Ubuntu 18.04 LTS Server. But when I connect it from SSMS which is installed on another Windows Server then on SSMS Maintenance plan is ...Proposed | 3 Replies | 450 Views | Created by WFX - Monday, December 16, 2019 12:49 PM | Last reply by Cathy Ji - Thursday, December 19, 2019 5:36 AM -
0 Votes
Huge backups after moved to Azure using Backup to Azure tool
Hi there. I have couple of servers with SQL Server 2008R2 and use Backup to Azure tool for upload database backup to Azure ...Unanswered | 7 Replies | 632 Views | Created by Oleksandr.Nedashkivskyi - Tuesday, December 10, 2019 12:36 PM | Last reply by The real Slartibartfast - Wednesday, December 18, 2019 3:33 PM -
0 Votes
Re-enable Foregin Key constraint still shows NOCHECK ?
Hello I disabled a Foreign Key constraint within a table like: ALTER TABLE [dbo].[TableName_1] NOCHECK CONSTRAINT [ForeignKeyName_FK1] But when I ran the ...Answered | 2 Replies | 428 Views | Created by techresearch7777777 - Thursday, December 12, 2019 8:41 PM | Last reply by techresearch7777777 - Friday, December 13, 2019 1:12 AM -
0 Votes
No CPU, Disk IO, Network charts in SQL 2016 Data Collection Server Activity History Report
After upgrading to SQL 2016 "Server Activity History" report in Data Collection show "No Data Available" for "% CPU", "Disk I/O Usage", "Network ...Answered | 6 Replies | 2856 Views | Created by Fenjuh - Tuesday, October 11, 2016 10:39 AM | Last reply by Marcin Woszczyna - Thursday, December 12, 2019 10:14 AM -
0 Votes
SQL 2016 export all tables within a DB to .csv files with column names?
Hello what are some ways to export all tables within a DB to comma separated .csv files with column names? Thanks in advance.Answered | 4 Replies | 642 Views | Created by techresearch7777777 - Monday, December 9, 2019 6:57 PM | Last reply by Cris Zhan - Thursday, December 12, 2019 2:26 AM -
0 Votes
sql server linked server was deleted. How to find when and who deleted the linked server?
ThanksProposed | 2 Replies | 649 Views | Created by bestrongself - Monday, December 2, 2019 8:26 PM | Last reply by Cris Zhan - Tuesday, December 10, 2019 7:01 AM -
1 Votes
DBCC CHECKDB Pages is marked with the wrong type in PFS page do DBCC CHECKDB ([MSDB], REPAIR_ALLOW_DATA_LOSS) but appear new SGAM and PFS errors
i do DBCC CHECKDB after upgrade sql server from 2012 vesion to 2017 then find the database error as below: Page (1:214377) is marked with the wrong type in ...Proposed | 9 Replies | 1119 Views | Created by Samaneh Golnavaz - Wednesday, December 4, 2019 1:24 PM | Last reply by TiborK - Friday, December 6, 2019 12:59 PM -
4 Votes
After large delete on table - Table Fragmentation ?
Hello, App team is planning on deleting millions or rows in a large table. Table has Foreign Keys/Constraints/Indexes but no Nonclustered index. After they ...Proposed | 5 Replies | 1128 Views | Created by techresearch7777777 - Wednesday, November 27, 2019 5:37 PM | Last reply by techresearch7777777 - Tuesday, December 3, 2019 1:03 AM -
0 Votes
SSMS does not take the Entered password while running as a Different user
We need to run SSMS with our Elevated accounts. but, the password keeps changing every 24 hours. So, if run SSMS with the latest password now and close it after ...Proposed | 2 Replies | 673 Views | Created by Srujan Kadaveru - Wednesday, November 27, 2019 11:08 AM | Last reply by Olaf Helper - Wednesday, November 27, 2019 5:04 PM -
1 Votes
SQL Server backups and mirror backup files.
Maintenance Plan, Is I am missing something here, or Maintenance Plan does not support backup mirrors. Please confirm. BACKUP DATABASE ...Answered | 2 Replies | 906 Views | Created by Sivakumar.In - Wednesday, November 27, 2019 9:20 AM | Last reply by Sivakumar.In - Wednesday, November 27, 2019 2:01 PM -
0 Votes
unable to backup/restore database with SQL Server 2019 - works ok with 2016
We have an application which is currently deployed using SQL Server 2016. As part of its features a user connected to a Support website is able to backup and restore the ...Answered | 8 Replies | 922 Views | Created by grsuggitt - Monday, November 25, 2019 7:49 PM | Last reply by grsuggitt - Tuesday, November 26, 2019 8:30 PM -
0 Votes
Merge Confusion Help please.
Ok so i have an ETL process that right now im Importing 5 days worth of data and then putting that in a temp table, deleting from the production table where the record exists in the temp table and ...Unanswered | 1 Replies | 918 Views | Created by Fanatic1074 - Friday, November 22, 2019 12:33 AM | Last reply by Cathy Ji - Monday, November 25, 2019 8:54 AM -
0 Votes
Create new indexes and rebuild/reorg indexes maintenance during active user select queries ?
Hello, is it possible to create new indexes at the same time while users are actively running select queries and not block them (SQL 2016) ? Also during rebuild/reorg indexes ...Proposed | 2 Replies | 775 Views | Created by techresearch7777777 - Friday, November 22, 2019 7:52 PM | Last reply by Dedmon Dai - Monday, November 25, 2019 8:07 AM -
0 Votes
Add feature: Disable outlining globally
Feel free to move this to the proper forum. Add feature: Disable outlining globally There is not ...Discussion | 2 Replies | 741 Views | Created by DanOldenkamp - Monday, November 18, 2019 6:09 PM | Last reply by TiborK - Tuesday, November 19, 2019 11:43 AM -
0 Votes
SQL 2016 CXCONSUMER wait type ?
Hello one of our Developers complains their query/process is slow and notice it's SPID currently running has CXCONSUMER wait type listed. I briefly researched that this is a new ...Proposed | 1 Replies | 945 Views | Created by techresearch7777777 - Thursday, November 14, 2019 12:58 AM | Last reply by Cathy Ji - Friday, November 15, 2019 6:23 AM -
0 Votes
Change 'Allow Snapshot' for tempdb itself?
Ok, so we have a database 'AAA' with Read Committed snapshot On, as per general advice regarding blocking issues. We were then approached to put another vendor's database 'BBB' on ...Answered | 6 Replies | 777 Views | Created by MattiasNilsson - Tuesday, November 12, 2019 2:15 PM | Last reply by Shanky_621 - Wednesday, November 13, 2019 7:46 AM -
1 Votes
Increase performance for current running Stored Procedures?
Hello is there any way by chance to increase performance for currently running Stored Procedures on Production without changing the code within Stored Procedures? I know it sounds ...Proposed | 2 Replies | 815 Views | Created by techresearch7777777 - Friday, November 8, 2019 3:47 PM | Last reply by Dedmon Dai - Monday, November 11, 2019 7:12 AM -
9 Votes
SSMS stops working in SQL 2016 when clicking permissions
Hi All, After installing Microsoft SQL 2016 from scratch , we noticed that SSMS stop working when clicking permission tab(Attached) I tried to install ...Unanswered | 11 Replies | 3165 Views | Created by Peter Zulof - Wednesday, December 28, 2016 10:30 AM | Last reply by jamal Ali Numan - Saturday, November 9, 2019 6:22 PM -
0 Votes
Minimal permissions to tune indexes?
Hello a developer requested to have permissions to run SQL Profiler. From my understanding user needs to be within sysadmin role or be granted ALTER trace permission which sounds ...Answered | 2 Replies | 959 Views | Created by techresearch7777777 - Friday, November 8, 2019 5:55 PM | Last reply by techresearch7777777 - Friday, November 8, 2019 9:30 PM - Items 1 to 20 of 2361 Next ›
No announcements
