No announcements
-
0 VotesDBCC Integrity Check Job running for ever - Sql 2012
Hello, We have Sql Server 2012 and mainly using for Sharepoint. We have Database Integrity Check jobs running every early morning during off hours into sql server ...Unanswered | 8 Replies | 70 Views | Created by pdsqsql - 17 hours 19 minutes ago | Last reply by TiborK - 9 hours 1 minutes ago
-
0 Votes
MS-SQL 2019 : licence activation vs VERITAS BACKUPEXEC
Hello, I plan to activate many MS-SQL Server 2019 (standard); buy some licences and some CAL. But, for the moment, the purchase activites are not done, but only ...Unanswered | 1 Replies | 31 Views | Created by Cerkyr - 19 hours 41 minutes ago | Last reply by Olaf Helper - 18 hours 55 minutes ago -
0 Votes
SQL - Browse for Servers
(see pic) SQL Server 2019 The Connect to Server - SQL Server - Browse for Servers screen locks up (mouse clicks don't ...Unanswered | 3 Replies | 90 Views | Created by AugTechAce - Monday, January 27, 2020 7:20 PM | Last reply by Cathy Ji - Tuesday, January 28, 2020 2:18 AM -
0 Votes
SSMS is crashing and restarting
We've migrated to SQL 2019, wo we upgraded our SQL managing systems to SSMS 18.4. When we attempted to open more than one object in the security folder at a time, and work in them, ...Proposed | 9 Replies | 268 Views | Created by DarkAngel11 - Friday, January 17, 2020 9:59 PM | Last reply by Freya009 - Wednesday, January 22, 2020 11:51 AM -
1 Votes
Query sometimes is very slow under the same conditions
So I have a perplexing problem here. There is a query in my project that in 99 percent of time takes 200 ms to complete on my local machine. However, sometimes under the same circumstances it takes 25 ...Unanswered | 6 Replies | 301 Views | Created by EugeneKr - Friday, January 17, 2020 8:19 AM | Last reply by EugeneKr - Wednesday, January 22, 2020 8:24 AM -
3 Votes
How to check when Db was last used in order to remove them from server.
I am using SQL Server 2008R2 & i have 50 DB's in this instance. my Question is how to Identify , when a DB's was last accessed. Based on the last date of ...Answered | 3 Replies | 219 Views | Created by NJPA1234 - Thursday, January 16, 2020 7:50 PM | Last reply by NJPA1234 - Monday, January 20, 2020 4:34 PM -
2 Votes
Needing info on SQL Database managed instance
Hi, I want to explore SQL Database managed instance with my msdn subscription. I think every month i get $200 in my azure account but it is not sufficient to rent a SQL ...Answered | 10 Replies | 505 Views | Created by Anil_Kumar_DBA - Thursday, January 2, 2020 8:58 AM | Last reply by Anil_Kumar_DBA - Friday, January 17, 2020 4:27 AM -
0 Votes
Management Studio frame construction issue
n exception was encountered while constructing the content of this frame. This information is also logged in ...Unanswered | 5 Replies | 5681 Views | Created by Sql Dude - Thursday, May 11, 2017 5:13 PM | Last reply by chj124 - Thursday, January 16, 2020 1:30 PM -
0 Votes
While 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 | 5 Replies | 554 Views | Created by Arivazhagan K - Friday, December 20, 2019 9:08 AM | Last reply by TiborK - Thursday, January 16, 2020 12:41 PM -
0 Votes
SQL Server 2017 - MDW - SQL Server Memory Usage Report is broken
Hi all I thought I'd share. Steps to recreate: In Object Explorer expand Databases.Expand Management.Right click Data Collection.Configure both MDW, and ...Unanswered | 2 Replies | 1255 Views | Created by Phil Stollery - Friday, January 26, 2018 3:17 PM | Last reply by Marcin Woszczyna - Thursday, January 9, 2020 1:44 PM -
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 | 5 Replies | 961 Views | Created by techresearch7777777 - Monday, December 9, 2019 6:57 PM | Last reply by Cris Zhan - Monday, December 30, 2019 1:30 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 | 652 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 | 861 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 | 624 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 | 3045 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 server linked server was deleted. How to find when and who deleted the linked server?
ThanksProposed | 2 Replies | 821 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 | 1306 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 | 1316 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 | 821 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 | 1056 Views | Created by Sivakumar.In - Wednesday, November 27, 2019 9:20 AM | Last reply by Sivakumar.In - Wednesday, November 27, 2019 2:01 PM - Items 1 to 20 of 2367 Next ›
No announcements
