Question: how to use Microsoft SQL. Using the Microsoft flavor I need help with something to show a list of all databases I have. This list

how to use Microsoft SQL. Using the Microsoft flavor I need help with something to show a list of all databases I have. This list needs to display three things for every file 1) File Name 2) File Location 3) file size (as listed in the database_files catalog view without conversion.

But the catch to that is I need to somehow limit the display to only show files greater than or equal to size 1024.

What I have come up with so far is this:

select

DB_NAME(database_id) AS DatabaseName,

size

FROM sys.master_files

Which shows me the name & the size, but it shows every file not just those of size 1024 or greater & it only shows me the name & size not the location.

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 Algorithms Questions!

DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...

(i) Write down the linear program relaxation for the vertex cover problem and solve the linear program. [6 marks] (ii) Based on the solution of the linear program in (b)(i), derive an integer...

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

For the exclusive use of F. Ortolano, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

For the exclusive use of S. Setiawan, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

1. Analyze the article Remember to use the analysis tools in your writing ask yourself after reading the article "so what?" and "why is this important?" *** Article: Marketing is important to every...

OPERATIONS MANAGEMENT ASSIGNMENT 6 1 Human resources, project management and operations management are all equally vital to a business's success. Each of these focuses on different areas of the...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

Multiple-Choice Questions 1. When noninterest-bearing bonds are issued, the discount is a. Disregarded for financial reporting purposes. b. Expensed immediately. c. Amortized to interest expense each...

1. How, specifically, is the process of attribution illustrated in this case? 2. What do you suppose is being done to help train people to be friendlier toward customers? In other words, what would...

dentify the accounts that are impacted for the following events: o Held - to - maturity ( HTM ) bond investment Purchase of a held - to - maturity bond instrument Interest revenue from a held - to -...

Which of the following statements is correct? (A) If 0.1M CH3COOH aqueous solution (K. = 1.8 x 10-5) is diluted at 25C, then [H*]will increase. (B) On heating a sample of pure water PKu increases (C)...

| Family Games, Inc., is a privately-owned company with annual sales from a variety of wholesome electronic games that are designed for use by the entire family. The company sees itself as...

academic writing and professional writing Task II - Revise the following vague or general thesis statements so that each makes a point that could be developed in a three paragraph essay. Life today...

Consider a 3% coupon Treasury bond with exactly one year to maturity and a facevalue of $1,000. Coupons are paid semi-annually. The 1-year rate on the yield curve is quoted as 2% APR, compounded...

Let L sin 0 = 10 + log sin 0. The number of triangles ABC, such that log b + 10 = log e+L sin B is: (A) One (B) Two (C) Infinite (D) zero

Modify the zip code on order 1017 to 33222.

Execute a command that undoes the previous deletion.

Which of the following is a valid SQL statement? a. SELECT * WHERE amid = J100 FOR UPDATE; b. INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager); c. DELETE amid FROM acctmanager; d. rollback;...

What is the net benefit obligation (asset)? How is the net benefit obligation (asset) reported in the financial statements?

Sarah is a finance major who has only taken one accounting course. She asserts that pension remeasurements, like many other accounting adjustments, are recorded in net income. Is Sarah correct?...

Adler AG, which began operations at the beginning of 2017, produces various products on a contract basis. Each contract generates income of 80,000. Some of Adler's contracts provide for the customer...