Automatic Web Traffic Generator

How to insert into SQL Server system tables

Ad hoc updates to system catalogs are not allowed. In SQL Server 2005, you cannot enable updates to the systems catalog because they are no longer tables. In order to accomplish what you are doing, yo... read more

SQL Server Monitoring: What to start measuring

So you’ve got a SQL ... BIGINT, server_name NVARCHAR(128), insert_datetime DATETIME DEFAULT(GETDATE())) GO CREATE CLUSTERED INDEX cx_wait_statistics_id on wait_statistics_history(wait_statistics_id); ... read more

Using SQL Bulk Insert with the .NET Framework

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power. SQL Bulk Insert is not a new technology. In fa... read more

Executing Stored Procedures

Owner-qualifying objects is simply a good habit to get into. It's one of those things you can do to save yourself problems down the road. The INSERT command supports ... spaceused queries several of S... read more

Microsoft BCP Performance on Sqoop EXPORT to SQL Server From Hadoop

We've gotten everyone connected to SQL Server using Progress DataDirect's exclusive support for both NTLM and Kerberos authentication from Linux with Sqoop. Now, we plan to blow your minds with high-f... read more

Faking Temporal Tables with Triggers

This post is a response to this month’s T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way for the SQL Server ... table, the dbo.BirdsHistory table will be updated exactly like a regular ... read more

SQL Server and .NET Core 3.0

Bryan Cantrill explores Rust, explains why it has captured the imagination of so many systems software engineers, and outlines where it might best fit in the deep stack of operating system software .. ... read more

SQL Server 2016 Preview Reveals Path to Azure and Big Data

And, not to omit Azure, PolyBase also has connectors into ... the ANSI SQL 2011 standard, SQL Server 2016 now includes this feature. In a temporal table, the start and end date columns are SYSTEM_TIME ... read more

Using newid in SQL Server to insert records in parent-child tables

To get the result that you require, the newid can be placed into a local variable in your SQL script and used to insert into both tables. Let's start with the tables and the foreign key: CREATE TABLE ... read more

How to Query JSON Data with SQL Server 2016

JSON is a text-based way to depict the state of an object in order to easily serialize and transfer it across a network from one system to the next ... to save JSON data into one column of a database ... read more

The Whys and Wherefores of Untrusted or Disabled Constraints

Moreover, neither can the SQL Server ... If a table is of any size, and you are inserting into an empty table, it is worth considering disabling constraints for the duration of the insert and ... read more