Viewing 15 posts - 9,256 through 9,270 (of 9,641 total)
At the Orlando PASS meeting last night, Jeff Garbus did his Indexing for Performance talk and he said something that made sense and relates to this. I probably won't...
February 13, 2008 at 10:04 am
Matt's solution is more efficient than mine. I thought about using a CTE, but have not used them enough to be comfortable. If you set statustics IO on...
February 13, 2008 at 9:59 am
Is the column you are inserting into smalldatetime or datetime? Are you getting an overflow error? I have seen problems because of bad dates in legacy systems like...
February 12, 2008 at 1:49 pm
Can you post what you want the final result to look like?
February 12, 2008 at 1:45 pm
This may relate a littel to Arthur's comment about loading to another RDBMS or from another RDBMS or even another server. If you are loading from a system that...
February 11, 2008 at 6:32 am
Wow, no anti-identity post yet. I like identity for all the reasons mentioned thus far. I also agree that there are times when an identity column is not...
February 11, 2008 at 6:19 am
Charles Kincaid (1/29/2008)
January 29, 2008 at 9:30 am
I agree that the MS marketing is horrible, I also think a 2-3 year release cycle is too fast. How are DBA's and developers supposed to keep up with...
January 29, 2008 at 7:12 am
Did you check to see the type of locks being taken by the 2 methods? Were there any differences in locking that would mitigate the improvement based on fewer...
January 29, 2008 at 6:15 am
Definitely be truthful, but as others have said avoid being negative about people. The last time I was voluntarily looking (the last time I was looking was due to...
January 25, 2008 at 1:03 pm
DB_Newbie2007 (1/25/2008)
My query using all of the derived tables took 1 hour, 13 minutes to run.
Mark's query using the group/having clause took 14...
January 25, 2008 at 11:29 am
I have submitted to pre-employment drug and criminal background checks and have no problem with either. I also have been randomly drug tested as well.
I personally think drug testing...
January 18, 2008 at 6:57 am
First I would write a simple .NET service that monitors the directory where the XML is located and loads the XML into the database and then archives the file. ...
January 11, 2008 at 11:20 am
In your dataflow your oledb piece is a destination thus it cannot be the source for a nother transform. In the COntrol Flow window add another dataflow task to...
January 11, 2008 at 10:03 am
Viewing 15 posts - 9,256 through 9,270 (of 9,641 total)