Reputation
2,913
Top tag
Next privilege 3,000 Rep.
Cast close and reopen votes
Badges
1 4 20
Impact
~247k people reached

2d
comment Most effective way to manage a growing list of time series data in an MS Access database
SQLExpress let's you import a CSV file very easily, or you could script it out as Peter mentioned in BCP. SQLExpress will be a lot faster and flexible than Access and is free. See: support.discountasp.net/kb/a1179/… and blogs.technet.com/b/heyscriptingguy/archive/2011/11/28/…
2d
comment Is there an advantage to not partition aligning an index?
Possibly. Query your index statistics usage to see if that index is being used. If so, use extended events or a server side trace to capture what queries are hitting that index. If they would perform better on a partition aligned index, great. If not, check to see if they actually need non aligned partitioned indexes. If they don't, I'd say make it partition aligned anyways as future queries can take advantage of it. Of course, if the cost/effort/outage is too high then don't.
2d
comment Will restarting SQL Server clear my transaction log?
There's lots of reasons, what is the symptom of the problem? If the tlog was full in simple recovery mode and couldn't get more space you'd get an error, or it'd try to 0 out the new space added to the LDF file and then allocate it. During this time writes are blocked and you could see timeouts.
Apr
30
awarded  Nice Question
Apr
29
reviewed Approve How to load 100k + Records into progres database from a CSV file?
Apr
29
reviewed Approve Lab test database modeling help
Apr
29
reviewed Approve Normalization of library book table with multiple authors
Apr
28
comment SQL Server ; working around collation mismatches
Reminded me of a problem during my Jr. DBA days. :)
Apr
27
reviewed Approve Column Datatype Conversion Question
Apr
27
comment Most effective way to manage a growing list of time series data in an MS Access database
Have you looked at SQL Express?
Apr
27
comment Need advice on abnormal login auditing
woah why do you have your DB open to the public internet? Secondly, it looks like they are only use 'sa' and 'hbv7', so the question is, is there a hbv7 user? If there is then they know your user names which means your security is already some how compromised. Whether it's social engineering, disgruntled employee, stolen user name list, something. Do you have a user by that name?
Apr
23
comment Repair SQL server 2000
why do you need to repair it as opposed to re-installing it?
Apr
21
comment Migrating DB, SSIS packages, SSRS Reports from 2008 R2 to 2012
Got it. I would just break down the movement in smaller manageable chunks if possible. For example, your data flow requires data somewhere (seems like the SQL DB), then transformations and ETL is done in SSIS, and then finally Reporting Svc reports the final outcome to the business I'd recommend moving it and getting it to work in that order. First focus on the DB data migration and quality checks, then get SSIS working, and once you're fully comfortable with that, I'd suggest finally moving to SSRS. Let us know if we can help in any way.
Apr
20
answered Migrating DB, SSIS packages, SSRS Reports from 2008 R2 to 2012
Apr
15
comment SQL Server 2008 R2 : Unexpected timeout with SQL Agent Job/powershell
Can you post your powershell code? I know you mentioned sqlcommand but some cmdlet's such as invoke-sqlcmd had minor bugs with timeout settings, and this would be nice to confirm what's happening.
Apr
15
answered Getting Data Back after Wrong Data Restore in SQL Server
Apr
15
answered Moving a SQL Cluster to Another Data Center w/No Downtime
Apr
9
comment How to scale a write intesive application with a SQL Server 2014?
Please provide a lot more background information such as the current pain points, budget restraints, current methods being looked at and so fourth. Unfortunately with the data provided this question will be closed very soon. Federation is just 1 of many solutions out there and you might be just grasping at straws at the moment.
Apr
8
comment SQL Server 2012 Express installation failed
Are you trying to upgrade by any chance? It's kind of acting like an upgrade is taking place. I mainly say that due to the entries that it's rolling master forward and that it can't execute the commands that create a MASTER SERVICE KEY. This key uses the Windows DPAPI's to create a unique key for the server that then you can create other keys from. I haven't noticed this in my installations but I don't install express. Perhaps Master is just a blank DB that's copied and rolled fwd but figured I'd ask.
Apr
8
comment Delete files from disk, with a job, respecting some rules ( SQL Server 2008 )
Hi @RafaelPiccinelli, did you need any more help with this? Have you tried just wrapping the files with spaces within them in single/double quote wrappers? I think the join-path file type would also handle spaces without issues but I haven't tested.