This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated. This component is used by us to do testing of the pipeline and components downstream.
2012-07-27
2,236 reads
SMO can be a valuable tool for working with SQL Server when you don't have access to all the tools that come with the platform. In this article, SMO helps solve an issue with a SQL Server.
2012-07-26
726 reads
Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always proved to be tricky for the relational model. They can be used very effectively where the attributes are sparse for any given entity and very numerous across all entities. Seth Delconte shows how to use them.
2012-07-26
1,410 reads
Free training in New York. Come learn about SQL Server, meet other pros, and then enjoy a night in the city.
2012-07-26
1,402 reads
Red Gate Software is looking to offer a new monitoring service and is looking for opinions and ideas in making it happen.
2012-07-25
1,259 reads
We’ve all heard about Extended Events and how they can help troubleshoot SQL Server performance, connectivity, and locking problems, but they seem so difficult to implement using T-SQL. Isn’t there a better way to implement SQL Server Extended Events?
2012-07-25
3,142 reads
On Thursday July 26th 12PM noon Central, Ami Levin will revisit some of the fundamental principles of relational databases – normalization rules, key selection and some controversies surrounding these rules.
2012-07-25
1,559 reads
This article demonstrated the steps which you must follow to gracefully truncate the publisher database transaction log file by resetting replication.
2012-07-24
11,699 reads
Wednesday July 25 2012, 6:00pm BST: Learn how you can use SQL Monitor to gather information and alert on extra performance data for your servers and applications, making this tool vital for keeping an eye on your business. In this free webinar David Bick, Product Manager at Red Gate, will give you an overview of SQL Monitor including the new custom metric functionality in v3.
2012-07-24 (first published: 2012-07-06)
4,981 reads
When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
2012-07-24
2,689 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
How I used AI for this postChatGPT to generate images based on info specifically...
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...
Comments posted to this topic are about the item Adding new column with DEFAULT
I've got a web application for my side business. I've added a SQL Server...
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers