The Navier-Stokes problem starts with a cup of tea. Stir it, pull out the spoon, and watch the swirl slowly…
Browsing: SQL
Your index rebuild maintenance plan runs every Sunday night, takes four hours, fills your transaction log, delays your backup, and…
I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog.…
This article is about why things are the way they are, not how to do it. There are no step-by-step…
I did not hand it a plan with a spill in it. Everybody can find a spill. I handed it…
When I put together the invitation for T-SQL Tuesday #202, I wasn’t sure what kind of stories would come out…
On January 1, 2000, the expected worldwide computer breakdown did not arrive. That was a relief. It also made the…
An UPDATE without WHERE clause can fit on two lines and change an entire table. In Dex’s case, it also…
Everyone expected AI to come from the big companies. They had the money, the data, the researchers and a twenty…
A row can vanish from your report while it is sitting safely in the table the entire time. Nobody deleted…