Viewing 15 posts - 1,756 through 1,770 (of 2,894 total)
Sean Lange (4/13/2012)
There were two crocodiles flying. One to the south but another one was blue.
Question: How...
April 16, 2012 at 8:31 am
1. Create a table
2. Create an unique constraint
3. Check what is created (sp_help)
4. Drop unique constraint
5. Check what is left (again sp_help)
You will find the answer and prove it...
April 16, 2012 at 7:10 am
That is showing what really takes the time! It's getting rid of large BLOBs.
I'm afraid, you can not do much without redesign...
April 16, 2012 at 7:05 am
Try to update the image columns to null. Does it take same as long as delete?
April 16, 2012 at 6:44 am
... If there are no changes then there will be no locks ...
Does not SELECT puts a Shared Lock on a table?
I agree that placing the lock itself doesn't take...
April 16, 2012 at 4:33 am
Just to add:
There is another locking hint: TABLOCKX - it will put an exclusive lock on the table, so it will not be available for selects from another transactions...
In...
April 16, 2012 at 4:15 am
Nolock is not a good idea in most cases.
Absolutely, agree. In OLTP system will be hard to find justifications for using this hint.
But this hint does exist and there...
April 16, 2012 at 4:06 am
...
It's entirely possible someone with better C#/VB.NET skill than mine can make a CLR function that's faster, but the options I found online for that were all much, much...
April 12, 2012 at 10:18 am
"FOR XML PATH ('')" T-SQL relatively new feature is used to return the results in XML form.
It does not need XML, it generates it!
Try to run this:
select d.Origin
from (
...
April 12, 2012 at 10:06 am
Could be anything from situation where joining tables have different collation for the columns they are joined on, to using temp tables in the proc and having different default collation...
April 12, 2012 at 8:58 am
If you want a more efficient version, that doesn't require as much pre-processing, any CLR, etc., ...
I'm sure CLR will beat the use of Number table on large datasets where...
April 12, 2012 at 7:49 am
You should provide ddl and some test data to explain your problem in more consumable way (link at the bottom of my signature will help you).
I'm not sure if that...
April 12, 2012 at 6:58 am
If you need the best possible performance - write CLR function (with defining static Regex with RegexOptions.Compiled option)
Ping if you need help with it.
April 12, 2012 at 6:36 am
Sean Lange (4/4/2012)
You have to either use a datetime variable or put your string representation inside single quotes.
select * from TICKET where createDate > '4/1/2012'
Is it 4th Jan 2012 or...
April 5, 2012 at 2:41 am
Viewing 15 posts - 1,756 through 1,770 (of 2,894 total)