Come Find Me at the Summit
Steve Jones reminds you to network anytime you're at and event, and especially a large conference like the PASS Summit.
SQL Server Tables without a Clustered Index
It is a general best practice to have a clustered index on all of your SQL Server tables. Unfortunately, not everybody knows that. This tip helps you find tables that do not have a clustered index.
An Awesome Job
Life is awesome, and Steve Jones things everyone can find something awesome in their jobs.
Reading Query Plans: Stairway to SQL Server Indexes Level 9
Determining how, and if, SQL Server is using your indexes.
Meet the Red Gate Team this month
Find out where you can meet the Red Gate team in the US, ask a question, get a custom demo, and maybe a prize as well.
How do you learn the advanced stuff?
Today Steve Jones talks about learning those advanced features that you don't get the chance to use in your daily work.
INFORMATION_SCHEMA.101
Get information about the objects in your database using these ANSI standard, multi-platform views.
Database Properties Health Check
Within an instance of SQL Server, the database settings can have a direct effect on the database’s behavior, performance and availability. Sometimes, it is difficult to tie a symptom to a cause, so it is wise to routinely check and record these settings. Before you change the current setting, it pays to understand exactly what it means and the implications of any change.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
Alamat Kantor BCA KCU SIDOARJO Wa(082144477715)
Wa:0821-4447-7715 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Alamat Kantor BCA KCU PASURUAN Telp (0817866887)
Wa:0817-866-887 Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111
ALAMAT BCA KCU BUKIT BARISAN TLP/WA 08218200174
Telp Cs: 08218200174 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers