Using DMVs to improve SQL index effectiveness
Dynamic management views measure the effectiveness of indexes and discover fragmented indexes that may slow down SQL Server.
2009-02-18
3,072 reads
Articles
Creating Mining Structure - SQL School Video
In this SQLSchool video, MVP Brian Knight shows us how to create a simple data mining model in Analysis Services.
2009-02-17
2,881 reads
Using Checkpoints in SSIS (Part 1)
SSIS is a great platform for building ETL type applications with SQL Server. One of the great features that you can use are checkpoints, which allow you to restart a package that is partially completed. New author Aaron Akin starts a series on how to use this depth.
2009-02-17
7,780 reads
Managing Files with SQL Server 2008's FILESTREAM Feature
SQL Server's new FILESTREAM feature simplifies the process of keeping file-based data, such as images, in sync with relational data.
2009-02-17
2,743 reads
Networking - Part 4
You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...
2009-02-17
1,530 reads
New Features in SQL Server 2008 Management Studio – Part 1
This article shows the new features that are available in SQL Server 2008 Management Studio
2009-02-17
5,046 reads
The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
2009-02-17
475 reads
The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
2009-02-17
744 reads
The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
2009-02-17
506 reads
SQLBits IV and a Day of Training
SQLBits IV is taking place this March in Manchester. Read on about where to register and how to get some training the day before as well.
2009-02-16
576 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
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...
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