Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-19
3,076 reads
Articles
2009-10-19
3,601 reads
How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server
Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a
2009-10-16 (first published: 2008-01-09)
57,925 reads
2009-10-16
4,524 reads
Performance Improvement: Understanding
This article will cover the core understanding of the performance conversation
2009-10-16
3,675 reads
The Future of Bits
Feel like making a prediction this Friday? Steve Jones looks to the future with information workers and a knowledge economy. Answer this Friday poll and give us your guess about the future.
2009-10-16
136 reads
The Future of Bits
Feel like making a prediction this Friday? Steve Jones looks to the future with information workers and a knowledge economy. Answer this Friday poll and give us your guess about the future.
2009-10-16
113 reads
The Future of Bits
Feel like making a prediction this Friday? Steve Jones looks to the future with information workers and a knowledge economy. Answer this Friday poll and give us your guess about the future.
2009-10-16
104 reads
Work on a Strength or Weakness?
When deciding what to learn, there's a binary decision. Will you focus on a strength or a weakness? I think many people focus mostly on their strengths because they have a goal of really standing out in something. They perhaps want to avoid being..
2009-10-16
1,577 reads
Poor Man's Enterprise Feature - Lock Pages in Memory
Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this article to see how you enable this setting in SQL Server.
2009-10-15
8,819 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers