FOR XML Clause
FOR XML CLAUSE: Sometimes we need to data in form of XML from
Database.SQL Server provide FOR XML Clause. For XML clause...
2012-12-26
793 reads
Blog Posts
NULL Values Impact the Performance of MAX() and MIN()
We know that we need to take special attention about NULL values while writing queries because they may lead us into...
2012-12-26
2,343 reads
Querying the Procedural Cache: Just in Time for the New Years’
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for...
2012-12-26
1,507 reads
SSIS Precedence Constraint Tutorial
Recently we decided to create a series of videos for our SSIS Precedence Constraint Tutorial which is part of our...
2012-12-26 (first published: 2012-12-18)
9,214 reads
Big Data - An Introduction to Pig
In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to...
2012-12-25
455 reads
Index Analysis: The Re-Return
A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...
2012-12-25 (first published: 2012-12-18)
3,294 reads
Last Weeks Top 10 “Reading” Links #12
Happy holidays, seems this post missed coming out this morning as typically scheduled. Thus, a late afternoon post on this...
2012-12-25
724 reads
2012-12-25
917 reads
On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!! What could be better than bacon wrapped frog legs? Oh yeah, more Virtual lab...
2012-12-25
8 reads
On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!!
What could be better than bacon...
2012-12-25
1,143 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers