[SQL 2012] Suggestions for SQL 2012 BI Training |
- Suggestions for SQL 2012 BI Training
- Stored procedure running manually whereas not executing successfully through SQL JOB:
- Master Data Services
- unable to log into SQL Server Management Studio
- always on solution
- SP / TABLE NAME
- Need to see the value of set option NUMERIC_ROUNDABORT for all the sessions
- Reindexing on 2012 Availability groups
- Date time problem
| Suggestions for SQL 2012 BI Training Posted: 22 Jul 2013 07:45 AM PDT We're looking for a training class to get us started with SQL 2012 BI. We hope to find a class with a comprehensive overview on BI. Does anyone have any suggestions? It doesn't need to be a certification class, it's more important to get the overview of BI. I'm hoping a class like that exists. |
| Stored procedure running manually whereas not executing successfully through SQL JOB: Posted: 22 Jul 2013 09:03 PM PDT Hi,I have a job which runs every week which archieves records in to another database. When i run the SP in the query window it takes hardly 15 mins where as when i run the same through JOb it is not completing successfully for more than 15 hrs . So i need to manually stop the job every week. There are two step,first oe 1) Archieve2) Re-index.I checked possible solns and everything is fine such as 1) Permission issues(Job owner is Sysadmin)2)Blocking(No blocking when the Job run's)3)No clash in schedule Jobs'. Can anyone help if possible in this issue. |
| Posted: 23 Jul 2013 02:08 AM PDT Hi allI am trying to add a user in MDS however I just keep getting an error of:No exact match was found for domain\userIf I just put in the user and click the Check Name button it changes it to domain\user but for whatever reason I can't add the user.Any ideas?Thanks |
| unable to log into SQL Server Management Studio Posted: 23 Jul 2013 01:24 AM PDT I literrally just took over a project from a contract that when he left he changed the sa password and the auth process for the SQL server. No one knows the sa password and its now only setup for SQL Auth instead of mixed mode. Is there a way to log into the SQL server adn fix everything? We have several sharepoint databases and other databases on this server that we need to get to and we're unable to do so.[this is 1 of many things the contractor did on his last day that i'm trying to fix and get working again. :( ] |
| Posted: 23 Jul 2013 01:13 AM PDT In Always on would it be possible to have both an Active/Passive cluster and another Active cluster used for reporting? |
| Posted: 22 Jul 2013 09:59 PM PDT Hi,Can a table and an SP in the same schema have the same name please?Thanks |
| Need to see the value of set option NUMERIC_ROUNDABORT for all the sessions Posted: 22 Jul 2013 04:08 AM PDT Hi all I have a database that I want to add filtered index to it. While working with filtered index there are some set options that must be used by all the clients. If some of them won't be using the required set options, they won't be able to modify the data in the table that has the filtered index. In order to check if we have any clients that don't use the needed set options, I wanted to have a job that checks the sessions' set options in sys.dm_exec_sessions and if it finds problematic sessions, it will write there details into a log table. The problem is that sys.dm_exec_sessions don't have any information about NUMERIC_ROUNDABORT option. The function sessionproperty can show the setting of NUMERIC_ROUNDABORT only for the session that is running the function. Can anyone tell me how can I find out this setting for all the sessions?Thank you for your help.Adi |
| Reindexing on 2012 Availability groups Posted: 22 Jul 2013 06:23 PM PDT We have databases setup in availability group, recently we had to do an rebuild few indexes as they were fragmented. The index size was 12GB+. Rebuilding index started to consume more log space, I increased the disk space about nearly 50GB and still it was not completed. I understand the log will grow during rebuild of indexes, these changes are hardened on the secondary replica database.I saw blocking issues with HADR_COMMIT_SYNC wait type. Are there any guidelines of rebuilding indexes in the availability group? Please share..Using Online option to rebuild the index |
| Posted: 22 Jul 2013 10:46 AM PDT Hi ProfessionalsI have a column within my database table called todays_date this is Datetime and in the format2013-07-23 08:55:59:353is the a way to update or alter the table so it is in the format23/07/2013 onlythanks in advance |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General 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