fly2melb

DBCC PAGE('[DB_NAME]', [PAGE_FILE_ID], [PAGE_ID], -1)

fly2melb

DBCC IND('[DB_NAME]', '[TABLE_NAME]', -1)

SELECT [First] 
FROM [sys].[sysindexes] 
WHERE [id] = OBJECT_ID('[TABLE_NAME]') 
    AND [indid] IN (0, 1)

fly2melb

DBCC SHOWCONTIG('[TABLE_NAME]') WITH TABLERESULTS

SELECT alloc_unit_type_desc
    , page_count
    , avg_page_space_used_in_percent
    , record_count
FROM sys.dm_db_index_physical_stats(
    DB_ID('[DB_NAME]')
    , OBJECT_ID(N'[TABLE_NAME]')
    , NULL

fly2melb

DBCC TRACEON(3604)

fly2melb

SP_SPACEUSED '[TABLE_NAME]'

fly2melb

#if DEBUG
    Console.WriteLine("This is debugging code.");
#endif

fly2melb

@using (Html.BeginForm())
{
    @Html.AntiForgeryToken()

    @Html.ValidationSummary(true, "", new { @class = "text-danger" })

    <div class="form-group">
        @Html.DropDownListFor(model =>
            model.ContinentId, new SelectList(Model.ContinentList, "Key", "Value", Model.ContinentId),
            "- Continent -", new { id = "continentId" })

fly2melb

public ViewResult CascadingDropDown()
{
    var viewModel = new CascadingDropDownViewModel();
    viewModel.ContinentList = GetContinents();

    return View(viewModel);
}

[HttpPost, ValidateAntiForgeryToken]
public ViewResult CascadingDropDown(CascadingDropDownViewModel viewModel)

fly2melb

    public class CascadingDropDownViewModel
    {
        public CascadingDropDownViewModel()
        {
            ContinentList = new List<KeyValuePair<int, string>>();
            CountryList = new List<KeyValuePair<int, string>>();
        }

        public List<KeyValuePair<int, string>> ContinentList { get; set; }

fly2melb

SET http_proxy=http://192.168.1.1:8080
SET http_user=domain\\username
SET http_pass=password