Anusha Acharya

OPENROWSET shutting down SQL Server service, but only running on the server

OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server's BULK import capability. Go check your provider (Microsoft.ACE.OLEDB.12.0) settings in SSMS. Server Objects -> Linked Servers -> Providers -> Microsoft.ACE.OLEDB.12.0 -> Properties If "Allow in-process" is…

Salesforce

Answered Apr 22, 2021 · 2.4K Views Read answer →

How to determine the size of my tables in the SQL Server database?

For SQL server show tables, you can use sp_spaceused MyTable For all tables in a database, you can use it with sp_msforeachtable as followingCREATE TABLE #temp ( table_name sysname , row_count INT, reserved_size VARCHAR(50), data_size VARCHAR(50), index_size VARCHAR(50), unused_size VARCHAR(50)) SET NOCOUNT ON INSERT…

SQL Server

Answered Apr 22, 2021 · 1.3K Views Read answer →

Are you facing Unexpected Token ERROR?

Please copy and paste your code into your question and use the {} tool or Ctrl-K to format it appropriately as code if you are facing an unexpected token. Screenshots are generally harder to work with. In this case, you have two simple syntax errors:public Map oppMapMethod { This method declaration is missing its…

Salesforce

Answered Apr 22, 2021 · 5.2K Views Read answer →

How to create a database diagram for SQL Azure without having to install SQL Server?

SQL Azure databases do not support diagrams in the same way 'normal' on premise SQL Servers do, so you are looking at workarounds or third-party tools. For example, you could install SQL Server Data Tools (SSDT), pull your model down, deploy to a local 'normal' dev server, create the diagram there. This would not…

SQL Server

Answered Apr 16, 2021 · 733 Views Read answer →

What is the easiest way of oracle to sql server migration?

Here are the step to follow oracle to sql server migration:Create a new SSMA project. Connect to the Oracle database server. Connect to an instance of SQL Server. Map Oracle database schemas to SQL Server database schemas.I actually used the "Microsoft SQL Server Migration Assistant (SSMA)"

SQL Server

Answered Apr 16, 2021 · 536 Views Read answer →

How can the Euclidean distance be calculated with NumPy?

To calculate numpy euclidean distance you can use numpy.linalg.norm: numpy.linalg.norm(x, ord=None, axis=None, keepdims=False):- It is a function which is able to return one of eight various matrix norms, or one of an infinite number of vector norms, depending on the value of the ord parameter. You can use the…

Python

Answered Apr 10, 2021 · 1.6K Views Read answer →

remove legend title in ggplot

To remove legend title in ggplot, you can follow the below line to your plot: theme(legend.title=element_blank()) i.e., ggplot(df, aes(x, y, colour=g)) + geom_line(stat="identity") + theme(legend.position="bottom") + theme(legend.title=element_blank()) Output:

Data Science

Answered Apr 10, 2021 · 387 Views Read answer →

Which of the following is a fundamental category of business intelligence (BI) analysis?

The correct answer for which of the following is a fundamental category of business intelligence (bi) analysis? is Data Mining. BI analysis deals with collaborating, cleaning, organizing, relating, and cataloging of the business data. The three fundamental categories of BI analysis are: Reporting Data mining BigData…

Business Intelligence

Answered Apr 10, 2021 · 1.7K Views Read answer →

Selecting multiple columns in a pandas dataframe

In pandas, you can select multiple column pandas by their name, but the column name gets stored as a list of the list that means a dictionary. It means you should use [ [ ] ] to pass the selected name of columns. This method df[['a','b']] produces a copy. For example: df1 = df[['a','b']]You can also use ‘.iloc’ method…

Data Science

Answered Apr 9, 2021 · 1.9K Views Read answer →

Which of the following choices is a way that big data and data science can help today’s marketer?

The correct options for which of the following choices is a way that big data and data science can help today’s marketer? are an option (A), (B), (C). Big data analytics are used in marketing and sales by the organizations in pricing strategies according to the pricing of similar products in the market. Big data and…

Big Data Hadoop

Answered Apr 9, 2021 · 807 Views Read answer →

How do I check if a variable exists?

To solve python check if a variable exists you should follow the below-method varies with the type of variable. 1. If you want to check the existence of a local variable use: if 'yourVar' in locals(): # yourVar exists.2.if you want to check the existence of a global variable use: if 'yourVar' in globals(): # yourVar…

Python

Answered Apr 7, 2021 · 460 Views Read answer →

Using Caret Package but Getting Error in library(e1071)

To remove error: package e1071 is required, you need to install the package e1071, as the error message is describing. install.packages('e1071', dependencies=TRUE)

Data Science

Answered Apr 7, 2021 · 906 Views Read answer →