Big Data: Integration with Little Data
If we want to incorporate big data into our enterprise, it's crucial to know how to integrate it with our existing data.
2014-03-06
5,076 reads
Articles
Vote Now: Final Service Packs for 2008/2008 R2
Microsoft has continued to release Cumulative Updates, with each one specifying that customers should wait for the next service pack if they don't experience an issue. However, no Service Packs have been released for some time. Let Microsoft know we want Service Packs.
2014-03-06 (first published: 2014-02-28)
4,471 reads
Junk Drawer
Dale Newman created open source project called Junk Drawer. It's goal is to make the majority of Excel or text file importing a one step, no-brainer process without using the Import Wizard.
2014-03-05
3,095 reads
Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization
Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe case of 'Cache Bloat' due to ad-hoc queries, but you can't fix the code itself. What should you do? Specify forced parameterization? Perhaps a better idea would be to use guide plans.
2014-03-04
2,646 reads
SQLSaturday #269: SQL South West, Exeter, UK
SQL South West user group are running their second SQL Saturday on March 21st and 22nd and have another spectacular schedule of technical content from SQL Server professionals from the UK, Europe and USA including SQL Server MVPs and Microsoft staff. All the session details and how to register for the full-day pre-con sessions or the free-to-attend Saturday:
2014-03-04
1,702 reads
The SQL TABLE Type: Beyond Table-Valued Parameters
Follow along as this starter article on the SQL TABLE Type walks you through the various ways it can be used in T-SQL.
2014-03-03
10,642 reads
Avoid using NOLOCK on SQL Server UPDATE and DELETE statements
Occasionally I come across UPDATE and DELETE statements where the target SQL Server table is referenced with the NOLOCK hint. Does this hint help or hurt performance in this case?
2014-03-03
4,698 reads
SQL Saturday #269 - Exeter, UK
SQL Saturday is coming to Exeter on March 22, 2014. Join Red Gate's David Atkinson and the rest of the speakers at this free day of SQL Server training and networking, organized by SQL South West.
2014-03-03
1,737 reads
See Grant Fritchey and Steve Jones at SQL Intersection
Come see Grant Fritchey and Steve Jones (from Red Gate Software) and many more SQL Server experts while you enjoy spring in Orlando, FL at SQL Intersection.
2014-02-28
424 reads
Calculating Gaps Between Overlapping Time Intervals in SQL
There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a number of techniques around that work, but finding ones that scale well makes for a tougher, but interesting, challenge.
2014-02-28
3,824 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers