350 reputation
19
bio website randomlyagile.blogspot.com
location Colorado
age 44
visits member for 2 years, 8 months
seen Aug 5 '13 at 1:58

.NET / Database Developer, primarily C# and SQL Server 2005 / 2008. Agile evangelist for most of the companies I've worked for.


May
30
awarded  Revival
Dec
16
awarded  Yearling
Feb
2
awarded  Critic
Feb
2
comment how to send mail from gmail smtp server by using the ssis
@shamim sriharik.blogspot.com/2008/08/… That should work in SSIS 2005, since you're limited to VB.NET only.
Jan
30
comment Optimization: Delete with Top and minimize the where clause date range
@ypercube I was basing the "delete all data" condition on his verbiage in the first sentence, not the SQL he posted, but yeah, if he's leaving anything, truncation won't work.
Jan
30
comment Columns are added in wrong order
That doesn't seem terribly surprising to me. You're doing column adds, so the batches are having to get schema locks and if for some reason, the second batch compiles faster, or they both get blocked waiting to get the lock and the second one jumps in first, well, it wins. You aren't guaranteed order of statement operations between batches, only internal to a batch.
Jan
30
comment Optimization: Delete with Top and minimize the where clause date range
Since you're deleting all data out of that table, is there any reason you're not using a TRUNCATE statement instead of a DELETE statement? Is something foreign keyed onto that table so that you can't use truncate?
Jan
28
comment SQL Server 2005: Job scheduled every 4 hrs, but sp_help_jobactivity shows unexpected value for next_scheduled_run_date
Uhh... the GUI is showing you the start / end times (in case you need / want to only allow a job to run during certain times). The next run time was correct (12:01 PM) considering that the job would run @ 12:01A, 4:01A, 8:01A, 12:01P, 4:01P, 8:01P each day and it's currently 11A.
Jan
27
awarded  Analytical
Jan
27
comment SLEEP_TASK Wait Type in SQL Server - What does it indicate?
Are you getting them on any specific types of queries / jobs or on pretty much everything? Only thing that comes to mind is to check that your server isn't limiting worker threads or something bizarre like that.
Jan
26
comment Why is SQL Server 2008 R2 Management Studio making me login again?
New PC power settings? Like the PC (or network card) is going to sleep and dropping the network stack or something like that maybe? AFAIK, there's nothing in SSMS that controls this, or at least, nothing I've ever set anyways. :)
Jan
26
awarded  Tag Editor
Jan
26
revised
added 547 characters in body
Jan
26
revised
added 207 characters in body
Jan
26
revised Scrubbing Names via SQL Query/Batch
Grammar. I haz it.
Jan
26
comment Theta join explanation
It's not wrong to ask homework questions on the SE sites, but you should tag them as such. It's mainly an etiquette thing.
Jan
26
suggested suggested edit on
Jan
26
suggested suggested edit on
Jan
26
wiki
Jan
26
wiki