SQL Server Setup & Upgrade announcement
-
Link
- Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
- What's new.(Why upgrade)
-
0 Votesrename instance name
Hi, I have an existing SQL Server 2012 named instance a-aks\BIL, a-aks is the hostname and BIL is the database running on it. Now I want to change ...Unanswered | 3 Replies | 39 Views | Created by biltz - 2 hours 5 minutes ago | Last reply by biltz - 1 hour 29 minutes ago -
0 VotesWho will be announced the next SQL Server Database Engine Guru? Read more about October 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ... -
1 Votesnot able to connect locally using OLEDB Driver after applying CU KB4032541
I have upgraded from SQL2008R2 to 2014 few months back. everything is working fine. but recently after applying CU KB4032541. client connections using OLEDB and SQL ...Unanswered | 4 Replies | 213 Views | Created by chandra sekhar pathivada - Saturday, September 23, 2017 3:40 AM | Last reply by chandra sekhar pathivada - 20 hours 22 minutes ago -
0 Votesdbcc checkdb errors come and go
Really odd issue on our Sqlserver 2008 R2 Sp3 (10.50.6529.0) running with Server 2008R2 SP1 which runs as a VM on our Server 2012 HyperV Server. This is a small SQL system, nothing fancy (no ...Unanswered | 4 Replies | 88 Views | Created by AMBW - Friday, September 29, 2017 5:08 PM | Last reply by Erland Sommarskog - Saturday, September 30, 2017 10:16 AM -
0 VotesSPACE RESERVED IS Almost EQUAL TO SPACE USED for .MDF file in my database?
Hi Experts, Need some help ! I have a question about the capacity planning for a ...Unanswered | 1 Replies | 72 Views | Created by NEKUK - Saturday, September 30, 2017 4:11 AM | Last reply by Erland Sommarskog - Saturday, September 30, 2017 8:54 AM -
0 VotesSQL Server 2016 SP1 CU5 patching
Hi there! I am trying to apply Microsoft SQL Server 2016 SP1 CU5 (13.0.4451.0) on Microsoft SQL Server 2016 (SP1-CU4) (KB4024305) - 13.0.4446.0 (X64) ... -
0 Votessql server 2014 management studio tools are greyed out
We have SQL 2014 installed on the application server, we created a new virtual box on a different server for a outside consultant and we want to install SQL MS Management Studio on that box so he can ...Unanswered | 2 Replies | 52 Views | Created by mlangdon2006 - Friday, September 29, 2017 6:23 PM | Last reply by mlangdon2006 - Friday, September 29, 2017 10:04 PM -
2 VotesSQL Server 2016 - Poor Performance
We recently upgraded to SQL 2016, and in general we have seen improved performance (we did increase the number of CPUs/RAM as well) However, we have a number of large stored procs ...Answered | 5 Replies | 462 Views | Created by DJL - Thursday, March 30, 2017 2:38 PM | Last reply by Erland Sommarskog - Friday, September 29, 2017 9:21 PM -
0 VotesSQL Server 2016 Nested MERGE Causing A system assertion check has failed
Let me first say that I understand that Microsoft says they have a bug fix (https://support.microsoft.com/en-us/help/3205964/fix-an-assertion-occurs-when-you-bulk-insert-data-into-a-table-from-mu), ...Unanswered | 7 Replies | 132 Views | Created by maverick_ncsu - Thursday, September 28, 2017 1:15 PM | Last reply by Erland Sommarskog - Friday, September 29, 2017 9:16 PM -
0 VotesSQL SERVER 2016 Upgrade from Evaluatuion to Standard
We are not able to upgrade from SQL SERVER 2016 to standard. The file obtained form volume licensing when run fails: Overall summary: ...Unanswered | 2 Replies | 54 Views | Created by blah123eeee - Friday, September 29, 2017 6:56 PM | Last reply by blah123eeee - Friday, September 29, 2017 8:24 PM -
0 Votesinsufficient memory in resource pool 'PoolCIMWork'
SQL Server 2016 SP1 build 13.0.4451.0 Server has 64 Gig of memory, SQL Server gets 58 Gig. With small resource pool 'MyResourcePool' @1% for both min & max ...Unanswered | 3 Replies | 163 Views | Created by mannsjp64 - Monday, September 25, 2017 10:49 PM | Last reply by mannsjp64 - Friday, September 29, 2017 5:07 PM -
0 VotesSQL Server Backup
How to take SQL server databases backup which are part of always-on HA. Maintenance plan is not working, we have set the backup preference as secondary. We need to do daily full backup, ...Answered | 10 Replies | 209 Views | Created by KRevolution - Tuesday, September 26, 2017 10:37 PM | Last reply by Hannah Yu - Friday, September 29, 2017 4:01 PM -
0 VotesBackup issues in SQL 2016 SP1 with checksum, compressions and verification
We are seeing The Data is invalid messages when we backup large databases with checksum and compression in the restore verifyonly part. We have some databases that we use Ola Hallengren's scripts to ...Unanswered | 10 Replies | 338 Views | Created by Chris Wood SQL DBA - Wednesday, September 06, 2017 4:35 PM | Last reply by Chris Wood SQL DBA - Friday, September 29, 2017 2:05 PM -
1 VotesFile system error (- 1073741819)
Hi, whenever I try to install a SQL Server onto virtual Windows 10 machine, i receive the error message "File system error (- 1073741819)" I've tried ...Proposed | 1 Replies | 56 Views | Created by Vojtěch VZ Zicha - Friday, September 29, 2017 11:16 AM | Last reply by Kapil.Kumawat - Friday, September 29, 2017 1:30 PM -
0 VotesSQL server memory utilization
Hi, I am running on SQL server 2012 11.0.6020.0 SP3 STD. From memory perspective the SQL server MAX and MIN are configured at 1024 MB and ...Answered | 4 Replies | 73 Views | Created by Eben Raja Earnest - Friday, September 29, 2017 12:28 PM | Last reply by Tom Phillips - Friday, September 29, 2017 1:30 PM -
1 VotesWho will be announced the next Microsoft TechNet Guru? Read more about September 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...Discussion | 2 Replies | 295 Views | Created by [Kamlesh Kumar] - Friday, September 01, 2017 9:57 AM | Last reply by [Kamlesh Kumar] - Friday, September 29, 2017 11:03 AM -
0 VotesT-SQL Code to Skip update stats on table and move to next table after X minutes to avoid blocking
Is there any code by using which can skip the update stats on an object and move to next object if there is already a lock placed on the object. This is needed to avoid blocking ...Unanswered | 5 Replies | 90 Views | Created by Kranthi_666 - Thursday, September 28, 2017 4:41 PM | Last reply by Shanky_621 - Friday, September 29, 2017 9:53 AM -
0 VotesAlias disappears from design when it's the same as fieldname but with different caption
I have 2 systems, one development system and one production system. In production I have a wiew that is linked to tables from another database and in that view one field is named ...Unanswered | 0 Replies | 47 Views | Created by Torben Moberg Jørgensen - Friday, September 29, 2017 8:20 AM -
0 VotesResults taking for ever
Hello, select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from ...Unanswered | 2 Replies | 86 Views | Created by Felyjos - Friday, September 29, 2017 3:39 AM | Last reply by Erland Sommarskog - Friday, September 29, 2017 7:23 AM -
0 VotesSQL Server Developer getting cumulative database size would exceed your licensed limit message
Running code in Visual Studio that would be creating a new database but getting an error indicating I have a cumulative database size restriction. I'll include a details below, along with the ...Proposed | 3 Replies | 97 Views | Created by bryanbeck65 - Wednesday, September 27, 2017 7:45 PM | Last reply by Lin Leng - Friday, September 29, 2017 6:24 AM - Items 1 to 20 of 51571 Next ›
SQL Server Setup & Upgrade announcement
-
Link
- Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
- What's new.(Why upgrade)
