[MS SQL Server] MAXDOP question |
| Posted: 13 Sep 2013 06:13 AM PDT The computer that i run queries on has 2 processors. Shouldn't query1 execute faster than query2 ? Surprisingly, both executed taking exact time. Also, on OLTP system, should MAXDOP be disabled or should I leave it as default setting?Query1:SELECT * FROM tableUNIONSELECT * FROM table1Query2:SELECT * FROM tableUNIONSELECT * FROM table1OPTION (MAXDOP 1)Query1 was using parallelism in the execution plan. |
| Job failed - [298] SQLServer Error: 15404 Posted: 20 Mar 2012 07:01 PM PDT [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'domain\domain user', error code 0xffff0002. [SQLSTATE 42000] (ConnIsLoginSysAdmin)This is the error log. Please help me if you have the same issue. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment