Question: need to convert the sys.master_files size column into GB . Currently when I run select name,size from sys.master_files I get back the file size as

need to convert the sys.master_files size column into GB. Currently when I run select name,size from sys.master_files I get back the file size as KB. I've tried doing something - size/1024/1024 - but I'm getting incorrect results.

How do I get the current sys.master_files size unit into the GB format?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Healthy Life Co. is an HMO for businesses in the Fresno area. The following account balances appear on Healthy Life's balance sheet: Common stock (1,000,000 shares authorized; 500,000 shares issued),...

Find attached Ingredients: Water, MCC, Salt, Nicotine, pH regulator, sweeteners and flavours I am wondering why the decision to go with LYFT. I understand migrating to LYFT would be easier from sells...

Need script to do sentimental analysis in python for amazon review data Here is the dataset text ## I purchased this monitor because of budgetary concerns . inexpensive[+1][a] ## This item was the...

Could I get the cost of capital calculation (WACC) broken out in excel for Amazon based on FY2015 financials? \fTo our shareowners: This year, Amazon became the fastest company ever to reach $100...

Hi, I have areport due in nine hours. I need to find the following list of things on Amazon.com....

Case study: Remedy Physiotherapy. I need help in drafting a marketing plan Names of people and businesses are disguised. Some aspects of the local area and the physiotherapy industry are simplified...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

will require integrating human resource management theory and thought (as described in the textbook) while addressing major issues in the field and therefore will require proper referencing and...

Based on the reading of the case, carefully explore the following questions faced by Salsgiver (pg. 1): 1. How many of Arrow's customers were likely to switch some of their purchases to Express? (Use...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

For this programming assignment you will write a recursive algorithm to display the contents of a directory in a computers file system. You will also get a little experience using the API...

What is self-efficacy? Why is it important to make the distinction that self-efficacy is a state rather than a trait? What implications does this have for the workplace?

A venturi meter is a device to measure fluid flow rates, which in its operation resembles the orifice meter (Section 3.2b). It consists of a tapered Constriction in a line, with pressure taps leading...

Assume Lavender Corporation has a market value of $ 1 8 billion of equity and a market value of $ 1 9 . 1 billion of debt. What are the weights in equity and debt that are used for calculating the...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Discuss the types of new technologies that can improve the efficiency and effectiveness of HRM. page 683

Consider this scenario: you have a vacancy that you know can be fi lled internally by a suitable candidate but they may not be interested. Is it ethical to try to encourage them to apply and, if so,...

The move to devolve human resource management to line managers has advantages and diffi culties. Set out a case for and against in the example of recruitment and selection.