New MSSQLTips Article: Nesting Database Roles in SQL Server
I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...
2010-04-07
1,671 reads
Blog Posts
SQLSaturday Orlando 2010 - The Planning Begins
Believe it or not, it's already time to start planning for Orlando's next SQLSaturday. Andy Warren and I had our...
2010-04-07
428 reads
Test Driving a LinkedIn Poll
Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...
2010-04-07
257 reads
Use a Clustered Index
I stumbled across this clustered index test from Hugo Kornelis recently from a post in the forums. I think I’d...
2010-04-07
537 reads
24 Hours of PASS Registration Now Open
Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...
2010-04-06
649 reads
24 Hours of PASS v2.0
The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...
2010-04-06
712 reads
24 Hours of PASS: Celebrating SQL Server 2008 R2
Well, we finally got the ok to start talking about the second 24 Hours of PASS event, called 24 Hours...
2010-04-06
573 reads
A DMV a Day – Day 6
The DMV for Day 6 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-06
855 reads
Big Iron on Windows 2008 R2, Earning its Keep!
This screenshot goes in the category of “geek porn”… It shows an IA64 system with 256 logical processors and 512GB...
2010-04-06
277 reads
Catching Transient CPU Spikes Using SQL Trace
Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...
2010-04-06
4,529 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
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