Inside the Optimizer: Constructing a Plan - Part 2
How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.
Webinar: Turn your backups into live databases with SQL Virtual Restore
Find out in this webinar how easy it is with Red Gate's SQL Virtual Restore to mount live, fully functional databases direct from backups – without performing a physical restore. Learn how you can use SQL Virtual Restore to save storage space and time across a wide range of database administration activities.
AdvanceTimePolicy and Point Event Streams In StreamInsight.
There are a number of ways to issues CTIs (Current Time Increments) into your StreamInsight streams but a quite useful way is to do it declaratively on your source factory like this
An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
The DIS-Information Principle: A Splitting Headache
You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue the problem, even with expert queries. So what constitutes 'wrong RDBMS design? What are these errors that continually crop up? How can you recognise them and fix them? Joe embarks on a new series of articles by identifying a series of bad practices based on the habit of 'splitting' that which shouldn't be split.
Early September Free Training from PASS VCs
Hope you got plenty of rest over your Labor Day holiday because the PASS Virtual Chapters have some great free training lined up for you.
Inside the Optimizer: Constructing a Plan - Part 1
Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.
Talking To You Makes Me Smarter
There's a lot of value in the interactions that professionals have with each other. A guest editorial from Andy Warren talks about the benefits of meeting new people.
Extended Protection available in SQL Server 2008 R2
We use Internet Protocol Security (IPSec) within the trusted domains, but use the Negotiate Security Support Provider for our web applications. What other security methods can we employ with SQL Server?
4-4-5 Calendar Functions, Part 1
New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCP Galuh Mas Telp:08218154398
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Alamat Kantor BCA KCU PONDOK INDAH Telp:08218154398
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers