SQL Server 2012 FileTable – Part 2
In this weeks blog post we will have a look at how easy it is to combine FileTables and FullText...
2012-01-18 (first published: 2012-01-12)
2,940 reads
Blog Posts
SQLInspire NYC 2011 Videos available
There are some FANTASTIC videos of the sessions from SQLInspire New York 2011. I highly recommend that you check out...
2012-01-18
536 reads
Stop PIPA & SOPA
I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six...
2012-01-18
1,928 reads
Update Statistics and the new TraceFlag 2371
What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?
The Statistics life cycle
As a regular...
2012-01-18
379 reads
When Date Modified changes for Sql mdf/ldf files
*This is related to physical file size of a MDF or LDF file not internal allocation.
One of our user asked...
2012-01-18
5,258 reads
Why It’s Called a User Group…
On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year. As...
2012-01-18
581 reads
#SQLThursday is here
Struggling to source quality free content on SQL Server? Finding it difficult to fill the void between #TSQL2sDay and Un-SQL...
2012-01-17
414 reads
A Trio of Functions
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me some interesting things I had never really paid much...
2012-01-17
16 reads
A Trio of Functions
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me...
2012-01-17
1,249 reads
ColoradoSQL for January 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-01-17
567 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers