HACCP Questions and Answers, cooking questions and answers.#Cooking #questions #and #answers

cooking questions and answers

Cooking questions and answers

HACCP Questions and Answers

HACCP, or the Hazard Analysis Critical Control Point system, is a process control system that identifies where hazards might occur in the food production process and puts into place stringent actions to take to prevent the hazards from occurring. By strictly monitoring and controlling each step of the process, there is less chance for hazards to occur.

HACCP is important because it prioritizes and controls potential hazards in food production. By controlling major food risks, such as microbiological, chemical and physical contaminants, the industry can better assure consumers that its products are as safe as good science and technology allows. By reducing foodborne hazards, public health protection is strengthened.

While many public opinion studies report that consumers are concerned primarily about chemical residues, such as from pesticides and antibiotics, these hazards are nearly non-existent. The more significant hazards facing the food industry today are microbiological contaminants, such as Salmonella, E. coli O157:H7, Listeria, Campylobacter, and Clostridium botulinum. HACCP is designed to focus on and control the most significant hazards.

HACCP is not new. It was first used in the 1960s by the Pillsbury Company to produce the safest and highest quality food possible for astronauts in the space program. The National Academy of Sciences, National Advisory Committee for Mcirobiological Criteria for Foods, and the Codex Alimentarius have endorsed HACCP as the best process control system available today.

The current food inspection program is based on a see, smell and touch approach that relies more on detection of potential hazards than prevention. Furthermore, the current inspection program was designed in the 1930s when the threat of diseased animals and physical contaminants were the main concerns. Today, microbiological and chemical contamination, which cannot be seen, are of greater interest. The U.S. Department of Agriculture recently mandated HACCP for the nation’s 7,000 meat and poultry plants.

Many of the nation’s meat and poultry processing facilities have implemented some or all of the HACCP principles into their operations. Many companies have also provided HACCP training to management and in-plant workforce.

USDA is pursuing a farm to table approach to food safety by taking steps to improve the safety of meat and poultry at each step in the food production, processing, distribution and marketing chain. On July 25, 1996, USDA released its Pathogen Reduction/HACCP final rule. The final rule will further target pathogens that cause foodborne illness, strengthen industry responsibility to produce safe food, and focus inspection and plant activities on prevention objectives. The final rule covers three major areas:

Sanitation Standard Operating Procedures

Hazard Analysis Critical Control Point (HACCP) system

There are seven principles, developed by the National Advisory Committee on Microbiological Criteria for Foods, that serve as the foundation for a HACCP system. They are:

Microbiological testing can play a valuable role in HACCP programs as a means for verifying the HACCP system is working properly and to track trends and profiles of products. By tracking microbiological data, plants can identify when the production process is not being properly controlled or verify that prevention efforts are successfully reducing bacterial levels. End-product microbiological testing, however, is less effective. There is not sufficient data to determine what is considered an acceptable level of bacteria on raw meat and poultry, so an end-product test will not provide useful data, other than for trends analysis. While end-product testing may indicate bacteria are present, it does not solve the problem of identifying and eliminating contamination.

New technologies will play critical roles in HACCP programs since HACCP is designed to institute practices that reduce or eliminate harmful contamination. If new technologies are developed that prevent or eliminate hazards throughout the production process, they will be widely accepted and adopted. The industry has studied several new technologies and petitioned USDA to approve them for use.

There are seven HACCP principles that must be followed to implement HACCP. Every food production process in a plant will need an individual HACCP plan that directly impacts the specifics of the product and process. Government and industry groups are developing some generic HACCP models that provide guidelines and directions for developing plant-, process- and product-specific HACCP systems. The International Meat and Poultry HACCP Alliance has developed training curriculum to assist the meat and poultry industry.

For the most successful implementation of HACCP, it should be applied from farm to table — starting on the farm and ending with the individual preparing the food, whether in a restaurant or home. On the farm, there are actions that can be taken to prevent contamination from occurring, such as monitoring feed, maintaining farm sanitation, and practicing good animal health management practices.

FSIS plans to work with the Food and Drug Administration and state and local governments to begin to implement HACCP in the distribution and retail sectors. FSIS intends to work with FDA to develop federal standards for safe handling of food during transportation, distribution and storage prior to delivery to retail stores. Also, FSIS will work with FDA to provide food safety guidance to retail stores through the updated Food Code. The Food Code is a model ordinance intended to serve as a guide for state and local authorities. Following proper sanitation and handling guidelines will help ensure that further contamination and cross contamination do not occur.

Consumers can implement HACCP-like practices in the home by following proper storage, handling, cooking and cleaning procedures. From the time a consumer purchases meat or poultry from the grocery store to the time they cook and serve a meal, there are many steps to take to ensure food safety. Examples include properly refrigerating meat and poultry, keeping raw meat and poultry separate form cooked and ready-to-eat foods, thoroughly cooking meat and poultry, and refrigerating and cooking leftovers to prevent bacterial growth.

Magazine Subscriptions and Current Issues – Cooking Light, cooking questions and answers.#Cooking


Cooking questions and answers

Cooking Light magazine content and web-exclusive features for the December 2017 issue

Give the gift of a Cooking Light magazine subscription

Learn all about Cooking Light

Find contact information for magazine and online inquiries.

Frequently Asked Questions

Find answers to some of our frequently asked questions.

Cooking Light magazine content and web-exclusive features for the December 2017 issue

Cooking Light magazine content and web-exclusive features for the November 2017 issue

Alice Waters, founder of the seminal California restaurant Chez Panisse, dishes on her new memoir, Coming to My Senses, and shares her ideas on good food and an edible education with Editor-in-Chief Hunter Lewis.

Cooking Light magazine content and web-exclusive features for the October 2017 issue

Cooking Light magazine content and web-exclusive features for the September 2017 issue

Cooking Light magazine content and web-exclusive features for the August 2017 issue

Cooking Light magazine content and web-exclusive features for the July 2017 issue

Cooking Light magazine content and web-exclusive features for the June 2017 issue

Cooking Light magazine content and web-exclusive features for the May 2017 issue

Cooking Light magazine content and web-exclusive features for the April 2017 issue

Questions and Answers, cooking questions and answers.#Cooking #questions #and #answers

cooking questions and answers

Cooking questions and answers

Human Body

Insulin is a sort of hormone which secreted from the pancreatic cells. Two types of cells can be found in the pancreas. These are the alpha cells and the beta cells. The beta cells are responsible for secretion of insulin. High glucose levels in the blood excite the pancreas beta .


Many species of wall lizards can be found across the world and across continents such as North America, South America, Europe, Asia and Australia. It has been estimated that over 25000 types of lizards have been found so far by the scientists. Almost all wall lizards have an extra ordinary .


Blackhead is a small bump on your skin. It is caused due to the oily skin, whereas whitehead is caused due to both oily and dry skin. There are millions of tiny pores in our skin. Many times the dead skin cells and excess oil produced by our skin clog .


Glow sticks are plastic tubes containing chemical substances that are isolated and that produce light due to a chemical reaction. There are several patents for glow sticks and the earliest ones dates back to June 1965 which lists Eugene Daniel Guth and Bernard Dubrow as inventors of glow stick. However .


Do you enjoy knowing more about the mysteries of the universe? A lot of people debate about whether the universe is something that was created by the God Himself, or it is just a creation that happened with the passing of the time. Many people believe and even debate that .


The floppy disc was invented by IBM as a storage device and they were made available in the market in 1971. The main aim of this invention was to save files in a portable storage device so that it can be viewed and used on multiple computers. The initial floppy .


If we are talking about some of the most contagious diseases in the world then we have to talk about chickenpox, which is highly contagious and can spread quickly through cough and sneezes of a person. Hence, a lot of precaution has to be taken while handling problems like chickenpox. .


Fire can be a good servant but a bad master and therefore, we should always be careful while handing fire because it can create a lot of damage if we take it very lightly. Over many years, fire has caused a great deal of damage to the human life and .

Gunpowder is a mixture of potassium nitrate, sulfur, charcoal and saltpeter and has excellent burning properties. Gunpowder is also known for the huge amount of gas and heat it generates when burned. Chinese were the first to invent and use gun powder. Initially it was used as a medicine and .

Glow sticks are plastic tubes containing chemical substances that are isolated and that produce light due to a chemical reaction. There are several patents for glow sticks and the earliest ones dates back to June 1965 which lists Eugene Daniel Guth and Bernard Dubrow as inventors of glow stick. However .

Fire extinguishers are hand held protection devices that are used to control small fires as well as extinguish them. Ambrose Godfrey a popular chemist invented the first fire extinguisher in 1723 in England. This extinguisher constituted of a liquid that extinguished fire, and a pewter chamber filled with gunpowder. .

Who invented Ferris wheel? The Ferris wheel was invented by George Washington Gale Ferris in 1893. Originally a bridge builder he designed and constructed the first Ferris wheel as a landmark for the World’s Columbian Exposition in Chicago. A Ferris wheel which is also called as a big wheel .

There are some chemicals that are normally used in the preparation of different other chemicals and Chlorobenzene is just one of them. It is a kind of aromatic organic compound that is used in different kinds of industries so that they can derive some other chemicals by mixing it with .

We all know that chlorine is an oxidant which is normally used for bleaching purpose. However, there are various different uses of chlorine that we are unaware about. If you are looking for a simple definition of chlorine then chlorine is a kind of chemical element that is used in .

Free Printable General Science Trivia Questions and Answers, cooking questions and answers.#Cooking

Trivia Playing

Cooking questions and answers

Q: What process involves treating rubber with sulfur to harden it?

Q: What scale of zero to 14 is used to measure acidity or alkalinity?

Q: What O-word describes oxygen with molecules that have three atoms instead of two?

Q: What unit of electrical power is equal to one joule per second?

Q: What planet is closest in size to our moon?

Q: What’s the common name for a cubic decimeter?

Q: What measure of energy comes from the Latin word meaning “heat”?

Q: What’s removed from water in the process of desalination?

Q: What species Amazonian electric variety packs a 650 volt wallop?

Q: What C word defines a substance that speeds a chemical reaction without being consumed?

Q: What’s the base unit of mass in the metric system?

Q: What cooking fuel is produced by heating wood without oxygen?

Q: What’s the only metal that’s not a solid at room temperature?

Q: Which will yield the most BTUs of energy–a gallon of oil, a pound of coal or a gallon of gasoline?

A: A gallon of oil.

Q: What unit of measure do you multiply by .39 to convert it to inches?

Q: What method of underwater detection is short for “sound navigation and ranging”?

Q: What hazardous substance is euphemistically referred to as “mineral fiber”?

Q: What color does litmus turn when dipped into acid?

Q: What process involves heating an ore to obtain a metal?

Q: What’s the U. S. equivalent of 0.45 kilograms?

Q: What’s defined as the distance between a lens and its focal point?

A: It’s focal length.

Q: What energy unit is defined as the heat required to raise one kilogram of water by one degree Celsius?

Q: What founding father was knocked unconscious while attempting to electrocute a turkey?

A: Benjamin Franklin..

Q: What continent is subjected to the world’s largest ozone hole?

Q: What sea creature can have an eye measuring 16 inches across, the largest in the animal kingdom?

Q: What explosive cosmic event was seen with the naked eye in 1987, for the first time in 383 years?

Q: What three terms are represented in Newton’s second law of motion F = ma?

A: Force, mass, acceleration.

Q: How many of the nine planets have moons/

Q: What were exterminated from Harvard’s bio labs when they were found to be carrying radioactive chemicals into the walls?

Q: What type of trees yield the resin used to produce turpentine?

Questions and Answers Regarding Open Burning – NYS Dept, cooking questions and

Department of Environmental Conservation

Cooking questions and answers

Questions and Answers Regarding Open Burning

1. Do the regulations on open burning make burning household trash in burn barrels or piles illegal?

Yes. Burning trash is prohibited statewide in all cases. Our existing incinerator rule already prohibits burning household trash in wood stoves, fireplaces, and outdoor wood boilers. DEC recommends that you recycle all appropriate materials (such as newspaper, paper, glass and plastic) and compost your organic kitchen and garden waste.

2. What are the regulations on open burning in New York State?

All open burning is prohibited in New York with several exceptions including the following:

  • Campfires less than 3 feet in height and 4 feet in length, width or diameter are allowed.
  • Small cooking fires are allowed.
  • Fires cannot be left unattended and must be fully extinguished.
  • Only charcoal or clean, untreated or unpainted wood can be burned.
  • Ceremonial or celebratory bonfires are allowed.

In towns with a total population less than 20,000, you may burn tree limbs with attached leaves. The limbs must be less than 6 inches in diameter and 8 feet in length (also referred to as brush). However, this is not allowed from March 16 through May 14 due to the increased risk of wildfires.

See Section 215.3 (link leaves DEC s website) for a full list of exceptions.

3. Why has DEC changed the regulations allowing open burning in New York State?

Open burning of household trash releases dangerous compounds including arsenic, carbon monoxide, benzene, styrene, formaldehyde, lead, hydrogen cyanide and dioxin, among others. Open burning is also the single greatest cause of wildfires in New York.

4. Can I burn leaves if I live in a rural area?

No, burning leaves is banned in New York State. We encourage you to compost leaves.

5. Your rule says firewood must be untreated, some firewood is heat-treated, is that allowed?

Some firewood is heat treated (kiln dried) to control invasive insect species if it is to be transported over 50 miles. Heat treated firewood is not intended to be prohibited. However, the burning of chemically treated wood such as pressure-treated lumber and plywood is prohibited.

6. Are open fires allowed to control invasive plant and insect species?

Yes. Case-by-case DEC approval is not required.

7. Can agricultural wastes be burned?

Yes, organic agricultural wastes may be burned on-site where they are grown or generated including brush and wood produced by clearing fields and other activities. The fire must be located on contiguous agricultural land larger than 5 acres, and the materials capable of being fully burned within 24 hours.

The burning of pesticides, plastics or other non-organic material is prohibited.

8. Can I burn liquid petroleum fueled smudge pots to prevent frost damage to crops?

Yes. However, burning tires and other wastes for smudge is not allowed.

9. Can prescribed burns be performed?

Yes. Prescribed burns, the burning of forest land to achieve a vegetative or wildlife management goal, can be performed but only in accordance with DEC regulations. Check with your regional DEC office.

10. Are fire training burning activities allowed?

Yes, with some restrictions on the use of acquired structures and in accordance with guidance from NYS Dept. of State s Office of Fire Prevention and Control. The Fire Services Bureau may be reached at 518-474-6746.

11. Are individual open fires to control plant and animal disease outbreaks allowed?

Yes, as approved case-by-case by DEC, upon the request by the Commissioner of Agriculture and Markets.

12. Can I dispose of a flag or religious item in an open fire?

Yes, in a small-sized fire if it is not otherwise prohibited by law or regulation.

13. Are permits for open fires still required in some parts of the state?

Yes. While a permit is not required under this regulation, the Environmental Conservation Law (ECL) still requires that a permit be obtained from the Department if you plan to burn brush under the exception and you live in a town which is totally or partially located within the boundaries of the Adirondack and Catskill Parks which is designated as a Fire Town under the ECL (see list below). In addition, any local requirements or restrictions would apply.

  • Clinton County, the towns of Altona, Ausable, Black Brook, Dannemora, Ellenburg and Saranac;
  • Delaware County, the towns of Andes, Colchester, Hancock and Middletown;
  • Essex County, all towns
  • Franklin County, the towns of Altamont, Belmont, Brighton, Duane, Franklin, Harrietstown, Santa Clara and Waverly;
  • Fulton County, the towns of Bleecker, Caroga, Mayfield, Northampton and Stratford;
  • Greene County, the towns of Hunter, Jewitt, Lexington and Windham;
  • Hamilton County, all towns;
  • Herkimer County, the towns of Ohio, Russia, Salisbury and Webb;
  • Lewis County, the towns of Crogham, Diana, Grieg, Lyonsdale and Watson;
  • Oneida County, the towns of Forestport and Remsen;
  • Saratoga County, the towns of Corinth, Day, Edinburg and Hadley;
  • Saint Lawrence County, the towns of Clare, Clifton, Colton, Fine, Hopkinton, Parishville, Piercefield and Pitcairn;
  • Sullivan County, the towns of Neversink and Rockland;
  • Ulster County, the towns of Denning, Gardiner, Hardinburgh, Olive, Rochester, Shandaken, Shawangunk, Wawarsing and Woodstock;
  • Warren County, the towns of Bolton, Chester, Hague, Horicon, Johnsburgh, Lake George, Luzerne, Queensbury, Stoney Creek, Thurman and Warrensburgh;
  • Washington County, the towns of Dresden, Fort Ann and Putnam.

14. Can a town prohibit open burning that the state allows?

Yes, towns, villages, cities and counties can pass ordinances that are stricter than, and not inconsistent with, the open fires regulations. You should check with local authorities to find out if local law requires a permit or prohibits open fires.

15. Can explosives, or other dangerous contraband, be burned?

Yes, on an emergency basis by police or other public safety organizations only.

16. Can brush piles be burned at transfer sites?

No, the practice of burning large piles of brush collected from local residents at town or county transfer sites is prohibited. The individual landowners in small towns may burn their brush on site as discussed under question 2 above. Downed limbs and branches generated at a transfer site are also allowed to be burned on site with the same restrictions.

17. Where should I call to report an illegal open fire?

Report all poachers and polluters by calling the DEC hotline at 1-844-DEC-ECOs (1-844-332-3267).

The Department has received many questions regarding DEC s implementation of Part 215, regarding open fires. This document is intended to inform the general public about open fire regulation in New York and assist the regulated community in understanding the requirements of Part 215.

Help Center: Asking a Question on WikiAnswers, cooking questions and answers.#Cooking #questions

Asking a Question on WikiAnswers

Start at the green Ask bar at the top of any WikiAnswers page.

Cooking questions and answers

  1. Type in your question and click GO . See the Tips below for ways to get your question answered faster.
  2. Step 1: This step is optional. If your question is similar to an existing question, you will be presented with several options. If one of these questions is an exact match, or you are interested in seeing that question page, click the question.
  3. Step 2: Review your question wording, spelling, and capitalization.
  4. Optional: If you are logged in, the question will be automatically added to your watchlist, and you will be alerted when it receives an answer or is edited. If you do not want to add it, uncheck the box.
  5. Submit Question.
  6. Categorize your question.
  7. Click Save. You will automatically be taken to your question page to view your question.

Categorize your question:

Cooking questions and answers

You can place your question in up to three categories. Place it in the most specific categories possible; what you see is not what you get! There are thousands of categories and three ways to choose the right ones for your question:

  1. Search Categories : Start typing the name of the category you seek and a list will appear, narrowing as you spell out the category.
  2. Suggested Categories : These are automatically suggested based on the wording and context of your question. You can choose to check these off or not, based on relevancy.
  3. Browse Categories : Use the expandable category tree to find categories and subcategories that may be relevant.

Use these tips to help your question get answered more quickly.

  • Ask your question in the form of a question; not a statement.
    • Example: What is the meaning of happiness? instead of The meaning of happiness.”
  • Ask a complete question.
    • Example: What is the meaning of happiness? instead of Happiness?
  • Ask one question at a time.
    • Example: What is the meaning of happiness and how do you acquire it? is two separate questions: What is the meaning of happiness? and How do you acquire happiness?
  • Don’t use punctuation, such as commas or periods. The question mark at the end of your question will be inserted by the system after you click on Submit Question .
  • Do not add any personal details or dates in your question.
  • See the WikiAnswers Style Guide for more information on WikiAnswers style rules.

SQL – Difference between COALESCE and ISNULL? Stack Overflow, cooking questions answered.#Cooking

cooking questions answered

Get via App Store Read this post in our app!

SQL – Difference between COALESCE and ISNULL? [duplicate]

This question already has an answer here:

What are the practical differences between COALESCE() and ISNULL(,”)?

When avoiding NULL values in SQL concatenations, which one is the best to be used?

marked as duplicate by StingyJack, podiluska, StanislavL, bluefeet , Jerry Sep 16 ’13 at 14:56

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

4 Answers


The ISNULL function and the COALESCE expression have a similar purpose but can behave differently.

  1. Because ISNULL is a function, it is evaluated only once. As described above, the input values for the COALESCE expression can be evaluated multiple times.
  2. Data type determination of the resulting expression is different. ISNULL uses the data type of the first parameter, COALESCE follows the CASE expression rules and returns the data type of value with the highest precedence.
  3. The NULLability of the result expression is different for ISNULL and COALESCE. The ISNULL return value is always considered NOT NULLable (assuming the return value is a non-nullable one) whereas COALESCE with non-null parameters is considered to be NULL. So the expressions ISNULL(NULL, 1) and COALESCE(NULL, 1) although equivalent have different nullability values. This makes a difference if you are using these expressions in computed columns, creating key constraints or making the return value of a scalar UDF deterministic so that it can be indexed as shown in the following example.

Validations for ISNULL and COALESCE are also different. For example, a NULL value for ISNULL is converted to int whereas for COALESCE, you must provide a data type. ISNULL takes only 2 parameters whereas COALESCE takes a variable number of parameters.

Pork Cooking Chart, cooking questions answered.#Cooking #questions #answered

FRESH PORK: Safe Cooking Chart

(Formerly Chophouse and Roast Pork)

Spicecraft (Formerly F.W. Witt Seasonings).

This is a great seasoning for Pork Butt Roasts and Pork Chops!

Order 1 Jar of Spicecraft Roast Pork Chop Seasoning for only $11.97 by clicking on the Add To Cart button below. 3 Jars for ONLY $24.97!

Shipped FREE by USPS Mail!

Finally, Pork Doesn’t Have To Be As Tough As Leather.

WASHINGTON, May 24, 2011 – The U.S. Department of Agriculture (USDA) is updating its recommendation for safely cooking pork, steaks, roasts, and chops. USDA recommends cooking all whole cuts of meat to 145 °F as measured with a food thermometer placed in the thickest part of the meat, then allowing the meat to rest for three minutes before carving or consuming.

to use as a handy reference guide to ALL the beef cuts available!

at the Butcher Shop or Grocery Store Meat Department!

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Purchase A Set of 5 Notebook Size Meat Charts

For ONLY $7.00 by Clicking the Add To Cart Button Below. Shipped FREE in the U.S.!

We have a FREE PDF article on How To Use A Meat Thermometer . To view it, just click here.

Cooking questions answeredYou will need Adobe Acrobat Reader to view this file.

If don’t have it already on your computer,

you can download from the Adobe website by clicking here.

Cooking questions answered

This is a must for pig raisers! It’s that much of a needed book for pig farmers. Every subject you want to know about pigs is found in this book, from showing at the fair, breeding the pigs, to the business aspect of running a farm.

If you found this page interesting, you may also want to look at the following pages:

Get size of all tables in database – Stack Overflow, cooking questions

cooking questions answered

Cooking questions answered

If you are using SQL Server Management Studio (SSMS), instead of running a query (which in my case returned duplicate rows) you can run a standard report.

  1. Right click on the database
  2. Navigate to Reports > Standard Reports > Disk Usage By Table

Note: The database compatibility level must be set to 90 or above for this to work correctly. See http://msdn.microsoft.com/en-gb/library/bb510680.aspx

sp_spaceused can get you information on the disk space used by a table, indexed view, or the whole database.

This reports the disk usage information for the ContactInfo table.

To use this for all tables at once:

You can also get disk usage from within the right-click Standard Reports functionality of SQL Server. To get to this report, navigate from the server object in Object Explorer, move down to the Databases object, and then right-click any database. From the menu that appears, select Reports, then Standard Reports, and then “Disk Usage by Partition: [DatabaseName]”.

After some searching, I could not find an easy way to get information on all of the tables. There is a handy stored procedure named sp_spaceused that will return all of the space used by the database. If provided with a table name, it returns the space used by that table. However, the results returned by the stored procedure are not sortable, since the columns are character values.

The following script will generate the information I’m looking for.

For all tables ,use..(adding from the comments of Paul)

Cooking questions answered

Above queries are good for finding the amount of space used by the table (indexes included), but if you want to compare how much space is used by indexes on the table use this query:

If you need to calculate exactly the same numbers, that are on ‘table properties – storage’ page in SSMS, you need to count them with the same method as it done in SSMS (works for sql server 2005 and above . and also works correctly for tables with LOB fields – because just counting “used_pages” is not enought to show accurate index size):

Cooking questions answered

This will give you the sizes, and record counts for each table.

Cooking questions answered

A small change on Mar_c’s answer, since I have been going back to this page so often, ordered by most row’s first:

For get all table size in one database you can use this query :

And you can change it to insert all of result into temp table and after that select from temp table.

Cooking questions answered

I added a few more columns on top of marc_s answer:

We use table partitioning and had some trouble with the queries provided above due to duplicate records.

For those who need this, you can find below the query as run by SQL Server 2014 when generating the “Disk usage by table” report. I assume it also works with previous versions of SQL Server.

It works like a charm.

My post is only relevant for SQL Server 2000 and has been tested to work in my environment.

This code accesses All possible databases of a single instance, not just a single database.

I use two temp tables to help collect the appropriate data and then dump the results into one ‘Live’ table.

Returned data is: DatabaseName, DatabaseTableName, Rows (in the Table), data (size of the table in KB it would seem), entry data (I find this useful for knowing when I last ran the script).

Downfall to this code is the ‘data’ field is not stored as an int (The chars ‘KB’ are kept in that field), and that would be useful (but not totally necessary) for sorting.

Hopefully this code helps someone out there and saves them some time!

In case you need to know, the rsp_DatabaseTableSizes table was created through:

The Cooking Academy, Cooking Classes – Herts – North London, cooking questions

cooking questions answered

Cooking questions answered

Share the experience with friends and family – the ideal present for people who are seeking renewed inspiration, as well as those yet to discover the pleasure of cooking

Cooking questions answered

You really can cook something sophisticated and delicious; try something different and release the ‘creative you’

Cooking questions answered

We provide the perfect ingredients for the most amazing and original parties

Cooking questions answered

The Cooking Academy is dedicated to teaching people, in a fun and enjoyable way, how to prepare and cook delicious and nutritious food.

Cooking questions answered

Our cooking classes are entirely hands-on, in small groups, and taught by an expert chef in a home-from-home kitchen environment.

Cooking questions answered

We think cooking should be a fun and exciting creative experience for people of all ages and all walks of life. Our classes are relaxing, non-judgemental, social occasions that bring people together.

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Cooking questions answered

Amazing Parties

Get together with friends and family for your own exclusive special occasion. Unbeatable!

Cooking questions answered

Private Tuition

For just you, or you and a few close friends, we’ll run a completely bespoke day to suit your requirements.

Cooking questions answered

Cooking questions answered

Cooking questions answered

Silverwood, London Road, Rickmansworth, Hertfordshire, WD3 1JR

The nearest main line underground tube station is Marylebone, Just 22 minutes to Rickmansworth.

Silverwood, London Road, Rickmansworth, Hertfordshire, WD3 1JR

The nearest main line underground tube station is Marylebone, Just 22 minutes to Rickmansworth.

Exit the M25 at J18. Turn left onto the A404 (Chorleywood Road). Continue along the Chorleywood Road to the roundabout where you will see Rickmansworth Station in the distance. Take the 2nd exit onto the A412 (dual carriage way sign-posted Slough, London), then you will pass under a bridge and shortly approach the Ebury roundabout.

Exit the M25 at J17. Follow direction to Rickmansworth (you will pass through Mill End local shops) until you reach the Ebury roundabout.

From the Ebury roundabout

Take the A404/Riverside Drive exit (sign-posted London, Northwood). At the next roundabout with Travis Perkins Builders Merchants directly ahead, take the 2nd exit onto the A404 Church St (sign-posted London, Northwood).

At the Moor Lane roundabout, take the 2nd exit up the incline of London Road. After 150 metres (you will notice an “island” in the road), indicate left to turn into Silverwood which is directly opposite Batchworth Park Golf Club to your right. Parking is available on site.

Silverwood is a private property on London Road, is situated approx 200 metres from the Moor Lane roundabout and is the fifth property on the left.

By train Rickmansworth is on the Chiltern Railways service from Marylebone to Aylesbury, 22 minutes from Marylebone

By tube take the Metropolitan line to Rickmansworth, 30 minutes from Baker Street.

We are a short taxi ride from the station (there is a local taxi company outside the station – Boughtons-Eagles 01923 777555)

The Cooking Academy Limited, Silverwood, London Road, Rickmansworth WD3 1JR