New answers tagged

1

I just got your code to work on my end. Try this: Option A Assign Full Control NTFS permissions to 'C:\BCPFiles\bcpFile.dat to the user you will use in SQL Server Management Studio to run the query Re-run your query in SQL Server Management Studio Option B Or, just to get past the following error try: Error = [Microsoft][ODBC Driver 11 for SQL ...


1

Is going to be hard to find something that excels both at data ingress (accepting +50k rows per second) and ad-hoc querying an arbitrary EAV time series (timestmap, signal_id, signal_value). I would give clustered columnstore a try. Clustered columnstore would leverage segment elimination on timestamp and clustered columnstores also have better concurrency ...


1

This is a long shot but seen as you are running SQL 2014 Enterprise I would have a test with using a Clustered Columnstore Index on this table and see if this improves performance for you. Especially considering that you are using the table for selects and bulk inserts only - no updates and no deletes. You will have the added advantage of taking a bit of ...


0

Querying the table in any way takes eons. While queries are running against the table, the BCP processing basically stops. Its like all processing power goes to the query and I get a files backlog. How do I speed up query performance? I should note that rows in this table will never be updated or deleted. Also, it's possible that data could be inserted ...



Top 50 recent answers are included