.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

On Using RAM Drive/USB Memory Stick for tempdb Data and Log Storage

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server

128GB USB memory stick is around $400 (2010).

Since there are restrictions on the number of independent disks for a server, can RAM drives or memory sticks be used for tempdb?  Thanks.

Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

View Complete Post

More Related Resource Links

Data Points: Windows Azure Table Storage - Not Your Father's Database


Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.

Julie Lerman

MSDN Magazine July 2010

Data Points: Syndicated Data And Isolated Storage In Silverlight


Here we build a syndicated news reader application to illustrate the use of isolated storage and data syndication in Silverlight.

John Papa

MSDN Magazine February 2009

Smart Storage: Protect Your Data Via Managed Code And The Windows Vista Smart Card APIs


Smart cards are a compelling alternative to the reliance on passwords, which are the weakest link in authentication systems. Get the Windows smart card programming basics here.

Dan Griffin

MSDN Magazine November 2006

Exchange 2000 WSS: Web Storage System Improves Exchange Data Accessibility


The Web Storage System (WSS) in Exchange 2000 is a Web-accessible database that stores any type of data such as e-mail, contacts, appointments, threaded discussions, and multimedia files, and renders the data in HTML in any browser. WSS is based on Internet standards, therefore data can be accessed through URLs, an Exchange OLE DB provider, drive mapping, XML, and Web Documenting and Versioning (WebDAV). This article discusses the WSS schema and how to extend the default schema for custom data. A sample application that uses a custom schema and a custom form to display WSS data is available for download.

Sean McCormick

MSDN Magazine May 2001

What happens to SQL when the TempDB drive fails?


I am looking to build a new 2 node clustered SQL 2008 R2 setup to support SharePoint 2010 and Project server 2010. I have two 48 core servers with 128gb ram and 2 drive shelves, one drive shelf has 24 x 1500rpm 146GB  drives and one backup drive shelf has  14 2TB drives.  I am trying to figure out what is the best way to setup the 1500rpm drives particularly for the temp DB data files.  My databases for SharePoint and Project server will be on two Raid 10 arrays and their logs will be on 2 separate RAID 1 arrays, all on 1500RPM drives.  That leaves me with five 1500RM disks left.  One of those disks will be hot spare drive waiting for a failure of any drive in the shelf.  That gives me 4 drives left for the Temb DB files.  To be safe I could build two raid 1 arrays and put some of the temp db files on the one array and some on the other array. 

But, what I am considering and looking for advice on is if I do not RAID the 4 drives and just use them as 4 individual drives knowing that if any of them fail the hot spare drive will kick in and become


please explain how db Memory and tempdb Relate on SQL SERVER 2008 ?

data storage in sharepoint templates



I m using Helpdesk template of sharepoint. I hve added few custom fields when we create new service request.

Can anybody help me here to find out where the data is stored? If its table in sql, then which table.

Any help would be appreciated

Memory error: Allocation failure : Not enough storage is available to process this command. .



I get the error message above. Cube has 3 measure groups, 1 main fact and 2 many to many facts. Main fact has 450k rows, other two have 165 rows and 2200k rows. It also has 4 dimensions. Dimensions have max 10000 rows.

I get the errors when I add a "calculated" fact to the the main fact group, which is a distinct count on a key. When I remove that fact, the error is gone.

I am using sql 2005 enterprise with the latest sp's and patche on a windows 2003 server with 4GB 32 bit. Any ideas ?


Restore Data only after failed drives, Log file is good on a separate drive array

We have a 2000 sql server.  Our drive array housing the mdf file has taken a dump.  The drive array housing the ldf file is fine.  I have a full backup as of 2 hours ago.  I know I can restore to that point in time.  However, the transactions sitting in the ldf file are critical to get applied the the restored mdf file.  In reading I see I can restore log files using the "With NoRecovery" option, however, I don't wan't to restore any log files, as I'm thinking the one I have is good.  I want to be able to restore the mdf file and then have the database apply the transactions in the log file on the mdf file. (I want the "redo" phase to use the current ldf file, not a restored ldf file) Any Ideas?

2008 SSIS and NUMA Memory issues and BLOB Data Types


We're running SSIS 2008, moving data from an Oracle 10g database to a SQL 2008 database.  The SSIS is running on the same machine as the SQL Destination server.  The server has 8 gigs and is windows 2003 sp2

The issue we're having is when our package pulls a blob data type from oracle it will just quit with no errors at about 1.4 million records.   We know there are 6 millions records in the dataset. 

A friend of mine said it was a NUMA Memory issue that it is running out at some point and SSIS thinks the incoming data is finished.  Unfortunately, she said there was no answer. 

I was wondering if someone else had a simliar situation moving blobs from Oracle?


Display ALL saved text data of lists from isolated storage


How do I display ALL of my saved items of different list from the isolated storage?

Eg. I created a list named "Breakfast" with 2 Bandung and 3 Water inside.

Created another list named "Lunch" with 5 Bandung and 2 Hot-tea inside.

When I click to view "Lunch" list, it will display out the list with "5 Bandung and 2 Hot-tea".

However, I can only manage to display "Hot-tea" without the quantity, and unable to display 5 Bandung as well.

How do I go about displaying all of the items inside the selected list?

Thank you!



private void addListBtn_Click(object sender, RoutedEventArgs e)
    using (IsolatedStorageFile storage = IsolatedStorageFile.GetUserStoreForApplication())
      StreamWriter writeFile = new StreamWriter(new IsolatedStorageFileStream("ListFolder\\savedList.txt", FileMode.OpenOrCreate, storage));
      for (int i = 0; i < (Application.Current as App).userDrinksList.Count; i++)
        String drink = (Application.Current as App).userDrinksList[i].ToString();

        XDocument _doc = new XDocument();


Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend