Apr
3
awarded Popular Question
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.
Jun
10
awarded Self-Learner
Jun
10
answered What throughput should I expect with MPIO?
May
29
comment What throughput should I expect with MPIO?
Yes, partitions are aligned to 1024k. File allocation size is 64k.
May
29
comment What throughput should I expect with MPIO?
@mrdenny - In the first example above, I used several common IO sizes and the results were roughly the same. When you ask about block size, do you mean "Bytes Per Cluster" in fsutil? It's 64k. This is Win2003 so I've run diskpart and fsutil.
May
29
comment What throughput should I expect with MPIO?
Thanks Nathan. Should I be expecting double the throughput with two NIC's and MPIO?
1 2 3 4 5