Common SQL Server Mistakes – Indexing Every Column
If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...
2010-09-29
4,788 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Grabbing SWAG
It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...
2010-09-29
1,818 reads
Hot Skills
What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about.
2010-09-28
698 reads
SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
2010-09-28
2,014 reads
Can Wives Shorten Work Hours?
This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.
2010-09-27
258 reads
People are talking about you
I was listening to a friend give a presentation on getting a job recently. In the presentation, Chris Shaw, the...
2010-09-27
967 reads
A day of rest
Not quite a day of rest, likely some chores in advance of another busy weekend at the ranch.
I’m taking today...
2010-09-24
718 reads
Food Drive
Don’t forget the food drive tomorrow for SQL Saturday #52 in Colorado. Please bring food, or even clothing/blankets, that can...
2010-09-24
627 reads
Common SQL Server Mistakes – Multi Row DML Triggers
How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas
declare @id int
select @id = id...
2010-09-23
15,412 reads
Community Direction
Steve Jones wishes that Microsoft had a way for the community to give better feedback about what we see as a priority in the next version of SQL Server.
2010-09-23
66 reads
Blogs
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers