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 | 2128 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 | 12057 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:18 PM | Last reply by vuelveteloco - Sunday, June 02, 2013 1:38 PM
-
0 Votes
SQL Server 2017 Documents sharing
Dear All, who can share with me some document about sql server 2017's new feature? Thanks in advance. VWFC BIProposed | 1 Replies | 90 Views | Created by VWFC_BI - Thursday, November 23, 2017 10:32 AM | Last reply by Dan Guzman - Thursday, November 23, 2017 10:53 AM -
0 Votes
Creating logon triggers
Hello! https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers Does ROLLBACK in the trigger's body mean ROLLBACK ...Answered | 5 Replies | 160 Views | Created by MF47 - Thursday, November 02, 2017 1:51 PM | Last reply by MF47 - Friday, November 10, 2017 1:59 PM -
0 Votes
Repair a corrupt SQL database in SQL 2005
My server crashed. most stuff lost. I recovered the .mdf .ldf files through DaRT. I can not use the files. It advises that the header is corrupt. Please advise what the best way to resolve ...Answered | 4 Replies | 1640 Views | Created by jackmorgan - Sunday, September 06, 2015 10:51 AM | Last reply by - Wednesday, November 08, 2017 9:11 AM -
10 Votes
difference between Non-repeatable read and Phantom read
Can anyone tell me the difference between Non-repeatable read and Phantom read ? I am completely mixed up and I have to know the difference as soon as possible . From BOL: ...Answered | 9 Replies | 55363 Views | Created by Yousef Ekhtiari - Wednesday, February 10, 2010 8:20 PM | Last reply by Zahid_Khan - Monday, October 30, 2017 2:22 PM -
0 Votes
WaitOnConsumer in mode: 2 by consumer: NNNNN in DB: NN with result: 2.- Error on SQL Server 2014.s
Hi, We intermittently see the below errors on one of our SQL 2014 server: WaitOnConsumer in mode: 2 by consumer: NNNNN in DB: NN with result: 2. These errors are ...Unanswered | 2 Replies | 407 Views | Created by Deepak Prasad Sahu - Thursday, July 20, 2017 4:12 AM | Last reply by Deepak Prasad Sahu - Monday, October 23, 2017 5:47 AM -
0 Votes
I need to file a xbox live complaint imediately
how do I file acomplaint using a pc or do u have a phone number I can callDiscussion | 1 Replies | 147 Views | Created by nay deverna - Sunday, October 22, 2017 3:16 PM | Last reply by Luigi Bruno - Sunday, October 22, 2017 3:33 PM -
1 Votes
Does sp_dropextendedproc drop both system-defined and user-defined extended stored procedures?
I'm a student and the SQL Server 2016 documentation that I'm going through is not very clear. And the online help I think it refers to SQL Server ...Answered | 3 Replies | 249 Views | Created by Black Hussle - Tuesday, October 03, 2017 2:34 PM | Last reply by Lin Leng - Monday, October 09, 2017 2:15 AM -
3 Votes
How to select row with group into 2 specific values by Descending order?
Hello, I would like to select queries a table with group by only 2 value in specific field. Like example bellow. I have a table that normally ...Answered | 2 Replies | 232 Views | Created by Mafullah - Sunday, October 08, 2017 9:06 AM | Last reply by Ousama EL HOR - Sunday, October 08, 2017 11:15 AM -
1 Votes
Declining support
A couple of years ago Microsoft only supported SQL backups that were made by SQL itself. In case of a problem during restore of a SQL backup made by a non-Microsoft backup ...Proposed | 1 Replies | 206 Views | Created by Flying Butcher - Thursday, October 05, 2017 8:01 AM | Last reply by Olaf Helper - Thursday, October 05, 2017 8:07 AM -
0 Votes
Upgrade from SQL Server 2008 R2 Workgroup eidtion to SQL Server 2008 R2 Standard edition
I am using sql server 2008 R2 workgroup edition. I have multiple databases related to live websites. While upgrading to standard editions- ...Proposed | 3 Replies | 267 Views | Created by Kushwaha Sushil - Wednesday, September 27, 2017 12:08 PM | Last reply by Kapil.Kumawat - Thursday, September 28, 2017 8:40 AM -
1 Votes
Bugs | Errors in the official Microsoft learning product (Course 20762B)
Hello, I am preparing for the exam (Course 20762B) and found some errors in the text/example/code. Where could I report that?Proposed | 1 Replies | 284 Views | Created by Dmitrij Kultasev - Thursday, September 21, 2017 7:16 AM | Last reply by Lin Leng - Tuesday, September 26, 2017 6:35 AM -
0 Votes
conección sql
no me conecta; Error no se pudo abrir una conexión con SQL ServerDiscussion | 1 Replies | 248 Views | Created by Hernandez_Castro - Saturday, September 23, 2017 1:31 AM | Last reply by Olaf Helper - Saturday, September 23, 2017 1:47 AM -
0 Votes
conección sql
no me conecta; Error no se pudo abrir una conexión con SQL ServerDiscussion | 1 Replies | 247 Views | Created by Hernandez_Castro - Saturday, September 23, 2017 12:59 AM | Last reply by Olaf Helper - Saturday, September 23, 2017 1:45 AM -
0 Votes
Details of all clercks
Hi I search a document to get all behaviour and detail of clercks (column type of DMV : sys.dm_os_memory_clercks). I want the definition, to understand the ...Answered | 7 Replies | 285 Views | Created by Grégory_Nail - Tuesday, September 19, 2017 10:22 AM | Last reply by Shanky_621 - Wednesday, September 20, 2017 9:36 AM -
0 Votes
FactOrder in AdventureWorksDW?
Hi experts, How come there is not a FactOrder table in AdventureWorksDW? Per my understanding SalesOrderDetail and SalesOrderHeader are the ...Proposed | 1 Replies | 309 Views | Created by maca128 - Wednesday, September 13, 2017 11:12 AM | Last reply by Lin Leng - Thursday, September 14, 2017 5:48 AM -
0 Votes
“Sales.SalesOrder” table?
Hi experts, In the guide ‘Applied MS BI’, it says: I have never seen this “Sales.SalesOrder” ...Answered | 1 Replies | 285 Views | Created by maca128 - Wednesday, September 13, 2017 8:41 AM | Last reply by Lin Leng - Wednesday, September 13, 2017 9:28 AM -
0 Votes
How to start SQL server in single user mode in linux
Hi Can someone please guide me how to start SQL server in single user mode on Linux?Proposed | 1 Replies | 328 Views | Created by sks198117 - Tuesday, September 12, 2017 6:07 PM | Last reply by Teige Gao - Wednesday, September 13, 2017 8:27 AM -
0 Votes
SQL Server 2012 Developer Availability
Is there a published availability date? I am still waiting for my copy from a major online merchandise vendor. Thanks. Kalman Toth ...Answered | 4 Replies | 7624 Views | Created by Kalman Toth - Monday, May 14, 2012 10:08 PM | Last reply by MM.MM - Wednesday, August 30, 2017 1:46 PM -
0 Votes
Is it possible to print View Diagrams
I wanted to know if there are anyways to print Diagrams from a view? I do not see anything from the menu and do not want to do screen captures so is there another way.Unanswered | 2 Replies | 367 Views | Created by Print View diagrams - Tuesday, August 22, 2017 3:33 PM | Last reply by KevinBHill - Tuesday, August 22, 2017 6:37 PM -
0 Votes
Logging SQL Server service activity
SQL Server logs errors, some startup and backup information to the ERRORLOG. But my company has released a new version of our software (very mature software) to multiple sites, ...Proposed | 6 Replies | 519 Views | Created by GregJF - Wednesday, August 02, 2017 2:43 AM | Last reply by Erland Sommarskog - Friday, August 18, 2017 9:30 PM - Items 1 to 20 of 993 Next ›
No announcements
