RAID server configuration and disk amounts
Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge.
Typical questions from...
2011-08-17
1,106 reads
SQL MCM Training – Day 9
Today Jonathan was talking the whole day about Consolidation and Virtualization. There
were again a lot of new concepts, and new...
2011-08-17
958 reads
Splitting ID’s with commas, updating them, and then Slamming them back together
Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...
2011-08-16
1,259 reads
SQL Server 2008 R2 SP1 Cumulative Update 2
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in...
2011-08-16
1,517 reads
Basic Computed Columns
I ran into an issue recently with a computed column, which I’ve rarely used, so I investigated them and wrote...
2011-08-16
1,984 reads
You Are Allowed to Care About Whatever You Want
I wanted to write this because its often overlooked. I care about things that may not interest you, things that...
2011-08-16
575 reads
Going Big with SSDs
Nimbus Data just sold 100TB of SSDs to eBay
I found a report recently that eBay had implemented 100TB of SSD storage from Nimbus...
2011-08-16
935 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do that might involve Oracle. I have never put...
2011-08-16
15 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do...
2011-08-16
2,123 reads
Compiles and recompiles
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,826 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers