Sql Saturday #83
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
798 reads
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
798 reads
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s...
2011-05-03
997 reads
From Tom LaRock’s latest idea…
For a change I’m not going to mention performance (well, not more than once anyway)...
2011-05-02
1,307 reads
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,570 reads
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-28
1,643 reads
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-22
2,057 reads
Earlier this week I took part in the 24 Hours of PASS live webcast event. There were far more questions...
2011-03-18
696 reads
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,324 reads
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-28
2,838 reads
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-22
1,555 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers