Archive for the ‘Uncategorized’ Category

How to split string

Sunday, November 4th, 2007

This code tell you how to split string in c#

string stringTosplit = “1,2,3,4,5,6″;

char [] charectorTosplit = {’,'};

Array Scount = stringTosplit.split(charector);

for(int  i=0;i<Scout.Length;i++)

{

messageBox.show(Scount.getValue(i).Tostring())

}

Linking Access to SQL Server

Friday, November 2nd, 2007

For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data. More »

Using the kill to cure

Friday, November 2nd, 2007

Code profiling tools can help cure most performance problems, but sometimes the problem is so severe that you’ll first need to know how to wield computing’s least understood tool, the debugger, before diving in with the Profiler. Brian Donahue, Crash Scene Investigator, is on hand to explain why.More »

Suggestions for PASS

Friday, November 2nd, 2007

PASS is the global users group for SQL Server DBAs, but there are a number of people who have never heard of it. Longtime author Andy Warren has a few suggestions for PASS and encourages you to submit your own.More »

Working with Time Spans and Durations in SQL Server

Friday, November 2nd, 2007

What is the best way to return the “duration” of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over 23 or minutes total up to over 59? Are there any T-SQL functions or other techniques that are useful in these scenarios? More »