The issuing of a Current Time Increment, Cti, in StreamInsight is very definitely one of the most important concepts to learn if you want your Streams to be responsive. A full discussion of how to issue Ctis is beyond the scope of this article but a very good explanation in addition to Books Online can be found in these three articles by a member of the StreamInsight team at Microsoft, Ciprian Gerea.
A free, one day training event taking place on October 16, 2010 in Orlando, FL.
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
Today Steve Jones talks about the upcoming SQL Saturday #52 in Colorado, and how it's encompassing more than just a day of SQL learning.
The first SQL Saturday in San Diego kicks off fall with a full day of free SQL Server information, lectures, and seminars from the experts on the West Coast.
Andrew Calvett talks Analysis Services for the September meeting of the Kent SQL Server user's group.
SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.
Phil Factor initially brooded about being fired from a job he was just doing unpaid to help out. Then he suddenly realized that they were probably right.
There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!
Learn the top 10 best practices for large scale SSIS packages from a real world DBA.
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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') AND BusinessEntityID IN (7,8)See possible answers