Reload a table quickly.
Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload....
2016-11-28 (first published: 2016-11-21)
2,898 reads
Kenneth Fisher
It greatly pleases me to announce, HAL0003!
I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal...
2016-11-23
464 reads
When was my index created or at least last updated?
SQL Server stores a create date and a change date for each object in the sys.objects system view.
Unfortunately while...
2016-11-21 (first published: 2016-11-14)
2,098 reads
2016-11-17
3,090 reads
SQLSkills waits and latches library
SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails...
2016-11-16
667 reads
Is it safe to grant Administer Bulk Operations?
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...
2016-11-14 (first published: 2016-11-10)
2,184 reads
TSQL Tuesday #84: Zip to Speaker
Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t)...
2016-11-08
466 reads
The Halloween Problem
DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!
Ok, so that’s really...
2016-11-07 (first published: 2016-10-31)
2,716 reads
New indexes, hypothetically
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...
2016-11-02
853 reads
It’s a small world
As I write this we are packing to leave for Disney World, where my family and I will spend close...
2016-10-26
373 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers