|
When designing a database, what decisions do you consider when deciding how big your nvarchar should be.
If i was to make an address table my gut reaction would be for address line 1 to be nvarchar(255) like an old access database.
I have found using ...
Started by Paul on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Also comments etc I'd probably....
I work for a big Swiss company with offices globally so I'm not being parochial.
My recommendation: make them just as big as you need it.
I definately know the siez of, zip codes or NI numbers etc .
|
|
Consider these two statements. These are my observations to the best of my ability.
An image of a clean install of Windows XP Service Pack 3 takes just 1.6 GB.
An image of a clean install of Windows 7 consumes a whopping 5.8 GB.
What the heck makes a ...
Started by eleven81 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at superuser):
Good info on this: http://blogs.msdn.com takes up more space than XP, but not... .
There if they didn't support 32-bit, and if they didn't make a 64-bit version then it wouldn't encourage developers to move on and make their code compatible.
|
|
I'm using the following basic function which I copied from the net to read a text file
public void read () { File file = new File("/Users/MAK/Desktop/data.txt"); System.out.println("Start"); try { // // Create a new Scanner object which will read the ...
Started by MAK on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What are you ....
Is the disk still active? What are you doing with the console output - has it stopped? You say it "failed to work" but you haven't said how it's actually behaving .
If you're not getting an error, it could well just be taking a long time .
|
Ask your Facebook Friends
|
I have an Oracle DB, and an ASP Page that has many ListBoxes and DropDownLists. These controls make the user input data to get filtered results on the next page.
Once the user clicks search, a string (query) is generated based on the selections of the...
Started by zohair on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Once you've....
The next step is to display the results on your forms (Step 2) .
You'll want to start by hooking into your Oracle database and making the query (Step 1).
For such a broad question you're going to require multiple sets of information .
|
|
Hey. I know this is not a 'refactor my code' site but I made this little piece of code which works perfectly fine with moderately sized input but it's problematic with string of size, say, over 2000.
What it does - it takes a string of numbers as a parameter...
Started by ooboo on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Initialize P[1] = 2 if the first....
Initialize P[0] = 1 (unless the first character is 0, in which case just return 0 for the result) .
Try using a dynamic programming approach instead:
Create an array (call it 'P') with 1 element per character in the string .
|
|
I am developing a Windows Forms application (.NET 2.0, VS 2005). I have a form that essentially contains a panel that is dynamically resized with the form :
this.panel1.Dock=DockStyle.Fill;
This panel is simply used as a container. At runtime, a custom...
Started by Mac on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Set you User control's MinimumSize property Set the panel's AutoScrollMinSize property
The Panel's scrollbars... .
(Anchor to all four sides).
Use the Anchor property instead.
Uc.SetBounds(1, 1, 400, 400);
Don't Dock your User control.
Use setBounds() method.
|
|
I have an < mx:Label > tag that has a set width, which is usually large enough to display the text it needs to show. Every once in a while though the text is a little too long and gets chopped off and "..." gets appended. Instead of this happening...
Started by John Isaacks on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For a given text, you can find the string length and calculate the maximum allowable font-size very simply using the following approximate formula:
var max_allowable_size:int = yourLabel.width / yourLabel.text.length;
This... .
Fonts are a complicated beast.
|
|
For some reason the viewstate of my application became gigantic (around 14 million characters). It adds around 1 minute of loading time. If the page finally loads (which is not often), the server crashes every time someone send a form because " Post size...
Started by marcgg on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
To disable viewstate for a specific control set:
EnableViewState="false"
If you set ... .
You can often disable viewstate for a lot of your controls without any issues .
Keep in mind that controls will retain their values across postbacks without viewstate .
|
|
Download Blackberry Desktop, 100MB just for the little program. Add the "Media Sync" its a 320MB download (still have to install Windows Media or iTunes after that).
Get the latest drivers for my video card ~100MB. Dig up a GPRS PCMCIA card from SonyEriccson...
Started by falkaholic on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at superuser):
Apart from that, sometimes there is no excuse and it is just... .
A lot of software (Especially drivers / device software) comes bundled with dependencies that are not installed, for example, Windows Hotfixes, .NET Framework, Flash, Java and/or some others .
|
|
Possible Duplicate:
What’s the best way to capitalise the first letter of each word in a string in SQL Server.
Example: TONY, BOY
This is the results I need to see: Tony, Boy
Thanks for the help.
Started by Kombucha on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Here is a quick example of what would work SELECT... .
Use your favourite search engine and search for "SQL title case" .
SQL doesn't have a built-in function to do this, but there are a number of user-defined functions on the web which may do the job well .
|
