Datetime Functions

Technical Article

RE: as database grows, performance slows, which way to go?

  • Reply

First, please confirm: A previous poster suggested segregating the data by time period. Given that you note that the data will reach a maximum of 5,000,000 records, and your weekly addition of 100,000, I assume that this will ultimately either restart every (fiscal?) year, or end up being a running tally of the last 12 […]


Technical Article

SQLXMLBulkLoad C# Issue on Insert :: URGENT HELP!

  • Topic

I have a large dataset (names; in this context) of more than 50000 records which i wanted to dump into SQL Server using SQLXMLBulkLoad. I use C# and here is how i implemented:// Initialize OLEDB Connection for SQLXML Bulk LoadSQLXMLBulkLoad3Class bl = new SQLXMLBulkLoad3Class();bl.ConnectionString = ConUtil.GetBulkXMLConString();//bl.KeepIdentity = true; bl.BulkLoad = true; //bl.Transaction = true;bl.ErrorLogFile = "BulkImport.log";bl.ForceTableLock […]


15 reads


Daily Coping 26 Jan 2023


Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell


Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project


SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs


SQL Table Issue

By Jobs90312

Hi everyone, In below code I am creating a table and inserting some english...

what does the backup log init do?

By vpmaciel

what does the backup log init do?

Backup Log Init run again by mistake manually.

By vpmaciel

backup log to int run every hour. If a log init backup is run...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers