No announcements
-
1 Votes
Introducing 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 | 11609 Views | Created by Samuel Lester - MSFT - Wednesday, November 30, 2016 9:35 PM
Found 1070 threads
-
0 Votes
Is it possible to stop a Azure SQL Database during non working hours to reduce billing charges?, how?
Is it possible to stop a Azure SQL Database during non working hours to reduce billing charges?, If answer is yes, I will appreciate if you let know how I can do ...Unanswered | 5 Replies | 4046 Views | Created by EduOca - Tuesday, August 4, 2020 12:27 AM | Last reply by MIAOYUXI - Thursday, August 6, 2020 1:21 AM -
0 Votes
[Announcement] SQL server related Forums will be migrated to a new home on Microsoft Q&A!
This SQL Server related Forum will be migrated to a new home on Microsoft Q&A! We’ve listened to your feedback on how we can enhance the ... -
0 Votes
Not able to connect Microsoft SQL server Management Studio
Hi I am not able to open SQL server Management Studio, there is an error when I try to open. (I've installed 2016 version, the movement I've installed and try to open I get ...Answered | 13 Replies | 8365 Views | Created by Suri24 - Wednesday, July 22, 2020 3:36 PM | Last reply by - Tuesday, July 28, 2020 1:03 PM -
0 Votes
No Default Instance when Launching SQL (Error Text in Body Below)
Hello all, I am currently receiving the following error message in SQL 2017: I launch SQL and have no default ...Unanswered | 3 Replies | 7174 Views | Created by BillGates_Sr - Friday, December 27, 2019 2:11 AM | Last reply by Cris Zhan - Wednesday, July 22, 2020 9:32 AM -
5 Votes
Problem tracing Error: 8623 with extended events
15)) ADD TARGET package0.event_file(SET filename=N'C:\trace\ErrorReported.xel',max_file_size=(250),max_rollover_files=(4)) WITH (MAX_MEMORY=4096 ...Answered | 14 Replies | 5286 Views | Created by Peter Akerlund - Friday, June 26, 2020 11:14 AM | Last reply by Peter Akerlund - Wednesday, July 8, 2020 5:05 AM -
1 Votes
What are the name of the ETW prover that SQL Server extended events are using?
We are using nxLog for sending all kind the logging information to a Graylog. This is working for both the SQL Server error log and SQL audit logs but also for other none ...Unanswered | 3 Replies | 5230 Views | Created by Peter Akerlund - Wednesday, June 10, 2020 5:27 AM | Last reply by Peter Akerlund - Tuesday, June 23, 2020 11:45 AM -
0 Votes
EULA - Benchmark
Hi, I am currently writing a Thesis at TU Wien about Column store extensions to popular row-based databases. It benchmarks the Postgres cstore_fdw extension and SQL Server column ...Unanswered | 2 Replies | 3910 Views | Created by xVinci - Thursday, May 14, 2020 1:03 PM | Last reply by Cris Zhan - Monday, June 8, 2020 1:04 AM -
0 Votes
SQL Server Cross edition licensing
Hi, I have a question regarding Cross edition in one server. My Client wants to consolidate a few SQL servers into one server, but it has different SQL ...Unanswered | 6 Replies | 4411 Views | Created by GedasKri - Monday, May 18, 2020 7:37 AM | Last reply by MIAOYUXI - Wednesday, May 20, 2020 1:32 AM -
0 Votes
Running total in MS Access
Hi I managed to optain the desired outcome in SQL server via the following query ...Proposed | 3 Replies | 4829 Views | Created by Vincent Coulombe - Sunday, April 12, 2020 11:52 PM | Last reply by Cathy Ji - Tuesday, April 14, 2020 2:39 AM -
0 Votes
Server Operating System Upgrade Question
We are working with a client that has a line-of-business application that is built on Microsoft SQL Server. Specifically, they are using SQL Server 2014 Standard. The operating system on ...Unanswered | 3 Replies | 4173 Views | Created by JN92 - Monday, April 13, 2020 3:07 PM | Last reply by Erland Sommarskog - Monday, April 13, 2020 5:28 PM -
0 Votes
Save Query Results To HTML File
0 Group By SubString([Route],1,1),[Pick_Area] PaulAnswered | 3 Replies | 4627 Views | Created by Paul 2 U - Tuesday, April 7, 2020 12:15 PM | Last reply by Dawn Young - Friday, April 10, 2020 8:56 AM -
0 Votes
SQL Server 2016 SP1 and Intel Optane App Direct Mode
Hello, I am having a hard time finding anything on what is or not supported for SQL Server 2016 SP1. It seems that in order to load your database into optane memory you must have ...Unanswered | 4 Replies | 5046 Views | Created by Dubblies - Friday, March 20, 2020 3:24 PM | Last reply by MIAOYUXI - Wednesday, March 25, 2020 8:12 AM -
0 Votes
Certification for Sql server 2019 ?
Hi , Sorry if this is the wrong forum to raise this question. I am considering gaining Sql Server professional certification (for Database ...Proposed | 4 Replies | 4802 Views | Created by PaulSpd - Thursday, February 27, 2020 10:58 AM | Last reply by Cathy Ji - Monday, March 2, 2020 8:19 AM -
0 Votes
SQL server Performance
Hi, There are lot of monitoring tools in MSSQL server can i know the difference between them. What are the changes that are applied in each monitor ...Unanswered | 3 Replies | 4439 Views | Created by iammani - Wednesday, February 26, 2020 6:19 AM | Last reply by Laxmidhar sahoo - Saturday, February 29, 2020 8:44 AM -
0 Votes
Sql Server deployment to different environments
Hi, I need to know the deployment process for SQL Server changes from one env to another env, how can we promote builds from one env to another. how the ne les in ...Answered | 5 Replies | 4657 Views | Created by info2m - Tuesday, February 11, 2020 9:34 PM | Last reply by Dawn Young - Friday, February 14, 2020 9:32 AM -
0 Votes
how to reuse the name of column in select sql query
1) i want reuse in place of Max(PrixRevient) just put [Max1] also i want use it in union select query SELECT "BL" AS ...Proposed | 2 Replies | 6260 Views | Created by Houssem12 - Saturday, February 1, 2020 10:02 AM | Last reply by Lily Lii - Thursday, February 6, 2020 1:42 AM -
1 Votes
Polybase for Blob Storage, to get data from Azure Data Lake Gen2
It is difficult to find documentation if this is supported or not. There is documentation that says import from Azure Data Lake Storage for SQL Server 2016/17/19 is not ...Answered | 1 Replies | 5448 Views | Created by Florian Dworak - Saturday, January 11, 2020 11:17 AM | Last reply by Srihad - Saturday, January 11, 2020 2:21 PM -
4 Votes
Problems with SQL Concatenation + Missing Documentation On This
TL; DR: If you want to tell someone who IS successfully using SQL concatenation NOT to use SQL Concatenation - how can you 1) Show them how their working example ...Proposed | 10 Replies | 6941 Views | Created by OneLChela - Wednesday, November 6, 2019 11:38 PM | Last reply by OneLChela - Sunday, January 5, 2020 7:27 PM -
0 Votes
Where to Download SQL 2012 Enterprise Edition Trial
Where to Download SQL 2012 Enterprise Edition TrialProposed | 2 Replies | 4439 Views | Created by ShahulFaizal - Thursday, January 2, 2020 1:37 PM | Last reply by Dawn Young - Friday, January 3, 2020 1:37 AM -
0 Votes
SQL Server Agent Job with red x icon.
Hello, In SSMS SQL Server Agent job shows red x(cross) symbol even though my job completed successfully. Can someone help me to understand why it is showing ...Answered | 2 Replies | 10390 Views | Created by ShyamReddy - Friday, December 20, 2019 3:18 PM | Last reply by ShyamReddy - Friday, December 20, 2019 3:46 PM - Items 1 to 20 of 1070 Next ›
No announcements