Natively Compiled Procedures and Bad Execution Plans
I’ve been exploring how natively compiled procedures are portrayed within execution plans. There have been two previous posts on the...
2014-06-17
1,352 reads
Blog Posts
Script, store and transfer data using XML, XQuery and clipboard
When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...
2014-06-17 (first published: 2014-06-15)
3,609 reads
SSC Editorial: Kitchen Duty
I try to find good stories for editorials at SQLServerCentral and the one this week about Kitchen Duty seems to...
2014-06-17
586 reads
Baton Rouge SharePoint Saturday
I'm thrilled to be joining many of my colleagues at Baton Rouge SharePoint Saturday this weekend at the Louisiana Technology...
2014-06-16
548 reads
ColumnStore Indexe with SQL Server 2012 & 2014
ColumnStore Indexes (Run By Microsoft’s VertiPaq technology) as described by BOL (http://msdn.microsoft.com/en-IN/library/gg492088(v=sql.110).aspx) :
“An xVelocity memory optimized ColumnStore index, groups and...
2014-06-16
2,380 reads
Come see me in Baton Rouge Aug 2nd!
I've been accepted for SQL Saturday Baton Rouge!
Yes, I am a little excited. I've wanted to become a speaker for...
2014-06-16
513 reads
I don’t want to grant permission to all the tables in the database at once.
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,166 reads
I Gotta See the Code–Question of the Day
I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if...
2014-06-16
564 reads
Last Weeks Top “Reading” Links #88
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-06-16
1,570 reads
Notes From SQLSaturday South Florida
Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...
2014-06-16
447 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers