What is a Good Way to Run CheckDB on a VLDB?
Introduction
Today’s script is one that I wrote based on the logic outlined in this post by Paul Randal (Blog|Twitter). This...
2010-05-21
556 reads
Blog Posts
What is a Good Way to Run CheckDB on a VLDB?
Today's script is one that I wrote based on the logic outlined in a post by Paul Randal. This script is written for SQL 2000 but, as Paul notes,...
2010-05-21
14 reads
Daily SQL Server 2008 New Feature – Day 11
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-20
429 reads
2010-05-20
771 reads
New SQL Standard Article
A new article for the SQL Standard is now available. You can find the article here. The article is by...
2010-05-20
605 reads
Plagiarized
Today I ran into an interesting website. While I was trying to locate information concerning a SQL Saturday event, I...
2010-05-20
537 reads
Plagiarized or Copied
Today I ran into an interesting website. While I was trying to locate information concerning a SQL Saturday event, I...
2010-05-20
715 reads
PowerShell Week at SQL University – Post 3
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
808 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive....
2010-05-20
17 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
1,274 reads
Blogs
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...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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?
Removing TDE
Comments posted to this topic are about the item Removing TDE
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