May
18
awarded Yearling
Apr
3
awarded Popular Question
Feb
15
awarded Scholar
Feb
15
comment Do 414(h) rollovers need to be included on form 1040 Line 16?
Thanks. Funny...I received the 1099-R today.
Feb
15
accepted Do 414(h) rollovers need to be included on form 1040 Line 16?
Feb
14
asked Do 414(h) rollovers need to be included on form 1040 Line 16?
Nov
5
answered SQL Server Agent: QUOTED_IDENTIFIER
Oct
22
comment Log sizes unexpectedly large: log_reuse_wait_desc == "log_backup"
When you say "high-availability mode" do you mean Database Mirroring? Log truncation can be delayed if the mirror falls behind, but I think the log_reuse_wait_desc shows something different than what you're seeing.
Oct
22
comment Log sizes unexpectedly large: log_reuse_wait_desc == "log_backup"
What documentation indicates you need two backups for log truncation to occur? That statement is not correct.
Oct
20
comment Log sizes unexpectedly large: log_reuse_wait_desc == "log_backup"
Are you sure you've taken a successful transaction log backup? Does the result of this query make sense: SELECT MAX(backup_finish_date) FROM msdb.dbo.backupset WHERE [type] = 'L' AND database_name = 'mydatabase'
Oct
14
awarded Notable Question
Sep
13
answered Count duplicate versions of databases (SQL Server 2008 R2)
Jul
27
comment sql server-percentage calculation
Jon - ah, you are correct, I missed that at first. I tweaked the query, I believe that should get the OP what he's looking for.
Jul
27
revised sql server-percentage calculation
Tweaked the query after commenter pointed out something I missed.
Jul
27
answered sql server-percentage calculation
Jul
10
awarded Nice Question
Jun
17
comment How to avoid empty rows in SSIS Excel Destination?
I did the same on my test machine, however wasn't real keen on installing anything on the client's server. In the end, we were able to convince the client to go with CSV. Then I was able to use Powershell, soooo much easier than SSIS.
Jun
15
comment How to avoid empty rows in SSIS Excel Destination?
Thanks Jon. Yes, I'm using 97-2003. When I select 2007, I get "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine." My test machine is Win7 with SQL 2008 R2. Agreed on the CSV format, I've already suggested that, but the client wants Excel.
Jun
15
asked How to avoid empty rows in SSIS Excel Destination?
Jun
10
comment What throughput should I expect with MPIO?
Not sure, we haven't been able to figure that out yet. I will post back if I figure it out.
1 2 3 4 5