|
Well,
You are using the parameters in the call to fn_Get_ProRataDetail. You could try what happens ig you do the local var trick in that function. That way other sp's may benefit too. But the local var trick is the only one I know besides using With Recompile.Wout Louwers
|
|
|
|
|
See thats the reason I spend time here, never heard of parameter sniffing, sounds disgusting. There are some excellent articles out there, another tool in the ongoing fight for performance.
Thanks Wout.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm not sure if this is the best place to post this, but I'm retrieving a table form an SQL database and databinding the contents into a DataGridView.
I have some code that searches the entire DataGridView and locates null values, and I intend to color the fields red so the user knows he needs to put something in.
private void button1_Click(object sender, EventArgs e)
{
for (int column = 0; column < 1; column++)
{
for (int row = 0; row < this.dataGridView.RowCount; row++)
{
if (this.dataGridView.Rows[row].Cells[column].Value == null)
{
this.dataGridView.Rows[row].Cells[column].Style.BackColor= Color.Red;
}
}
}
}
theres still some messageboxes in there that I used to figure this out...
If I change the conditional statement to (this.dataGridView.Rows[row].Cells[column].Value != null) so that it searches for non null fields, it successfully colors the cells.
I guess my problem has to do with the nullity (lol is that a word?) of my cells.
I guess I should include how I am populating my dataGridView...:
private void Form1_Load(object sender, EventArgs e)
{
this.pickups___CarsTableAdapter.Fill(this._Vehicle_EquipmentDataSet._Pickups___Cars);
}
that was auto generated =)
Perhaps I can handle the null data when the list is populated?
Thanks in advance!!!modified on Thursday, March 18, 2010 12:45 PM
|
|
|
|
|
Mattzimmerer wrote: this.dataGridView.Rows[row].Cells[column].Style.ForeColor = Color.Red;
how do you see the ForeColor of an empty cell?
|
|
|
|
|
Ohh, i should have changed that back. No I first tryed backcolor or w/e, which works find for populated cells... that was a purley desperate attempt..
THE PROBLEM PERSISTS!!!!
|
|
|
|
|
You should check the value from the data source itself, not datagridview's cells. Subscribe to the datagridview's CellFormatting event, then in the handler get the DataBoundItem (object, datarow etc) and set color base on the DataBoundItem's data itself.
I'm binding to collection of object, btw, so YMMV.
private void dataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
string dataPropertyName = this.dataGridView.Columns[e.ColumnIndex].DataPropertyName;
ObjectType theObject;
switch (dataPropertyName)
{
case "ColumnName":
theObject = (ObjectType)this.dataGridView.Rows[e.RowIndex].DataBoundItem;
break;
}
}
|
|
|
|
|
Fixed my problem:
private void Null_check_Click(object sender, EventArgs e)
{
for (int row = 0; row < this.dataGridView.RowCount-1; row++)
for (int column = 0; column < this.dataGridView.ColumnCount; column++)
if (this.dataGridView.Rows[row].Cells[column].Value.ToString() == "")
this.dataGridView.Rows[row].Cells[column].Style.BackColor = Color.Red;
}
just needed sleep I guess...
|
|
|
|
|
CREATE TABLE [PreferenceType] (
[PreferenceTypeId] [BIGINT] IDENTITY (1,1) NOT NULL,
[LongName] [NVARCHAR](500),
[ShortName] [NVARCHAR](250)
);
CREATE TABLE [Table2]
(
[Table2Id] [BIGINT] IDENTITY (1,1) NOT NULL,
[PreferenceTypeId] [INT]
)
Given the Preference Lookup table above, if I do an Inner Join to Table2 on the PreferenceTypeId field, I should index like this:
CREATE INDEX [PreferenceTypeId_Idx] ON [Table2]([PreferenceTypeId]); <--- good?
But I shouldn't index like this:
CREATE INDEX [PreferenceTypeId2_Idx] ON [PreferenceType]([PreferenceTypeId]); <--- bad?
because Primary Key fields should already be indexed, correct?
|
|
|
|
|
You should make PreferenceType.PreferenceTypeId a PrimaryKey (Yes it will be automatically indexed) and you should make Table2.PreferenceTypeId a ForeignKey constraint referencing PreferenceType.PreferenceTypeId (this will also be automatically indexed).
[Edit]
Foreign keys are NOT automatically indexed.modified on Wednesday, March 17, 2010 5:06 PM
|
|
|
|
|
KEWL, i learned something new, that foreign keys automatically get indexed for me.
|
|
|
|
|
| I believe that's incorrect. Creating an index on a foreign key is usually recommended, but not done automatically[^]. "When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Thank you for the correction and the links.
|
|
|
|
|
| You're welcome. "When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Sorry in advanced for a duplicate question or a really basic question, but is nvarchar better than varchar? Is there an advantage for nvarchar? I've always just used varchar. Thanks!
|
|
|
|
|
Nvarchar stores unicode characters which means you don't have the problem with different codepages in different countries. But it also uses twice the space.
If you need to store characters from several alphabets in the same field you really will like nvarchar."When did ignorance become a point of view" - Dilbert
|
|
|
|
|
multi language benefit, but space cost...got it, thanks!
|
|
|
|
|
Heres another one, SQL Server CE ONLY supports nvarchar, nchar etc so if you need to use CE then you know the requirement. Also does not support stored procedures 
I am currently bleeding from this particular bite me!Never underestimate the power of human stupidity
RAH
|
|
|
|
|
VARCHAR is a variable length string of ASCII characters while NVARCHAR is a variable length string of UNICODE characters.Since NVARCHAR can handle unicode characters, so it allows to use multiple languages in the database.
Each ASCII character takes one Byte of space while each UNICODE character takes two Bytes of space. It means NVARCHAR takes twice as much space to store to allow for the extended character set required by some other languages.
modified 27-May-14 4:40am.
|
|
|
|
|
hi all,
i have developed an application in vb.net with Mssql Express 2008 which has about 600 store procedures and 200 tables. All are working fine.
now i want to install me app to my client (end user) and want to hidden my database from any one other than me.i know how to encrypt a sp.
my problem is how i encrypt 600 SPs. if i do it one by one it will be a very big job.
kindly suggest me suitable solution.
Thanksrmshah
Developer
|
|
|
|
|
If you know how to encrypt a proc then write a script to encrypt each proc in your database, it is a simple loop process.
Get a list of procs from the system information_schema views!Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks for reply,
Kindly suggestexample codes.
Thanksrmshah
Developer
|
|
|
|
|
Please join Microsoft and the League of Technical Voters at a 2-day codeathon event! We are hosting this event at the Microsoft Chevy Chase office in the DC area during the weekend of April 09 through 11 (please see attached flyer). The focus of this event is on making government documents more accessible and citable; we have provided more information on citability below. You can learn more about the event at http://dccodeathon.com and register at: http://dccodeathon.eventbrite.com.
Event Details
Programmers and designers will gather to work all weekend to create live demos to showcase Citability. Access Please sign up to attend at http://dccodeathon.eventbrite.com so we can reserve your seat!
Date: April 9 – 11, 2010
Time: April 9, 7:00PM – April 11, 6:00PM EST
Location: Microsoft Office
5404 Wisconsin Ave, Suite 700
Chevy Chase, MD 20814
(301) 771-8000
What to Expect
Come and see some of our exciting new projects – here is a peek at some of what you can expect:
• View new video annotation tools so people can cite a specific part of a video and can also tag those citations with different levels of access to annotate.
• Demonstration of how to archive, version and cite live changing datasets while using a minimum amount of storage space.
• See how archive servers can be cloned to other organizations where they can separately add their own annotations.
• Explore how our archive server can help divergent agencies share data more easily.
• Proposed integration of existing citation standards like Dublin Core, URN:LEX, and microformats.
Participant Preparation
We encourage participants to work on some relevant projects prior to the codeathon and showcase them at the event itself. Please visit our online wiki at http://dccodeathon.pbworks.com/Project ahead of time, choose a project and start designing. When it's Codeathon weekend, you will only have time left for coding! On Sunday you can showcase your applications to representatives from government agencies and media in attendance. Please feel free to add your own project here! Some of the relevant technical skills for participants would include:
1. ASP.NET, HTTP/REST, JavaScript, micro formats
2. Windows Azure (PHP and other OSS technologies on Azure a plus)
3. SharePoint 2010/2007
4. Open source technologies, e.g. PHP, Python, R-on-R
Background & Overview on Citability
Citability is an important step to promote informed participation by the public and increase governmental transparency and accountability. In keeping with the tenets of the January 21, 2009 Presidential memo on Open Government and transparency, the objective of Citability.org is to web enable publicly available government documents and make them citable at a paragraph level, allowing citizens to cite governmental documents on a useful, unique level.
Citations can be as simple as linking to a specific paragraph in a policy by a blogger or as complex as a group of attorneys and judges debating a regulation. Imagine the level of community participation an advocacy organization could create by having an authoritative source for budget line items! Or the support a nonprofit could receive by pointing to specific budgetary links to available funding sources for its cause or perhaps justify to its constituency why their donations would help more.
Most Government officials we have spoken to are extremely supportive of the concept of Citability. The importance of citations to show accuracy & authority is well understood. Often, the concern is about cost! The League of Technical Voters and Microsoft are therefore thrilled to support this event to create free and open source code to demonstrate that Citability does not have to be expensive to be feasible.
Event sponsored by Microsoft and the League of Technical Voters.
|
|
|
|
|
| You should probably post this in the Get-Togethers[^] forum. It certainly has little or nothing to do with databases. Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
I have a field in an access database called day and is declared as DATE/TIME
I want to find through SQL all records with dates between 01/03/2010 and 15/03/2010
When i sent the sql command
'Select * from journal1 where day between 01/03/2010 and 15/03/2010'
it does not work.
Even if i try 'Select * from journal1 where date(day) between 01/03/2010 and 15/03/2010' it doesn't work.
I am almost sure that the problem is because the day includes also a time portion in it, but if i put date(day) shouldn't this be working ?
Thanks.
|
|
|
|
|
Use # to delimit date:
Select * from journal1 where day between #01/03/2010# and #15/03/2010#
However, I am not sure how to tell Access if it is mm/dd/yyyy or dd/mm/yyyy. If you can use a parameterized query command, this will be easier.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
