There are a number of ways to issues CTIs (Current Time Increments) into your StreamInsight streams but a quite useful way is to do it declaratively on your source factory like this
2010-09-09
1,492 reads
A review on the basic steps to correct a poorly performing query
2010-09-08
12,516 reads
You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue the problem, even with expert queries. So what constitutes 'wrong RDBMS design? What are these errors that continually crop up? How can you recognise them and fix them? Joe embarks on a new series of articles by identifying a series of bad practices based on the habit of 'splitting' that which shouldn't be split.
2010-09-08
2,767 reads
Hope you got plenty of rest over your Labor Day holiday because the PASS Virtual Chapters have some great free training lined up for you.
2010-09-07
1,127 reads
Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.
2010-09-07
12,945 reads
We use Internet Protocol Security (IPSec) within the trusted domains, but use the Negotiate Security Support Provider for our web applications. What other security methods can we employ with SQL Server?
2010-09-07
2,304 reads
New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.
2010-09-06 (first published: 2009-09-28)
24,432 reads
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,491 reads
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..
2010-09-06
3,710 reads
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!
2010-09-03
4,102 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers