Partition Switching #TSQL2SDAY #77
The ALTER TABLE..SWITCH command allows you to almost instantly move large amounts of data from one table to another. It does...
2016-04-20 (first published: 2016-04-12)
4,174 reads
SSRS Report Won’t Render in VS Preview
I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying....
2016-04-12
344 reads
T-SQL Tuesday #77–My Favorite Feature
This month is an interesting, but tough topic. The blog party is hosted by Jens Vestergaard, and his invitation is...
2016-04-12
743 reads
Speaking at SQL Saturday #526 in Rochester on May 14, 2016
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-12
392 reads
SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
219 reads
SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
550 reads
A View Is Not A Table
Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
In SQL Server, in the T-SQL you use to query...
2016-04-19 (first published: 2016-04-12)
3,138 reads
Insurance For Events
Posting here mostly because I’ll need this link again sooner or later! We’re hosting our more or less annual joint...
2016-04-12
539 reads
SQL Server Service Broker – Sending and Receiving
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database...
2016-04-12
122 reads
SQL Server Service Broker – Sending and Receiving
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-04-19 (first published: 2016-04-12)
1,907 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers