Viewing 15 posts - 571 through 585 (of 8,416 total)
quillis131 (5/23/2012)
I was wondering and cannot think straight on this, So I came with an idea of getting ideas/views from different people..
Make it easy: always specify all the options you...
May 23, 2012 at 1:17 pm
PradeepVallabh (5/23/2012)
Is it advisable to create indexes on where clause for insert and update statements?
Perhaps, if the index is useful in locating the records to INSERT or UPDATE.
May 23, 2012 at 1:08 pm
PradeepVallabh (5/21/2012)
Why should i create an index with Include Columns(why can't i just say create a composite index with Include Column as one of the field)
Several reasons, all explained quite...
May 23, 2012 at 1:06 pm
Mark Fitzgerald-331224 (5/23/2012)
May 23, 2012 at 10:40 am
Steve Jones - SSC Editor (5/23/2012)
RM *
Cool!
May 23, 2012 at 10:06 am
elham_azizi_62 (5/22/2012)
I need to 3 bit counter with T-Sql that give this result
Why?
May 23, 2012 at 12:53 am
dwain.c (5/23/2012)
I've seen (dramatically) how WITH SCHEMABINDING improves the performance of a Scalar Valued Function. I'm wondering if the same is true for TVFs and what is the downside?
No...
May 23, 2012 at 12:50 am
Mark Fitzgerald-331224 (5/22/2012)
The difference between the two sets would be the dirty rows.
This works as a demo, but it is not a practical dirty-read detection solution.
May 23, 2012 at 12:39 am
Alexander-449406 (5/22/2012)
I have a stored procedure that sets transaction isolation level read uncommitted. Is it possible to know if the results contain a dirty/phantom read?
No. The engine delivers the...
May 23, 2012 at 12:36 am
This is a generally a performance optimization, see the following links for more information:
http://www.sqlservercentral.com/articles/sp_prepexec/76511/
May 23, 2012 at 12:29 am
Sergiy (5/22/2012)
May 23, 2012 at 12:06 am
Luis Cazares (5/22/2012)
I didn't beleive that DDL would be necessary as the code uses just one column, next time I'll be sure to include it.
Joe writes some good stuff in...
May 22, 2012 at 9:23 pm
dwain.c (5/22/2012)
But why the COLLATION?
ColdCoffee brings up an interesting point - what to do with 0s? Clearly appearing at the beginning of the number they are removed when converting...
May 22, 2012 at 9:19 pm
dwain.c (5/22/2012)
Cool solution Paul! But could you offer an explanation of how it works?
It works out how many of each digit are in the initial string, and forms the...
May 22, 2012 at 8:29 pm
Sean Lange (5/22/2012)
May 22, 2012 at 4:33 pm
Viewing 15 posts - 571 through 585 (of 8,416 total)