Viewing 15 posts - 511 through 525 (of 1,193 total)
Lynn Pettis (3/13/2013)
I will disagree with this statement "But I would bet that no, C++ would always have an order of magnitude of advantage over Stored Procedures." completely.
Me too.
Isn't that...
March 13, 2013 at 10:05 am
You're grouping on , but none of the other fields returned are grouped on or are aggregated in any way - they need to be in order for it...
March 13, 2013 at 8:31 am
No problem. If you have the time, that whole book's worth a read 🙂
March 12, 2013 at 6:29 am
Probably just as Gail says - them's the rules!
I'd speculate that it's for separation - if you allow say getdate() to be passed, where do you stop? Entire queries to...
March 12, 2013 at 6:27 am
It's based on time rather than no. of attempts. The default value is 10 seconds - so if no successful ping is received in a 10 second period failover will...
March 12, 2013 at 6:15 am
You can't apply functions to a parameter directly in the procedure call, you have to do it prior to the execute as you have with the first two calls.
March 12, 2013 at 5:53 am
Hi David,
Totally normal, data is loaded into memory and served from there as it's much quicker.
It's generally good practice to set the max server memory setting to a reasonable setting...
March 12, 2013 at 5:33 am
Good improvement!
What was your solution? Looks almost like a double triangular join with those not exists!
March 12, 2013 at 5:14 am
Well, I think you've got both ends of the argument there in the last couple of posts!
But what's with the paranoia over DBA's Francesco? We're not all bad 🙂
March 11, 2013 at 5:55 am
opc.three (3/8/2013)
Ha, I still do not know the backstory on that one but it sounds funny. Building on that, maybe DBCC MIDDLE_EARTH since it involves a hobt_id?
Ah yes, know that...
March 8, 2013 at 9:56 am
Hi Jerry,
You might be able to get a rough idea from backup history. Definitely only a guide though!
select server_name, database_name, backup_start_date, backup_size
from msdb.dbo.backupset
where type = 'D'
and database_name =...
March 8, 2013 at 3:16 am
SQLRNNR (3/7/2013)
Looks like we may have a fun day with this question.
Looks like you're right 🙂
March 8, 2013 at 2:44 am
Viewing 15 posts - 511 through 525 (of 1,193 total)