meta user
network profile
| bio | website | randomlyagile.blogspot.com |
|---|---|---|
| location | Colorado | |
| age | 43 | |
| visits | member for | 1 year, 5 months |
| seen | Dec 28 '12 at 21:02 | |
| stats | profile views | 9 |
.NET / Database Developer, primarily C# and SQL Server 2005 / 2008. Agile evangelist for most of the companies I've worked for.
|
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 |
homework wiki description added 547 characters in body |
|
Jan 26 |
revised |
homework wiki excerpt 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 homework tag wiki excerpt |
|
Jan 26 |
suggested | suggested edit on homework tag wiki |
|
Jan 26 |
wiki | created homework description |
|
Jan 26 |
wiki | created homework excerpt |
|
Jan 26 |
answered | Scrubbing Names via SQL Query/Batch |
