If you're looking for the user actually executing the script or stored procedure can't you just use system_user select system_user ???
Actually I determined that the SS disks I was considering don't work in the particular box we're purchasing....so no longer a consideration. It...
We are building the order for a new production server (datawarehouse, heavy random reads & sorting). Considering some use of SSD technology - DB...
Perfect!!! Thank you very much!! [:D]
We have a few very large tables distributed on files other than the PRIMARY. Is there an easy way to find what tables are on the different database...
Are you logging on to your workstation with the service account or actually logging on to the server itself?? When SQL Agent runs the job, the...
FWIW - I've recently had to resolve occasional (ie. 4-5 out of 200+) processes which ran much slower on 2005 (after upgrading from 2000) - every one...
Happy Again!! My problem was on an HP box where there is also an apparent iLO bug/compatibility problem that exacerbates or triggers the memory...
There is an issue with Windows 2003 and SQL Server 2005 on 64-bit where Windows will flush SQL Memory down to the minium - see KB 918483. One of the...
If you have two physical drives available for strictly TEMPDB use in a DW environment - is there a consideration of a two-drive Raid 0 array as...
Insults aside, I apparently gave you more credit and respect than I should have. It would be obvious from comparison of the respective hardware,...
Don't burst your aorta! I'm not trying to debate you on technical intricacies of SQL Server internals!! Given that I've seen the 2000 vs 2005...
joechang: To follow on your comments regarding my 'rant' - the particular proc I've been troubleshooting generates intermediate temp tables and is...
I sympathize with your frustration!! I spent a couple hours a day for four weeks trying to benchmark performance differences between two different...
Separate names with a comma.
