Viewing 15 posts - 2,791 through 2,805 (of 5,590 total)
GilaMonster (10/17/2010)
Tom.Thomson (10/17/2010)
What's the betting he calls you all sorts of names
Yes
and says the idea of having a stored procedure is an unwanted overhead?
Don't think so. More likely, I...
October 17, 2010 at 4:12 pm
Mike John (10/17/2010)
Snap!It would have been hard to get two answers closer...
Mike
Nah, I've seen the same answer from different folks come in within the same minute before here.
October 17, 2010 at 11:06 am
Paul White NZ (10/17/2010)
Craig's test data (267,150 rows): 360ms
Jeff's test data (889,892 rows): 1386ms
Test rig and csv data for both runs attached, along with C#...
October 17, 2010 at 11:04 am
GilaMonster (10/17/2010)
Lennie's back...
(After reading past posts)... Ohhh, that Lennie
May I suggest that everyone just ignores that? I don't think we need another flaming thread here.
Ignored
October 17, 2010 at 10:50 am
Alvin Ramard (10/17/2010)
GilaMonster (10/17/2010)
With some sample code that looks like an interesting cross between T-SQL and an object-orientated language.
SELECT .... WHERE OrderDate.Month = 2
May I suggest that everyone...
October 17, 2010 at 10:46 am
I just read through this thread, and what I found interesting was what was missing (or, I just failed to see it...)
The keys in a clustered index are used in...
October 16, 2010 at 12:20 pm
When composing your post, look below, in the "Post Options" section. There is a section titled "Attachments", with a button on the right that says "Edit Attachments". Click that button....
October 16, 2010 at 10:16 am
GilaMonster (10/16/2010)
Is anyone willing to bet some money on whether he has a clean backup or not?
I'll bet... that he doesn't.
October 16, 2010 at 10:06 am
GilaMonster (10/16/2010)
Me: Run CheckDB and and post the full and unedited results
OP: I have used that command and it returned about 3000 line of error code. This is last...
October 16, 2010 at 9:56 am
What college and professor gave you this homework assignment?
Why did you try to obscure your homework assignment by posting this as a company/account issue?
October 16, 2010 at 9:25 am
"I've got this task, needs to be done in an insert trigger".
So, I give the code for doing so.
"Now, can you incorporated it into my already...
October 16, 2010 at 9:20 am
Lynn Pettis (10/15/2010)
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
-Variables which 'reflect' existing table meta data
-Custom data types
-Multiple 'methods' within the package all...
October 16, 2010 at 7:00 am
In SSMS, select Edit | Intellisense | Refresh Local Cache
Apparently, you built the function after opening the query window.
October 16, 2010 at 6:58 am
Dehqon D. (10/16/2010)
Hi Forum,I've to tables with one-to-many relationships (T1 and N2)
Current queries giving me different results which is making me confuse.
select COUNT(*) from N2
Result:122263
There are 122263 records...
October 16, 2010 at 6:55 am
Viewing 15 posts - 2,791 through 2,805 (of 5,590 total)