Viewing 15 posts - 56,671 through 56,685 (of 59,072 total)
The real killer would be the presence of a clustered index or a great many non-clustered indexes. Unless you use SELECT/INTO, the Simple Recovery Mode won't be of much help...
April 1, 2007 at 9:47 am
What do you want the CSV file to look like for column headers?
March 31, 2007 at 9:00 pm
Would be a bit more helpful if you posted the code so we can see what you did wrong. For example, in the SELECT you posted in your message, the...
March 31, 2007 at 8:55 pm
I, for one, have enjoyed the simple yet educated rhetoric spawned by this editorial. The reason for most of the passion displayed is likely because of personal experience and...
March 30, 2007 at 10:27 pm
Heh... yeah... how silly of me to think it might have been an SQL Server question on an SQL Server forum... not enough coffee and I missed that... thanks, Julie.
March 30, 2007 at 10:14 pm
I'm thinking that we should keep "real" religion out of this...
By the way, I did find my iron ![]()
March 30, 2007 at 6:44 am
Yep... strayed just a bit... I think Peter meant "would a CLR be an appropriate place to build a function"? If not, that's the way I took it and I...
March 30, 2007 at 6:37 am
Outstanding! Thanks for the feedback!
March 29, 2007 at 5:22 pm
Agreed... WHEN you have an application... and if you save the data into a table with the correct decimal data type, takes no time at all.
March 29, 2007 at 6:53 am
Thanks Ken... haven't had the opportunity to work with 2005 to any great extent. Appreciate the time you took to explain it.
March 29, 2007 at 6:41 am
You bet, Pam. Let us know how it works out.
March 29, 2007 at 6:05 am
Yep... it is strange... the function does Index Seeks on the 2 part index and the outer Select that uses the function does and Index Scan because it's looking at...
March 29, 2007 at 5:57 am
I know squat about CLR's... can you call a proc in a CLR?
March 29, 2007 at 5:48 am
Actually, I did that... and a couple of other renditions, as well.
March 28, 2007 at 10:07 pm
Viewing 15 posts - 56,671 through 56,685 (of 59,072 total)