No announcements
-
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. -
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 | 780 Views | Created by Samaneh Golnavaz - Wednesday, December 4, 2019 1:24 PM | Last reply by TiborK - Friday, December 6, 2019 12:59 PM -
0 Votes
sql server linked server was deleted. How to find when and who deleted the linked server?
ThanksUnanswered | 1 Replies | 325 Views | Created by bestrongself - Monday, December 2, 2019 8:26 PM | Last reply by Cris Zhan - Tuesday, December 3, 2019 5:40 AM -
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 | 566 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 | 400 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 | 499 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 | 593 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 | 627 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 | 516 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 | 461 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 | 612 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 | 508 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 | 506 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 | 2853 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 | 673 Views | Created by techresearch7777777 - Friday, November 8, 2019 5:55 PM | Last reply by techresearch7777777 - Friday, November 8, 2019 9:30 PM -
0 Votes
SET STATISTICS impact not setting to OFF ?
Hello if I use one of the SET STATISTICS commands like: SET STATISTICS IO ON And not setting back to OFF...are there any negative ...Answered | 2 Replies | 536 Views | Created by techresearch7777777 - Friday, November 8, 2019 6:24 PM | Last reply by techresearch7777777 - Friday, November 8, 2019 6:46 PM -
1 Votes
SSMS 18.3.1 Column width is not auto sizing
Hello, I have noticed that in SSMS 18.3.1 there are a lot more columns that are not auto sizing. Is there a setting that can be changed or adjusted to have all ...Unanswered | 8 Replies | 937 Views | Created by Sylviarf - Monday, October 14, 2019 6:32 PM | Last reply by Sylviarf - Thursday, November 7, 2019 4:30 PM -
0 Votes
I Get an Error When attempting to Restore .bak file to an Empty Database
I get an Error when I attempt to restore a .bak file to an Empty database. Error below The file 'D:\SQL_Server_Database\WSS_Content_SP.mdf' cannot be ...Unanswered | 5 Replies | 609 Views | Created by Mike Williams MCP, MCTS - Monday, October 28, 2019 6:39 PM | Last reply by Amelia Gu - Wednesday, October 30, 2019 7:12 AM -
0 Votes
Azure VM SQL Server 2016 Diff backups are failing.
Hi All, I have SQL Server 2016 Developer edition on Azure VM and this Instances has Databases as well. 1.We configured Full and Diff ...Answered | 4 Replies | 1902 Views | Created by SNIVAS - Wednesday, February 28, 2018 9:43 AM | Last reply by Rob0233 - Thursday, October 24, 2019 7:28 PM -
0 Votes
SQL Server changes that require a restart
I'm looking for an overview of which SQL Server changes require a restart. This is not about the parameters that are listed in the sys.configurations (here I know that a restart is required if the ...Proposed | 10 Replies | 678 Views | Created by Oliver-T - Tuesday, October 22, 2019 12:55 PM | Last reply by KevinBHill - Wednesday, October 23, 2019 12:03 PM - Items 1 to 20 of 2357 Next ›
No announcements