SQL 101 : Without “ORDER BY”, order is not guaranteed.
It’s as simple as that. If you don’t specify ORDER BY, then the order of your result set is not...
2010-06-26
716 reads
Blog Posts
Don't Do This
In working on applications at client sites you tend to come across code that makes you think "what were they...
2010-06-25
905 reads
Growing the SQL Community – Carefully
If you’re a blogger or a twitterer or a SQL speaker or PASS volunteer, you do it because you have...
2010-06-25
560 reads
How much memory is each SQL Server database using?
Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify...
2010-06-25
565 reads
Lock Pages in Memory
It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging...
2010-06-25
9,649 reads
Powershell Fundamentals
I’ve had the opportunity this week to take class with Don Jones (blog | twitter), PowerShell guru and author of PowerShell...
2010-06-25
2,107 reads
Speaking and Presenting Tips - Bullets
I’ve heard this before, it came up in the Tufte seminar I took, and it also was something that grated...
2010-06-25
1,102 reads
The ‘addicted to data’ decade is still in its infancy
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web or traditional application has no value without data. Few people...
2010-06-25
5 reads
The ‘addicted to data’ decade is still in its infancy
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web...
2010-06-25
12 reads
The Exceptional DBA of 2010
I’ve been a judge in this contest for the last 3 years, and each years we’ve had really good finalists,...
2010-06-25
816 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers