Analyzing the SQL Server Plan Cache
Keeping in mind the importance of the cache mechanism, how could one get the plans and their usage statistics in SQL Server?
2009-01-19
4,183 reads
Articles
The Hassles of Travel - Part 2
I didn't want to go on this trip, but I agreed to do it. Now I regret it. My flight to Chicago was fairly uneventful, but it was running late. At 4:30CST the pilot says we should be on the ground in 30 minutes, which is good since I have to get to...
2009-01-19
198 reads
The Story of the TV Stand
We all have those things that happen at work that somehow turn into something other than expected, and sometimes in quite humorous fashion. I've got a few to share over the next couple months, but had to start with this one!
2009-01-19
160 reads
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this.
2009-01-17
69 reads
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
2009-01-17
805 reads
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
2009-01-17
472 reads
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
2009-01-17
517 reads
Hidden RBAR: Triangular Joins
Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.
2009-01-16 (first published: 2007-12-06)
60,451 reads
Adobe AIR: Running SQL Commands Against a Local Database
Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.
2009-01-16
4,334 reads
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this.
2009-01-16
88 reads
Blogs
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers