Viewing 15 posts - 31 through 45 (of 94 total)
I think the difference is SQL Server is smart enough to know you have a literal in your IN clause. My suggestion is to avoid the IN clause and to...
March 4, 2005 at 7:50 am
A little more detail would help. Perhaps some sample SQL of what you want to do.
February 27, 2005 at 12:45 pm
i believe you are dealing with the difference between and empty string and a null value. There should be somekind of isnull functionality within your code, but if there isn't...
February 26, 2005 at 7:41 pm
You have 1 question and 1 issue. You don't have a key field in this table, unless it is a combination of the pointid and timein. Which is using a...
February 26, 2005 at 8:15 am
In your second question you asked about an index on a bit field helping. Actually, you can't index a bit field. SQL Server doesn't really need help with it, basically,...
February 26, 2005 at 7:56 am
How do you deal with complexity and size of task differences? The developer who completes 10 quick hit tasks will be more productive than the developer who completes 1 task...
February 24, 2005 at 10:06 am
I completely agree, but do you have any way of producing metrics for your work? Accuracy of delivery? On Time delivery? Bug Fixes? etc?
If you do or know a good...
February 24, 2005 at 7:37 am
In our home grown OMS (1 developer for 1.5 years) we have the following statistics:
23 Triggers
159 Tables
175 Views
222 Procedures
22 Foreign Key Constraints
13 Functions
118 Constraints/Indexes
126 Primary Keys
and a Visual Basic Front...
February 23, 2005 at 7:23 am
You can use the syscolumns table in the database in question to get the columns of a particular object. The type of column is determined by the xtype field. You'll...
February 23, 2005 at 7:10 am
Helen's suggestion works but it is an undocumented feature that may not continue with future versions of SQL Server. My suggestion is to create a function that loops through the...
February 18, 2005 at 6:43 am
Agreed on all counts.
The installation was a nightmare on my end as well, but the product features and the power of the reporting language has been well worth the effort and...
February 11, 2005 at 10:53 am
Without too much knowledge of VB.Net it looks like you might need to include the owner of sp_insert. But in VB.6 you need to identify the type of command the...
February 10, 2005 at 8:50 am
Look at it as job security. Then my suggestion is to use views that do not allow deletions (where needed) and also some triggers could help. But be careful with...
February 10, 2005 at 8:45 am
Michael. The reporting server service needs to be initialized. This can be caused by quite a few different issues. The first thing to do is follow the suggested steps in...
February 10, 2005 at 7:53 am
Views would be my suggestion. Give them the ability to delete records from the view, but not delete permissions on the table.
But why would users have this kind of...
February 10, 2005 at 7:48 am
Viewing 15 posts - 31 through 45 (of 94 total)