No announcements
-
1 VotesIntroducing the new Wide World Importers sample database for SQL Server (replacing AdventureWorks)
So long AdventureWorks, we’ll miss you! It’s the end of an era for the SQL Server sample database AdventureWorks as development has been suspended for the popular sample ...Sticky | 0 Replies | 5608 Views | Created by Samuel Lester - MSFT - Wednesday, November 30, 2016 9:35 PM
-
1 Votes
Finding the Correct Version of the AdventureWorks Sample Database
As the AdventureWorks sample database has evolved over the years, there are many different editions to decide from. The following blog post will help you pick the correct version to ...Sticky | 3 Replies | 15077 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:18 PM | Last reply by vuelveteloco - Sunday, June 2, 2013 1:38 PM
-
0 Votes
Visual C++ 2010 and 2013 Installed along with SQL server 2016
Hi, After installing SQL Server 2016 SP2-CU8 following components get installed: Microsoft Visual C++ 2010 x64 Redistributable - ...Proposed | 5 Replies | 300 Views | Created by Hellfire2260 - Thursday, September 5, 2019 7:54 PM | Last reply by Luigi Bruno - Friday, September 6, 2019 7:14 AM -
0 Votes
Licensing
I have two questions regarding properly licensing sql standard. If I have sql server 2016 standard on 2016 OS...do I need core licenses for both, or just SQL because its more ...Proposed | 2 Replies | 366 Views | Created by John72x - Sunday, August 25, 2019 8:23 PM | Last reply by Dedmon Dai - Monday, August 26, 2019 1:08 AM -
0 Votes
Database Experimentation Assistant - Question about analysis report
I used Database Experimentation Assistant and captured an 8 hour trace of my production on-premise SQL Server. It includes lots of stored procedure executions and select queries, but always with ...Unanswered | 3 Replies | 567 Views | Created by noamo48 - Friday, August 2, 2019 4:26 AM | Last reply by YKN123 - Friday, August 23, 2019 9:24 AM -
1 Votes
Question about online material to prepare for SQL 2016 exams (70-764 and 70-765)
Hi I am preparing for the SQL Server 2016 Administration exams (70-764 and 70-765). So far I have found the Microsoft press book "Introduction to SQL Server 2016 ...Proposed | 6 Replies | 3241 Views | Created by SQL Admin Canuck - Tuesday, February 7, 2017 2:59 PM | Last reply by Sandy Martin - Tuesday, July 30, 2019 11:48 AM -
0 Votes
RAISERROR N'<\<%7.3s>> syntax, is there documentation that explains this syntax?
Dear Microsoft Forum Member, I am reviewing the RAISERROR Microsoft documentation and reference is made to the error message with the ...Proposed | 2 Replies | 434 Views | Created by lt_Pax79 - Monday, July 29, 2019 9:36 PM | Last reply by Erland Sommarskog - Tuesday, July 30, 2019 10:19 AM -
0 Votes
SSMS 2017 system requirements
where can I find the system requirements for sql server management studio 2017?Proposed | 3 Replies | 731 Views | Created by sqlguy10 - Tuesday, June 18, 2019 1:27 PM | Last reply by Dedmon Dai - Wednesday, June 19, 2019 6:05 AM -
0 Votes
Unicode conversion in MSSQL 2017 using 13.1 odbc drivers
Hi, I am trying to convert a code to insert and select a SQL query, which I am running in Windows to Linux. It is a Unicode conversion part where I am trying to convert between ...Unanswered | 1 Replies | 1607 Views | Created by Ash46 - Monday, February 12, 2018 9:33 AM | Last reply by pituach - Sunday, June 9, 2019 11:39 AM -
0 Votes
Partitioning table is available on SQL 2016 with SP2
HI guys, I always figured that sql table partition was available only in the enterprise edition of sql 2016, but I was reading this blog and it seems to me that from SP2, this ...Answered | 5 Replies | 739 Views | Created by Adriano Neiva - Friday, May 31, 2019 3:37 PM | Last reply by Cathy Ji - Monday, June 3, 2019 7:48 AM -
0 Votes
How do I deploy reports in Visual Studio 2019
Please explain how to deploy reports with Visual Studio 2019. Specifically I would like to see the steps for downloading Visual Studio 2019 Community Edition into a cache ( us the layout command ...Unanswered | 2 Replies | 728 Views | Created by David.Brinckman - Tuesday, May 28, 2019 6:22 PM | Last reply by Olaf Helper - Wednesday, May 29, 2019 6:41 AM -
0 Votes
SQL Server Patching
Hi, I would like to have documents for SQL Server patching checklist with troubleshooting & roll back. Also patching process is ...Answered | 6 Replies | 926 Views | Created by SQL_Dave - Friday, May 3, 2019 6:17 AM | Last reply by Shanky_621 - Friday, May 3, 2019 11:04 AM -
0 Votes
sp_executeSQL documentation
Hi everybody, I'm trying to find good documentation for sp_executeSQL system procedure. I see this ...Answered | 1 Replies | 1117 Views | Created by Naomi N - Tuesday, April 23, 2019 8:13 PM | Last reply by Erland Sommarskog - Tuesday, April 23, 2019 9:23 PM -
0 Votes
What are SSIS ,SSRS and DB engine SQL server 2008R2 to 2012 IN PLACE UPGRADE steps and cautions ?
What are SSIS ,SSRS and DB engine SQL server 2008R2 to 2012 IN PLACE UPGRADE steps and cautions ? we need to upgrade to 2012 only.Answered | 2 Replies | 1384 Views | Created by datalearner - Tuesday, April 9, 2019 2:33 PM | Last reply by Puzzle_Chen - Wednesday, April 10, 2019 2:44 AM -
0 Votes
SQL Web Licensing Question
Hello: We're deploying a new license of SQL Web via Cogeco to host our website projects which is allowed via the licensing guidelines for that product. We are looking for a ...Unanswered | 2 Replies | 1448 Views | Created by TerpyV - Tuesday, April 2, 2019 7:14 PM | Last reply by Cathy Ji - Wednesday, April 3, 2019 7:41 AM -
1 Votes
DBCC TRACEON (2332, -1)
We have a third party requesting that we execute the command: DDBC TRACEON (2332, -1) Is there any guidance as to what this is for and how it is used? There ...Proposed | 2 Replies | 1377 Views | Created by Jeff Dollar - Thursday, March 28, 2019 4:56 PM | Last reply by Hilary Cotter - Thursday, March 28, 2019 5:11 PM -
4 Votes
QRY_PROFILE_LIST_MUTEX - blocking drop CI offline w/ TRACEFLAG 7412
I'm profiling a couple of approaches for dropping a clustered index. As part of this, I'm trying to capture the live execution plan using TF 7412. When attempting on session N ...Answered | 12 Replies | 2620 Views | Created by Peter Vandivier (viagogo) - Friday, December 15, 2017 12:18 PM | Last reply by Peter Vandivier - Friday, March 22, 2019 8:40 AM -
0 Votes
Create custom "Information Type" & "Sensitivity Label" in SSMS 2017
Hi I'm exploring the Data Classification tool in SSMS v17.9.1 I would like to create custom "Information Type" & "Sensitivity Labels" to ...Proposed | 2 Replies | 1385 Views | Created by Jamespy - Tuesday, March 5, 2019 2:06 PM | Last reply by Dedmon Dai - Wednesday, March 6, 2019 2:53 AM -
0 Votes
DBCC SQLPERF - Status column
Hello. Simple question (apologies if in the wrong forum). What is the Status Column in DBCC SQLPERF (logspace) for. In the documentation it states: ...Answered | 2 Replies | 1625 Views | Created by DBA_Bandy - Wednesday, February 20, 2019 9:02 PM | Last reply by Dedmon Dai - Thursday, February 21, 2019 8:11 AM -
1 Votes
Renewal of SQL Server 2008 Enterprise licenses
Hello All, We have licenses of SQL Server 2008 Enterprise (Processor based) which were bought in 2010 with an SA for 3 years. However, we didn't moved to Core ...Answered | 4 Replies | 1804 Views | Created by vrcurious - Monday, February 18, 2019 12:38 PM | Last reply by vrcurious - Tuesday, February 19, 2019 7:53 AM -
0 Votes
SQLserver download under MSDN and Volume licensing
Hello, I am looking for updated licensing info and download links that replaced the legacy MSDN portals Any links or suggestion greatly ...Proposed | 1 Replies | 1606 Views | Created by SWARAM - Friday, February 8, 2019 6:41 PM | Last reply by Tom Phillips - Friday, February 8, 2019 7:12 PM -
1 Votes
70462 practice question
hi all, i have doubt about following question.. You administer a Microsoft SQL Server 2012 database that has Trustworthy set to ...Answered | 10 Replies | 10656 Views | Created by ronnnnn - Thursday, August 22, 2013 7:08 PM | Last reply by Erland Sommarskog - Thursday, January 24, 2019 10:53 PM - Items 1 to 20 of 1045 Next ›
No announcements
