317 reputation
18
bio website
location East Coast
age
visits member for 1 year, 7 months
seen Apr 1 at 12:32

SQL Server DBA


Mar
20
awarded  Tumbleweed
Mar
13
asked Managing code and deployments to Amazon Redshift
Oct
22
comment ~2 Hours after a large insert SQL Server gets “I/O requests taking longer than 15 seconds to complete”
I'm curious why you think the large insert and the problems that happen 2 hours later are related. Can you move those schedules around (maybe up a few hours) and see if the problem recurs? As a few other posters have suggested, I think something else is touching the disks at that time. What else is using that SAN?
Sep
6
awarded  Yearling
Jul
16
comment SSIS hangs during For Each File enumeration
Are you positive that your script task has actually succeeded, and hasn't thrown up a little exception window waiting to be acknowledged? I would put some error handling and logging in there so I can see excatly where its at.
Jul
3
comment Dealing with identity ranges for transactional replication
Why would you need to synchronize the identities manually? Just write a stored procedure at the subscriber that runs checkident for each table that you are storing temporary delta's in, and run it after the snapshot finishes applying. The distribution agent will insert changes as they happen in the "real" identity range, and the changes made directly to the subscriber will be in the negative range.
Jul
3
answered Dealing with identity ranges for transactional replication
Jul
1
awarded  Scholar
Jul
1
accepted Transactional Replication - Snapshot metrics
Jul
1
comment Transactional Replication - Snapshot metrics
Thanks Kin - sounds like it is not possible. I will mark it as accepted.
Jul
1
awarded  Student
Jul
1
asked Transactional Replication - Snapshot metrics
Jun
26
answered Unused Indexes - Consider Primary Key Constraint Supporting Indexes?
Jun
14
answered Database denormalization: multiple rows into single column. How bad is it?
Jun
4
comment How should I best handle a rapidly growing database?
Can you tell us the recovery model you are using? Also, can you expand on what you mean by "deleted and then imported"?
May
28
awarded  Revival
May
28
awarded  Editor
May
28
revised Error trying to run SSIS Packages in SQL Server 2008 SQL Server Agent
added 8 characters in body
May
1
answered Error trying to run SSIS Packages in SQL Server 2008 SQL Server Agent
Mar
28
awarded  Critic