Viewing 15 posts - 256 through 270 (of 341 total)
I have seen both sides, and its fair to say the answer is in the middle. And as many have said, the real key is to understand both your...
The more you are prepared, the less you need it.
December 1, 2008 at 7:30 am
Either way has pros and cons, and I have seen both. I don't have a problem with developers having a local copy to work with and test against. ...
The more you are prepared, the less you need it.
November 18, 2008 at 6:09 pm
agree, take a look at soundex and full text search. Both have some value and may match your needs.
The more you are prepared, the less you need it.
November 18, 2008 at 6:02 pm
Thanks, but just for the record, the load on the tempdb comes from snapshot isolation and nasty cursors used by the Java developers. It's a long road, but working...
The more you are prepared, the less you need it.
November 18, 2008 at 5:58 pm
Points for writing and posting the article. And a good start.
For smallist, in-house corp applications tuning seems to be ignored or overlooked. And even with externally...
The more you are prepared, the less you need it.
November 17, 2008 at 10:12 am
This should work, if I followed your example correctly:
select t.CodClient,t.Name, (t.Address2 + t.Address3) AS Address
from CUSTOMERS t
...
The more you are prepared, the less you need it.
November 6, 2008 at 11:53 am
I agree, set it for simple
The more you are prepared, the less you need it.
November 6, 2008 at 11:49 am
Agree that functions have some limits, but the use here is to simply repackage.
The more you are prepared, the less you need it.
November 6, 2008 at 7:54 am
Thanks for the tip. Always looking for new approaches.
But what I am really starting to look is a way to have an application pass in an XML value, and...
The more you are prepared, the less you need it.
November 6, 2008 at 7:50 am
If you cannot use a second column, when you do the match, have the numeric value on the left side of the where conditional:
where mynumeric = myformatlogic(my string...
The more you are prepared, the less you need it.
November 6, 2008 at 7:48 am
Agree, default on the table is the most efficient for the initial createdate. However, if you are concerned that the development code will put in an incorrect value, then a...
The more you are prepared, the less you need it.
November 6, 2008 at 7:43 am
Have you used the XML Task?
And you should be using the File not the Flat File data source.
Start with the XML Task, and then use that to make...
The more you are prepared, the less you need it.
November 6, 2008 at 7:37 am
Good point on the INCLUDE. In this case you would need to include all columns as part of the index. My oversight.
The more you are prepared, the less you need it.
November 5, 2008 at 12:59 pm
here is a good example, and btw, this function is very useful. It converts strings to a table
-----------------------------------
-- call it
declare @strPermissionName nvarchar(4000)
select @strPermissionName = N'dkljdflaj,kdkkd,dkjajlf,'
select * from dbo.fnNStringToArray(@strPermissionName,...
The more you are prepared, the less you need it.
November 5, 2008 at 9:49 am
an index works as well, but try to keep it narrow and put some of the lesser values in an include. you want to keep it as narrow as possible...
The more you are prepared, the less you need it.
November 5, 2008 at 9:42 am
Viewing 15 posts - 256 through 270 (of 341 total)