SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-13
3,997 reads
Blog Posts
SQLServerCentral Article on Database Space Capacity Planning
I wrote an article for SQLServerCentral entitled "Database Space Capacity Planning" that demonstrates a database and volume (disk) capacity planning solution...
2009-10-13
999 reads
Table Variables Are Only in Memory: Fact or Myth
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
671 reads
A Not Quite Average Sunday
Ever had a day when a bunch of small things run together to create a day you wish you had...
2009-10-12
325 reads
Afraid of Presenting? Try Toastmasters
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,328 reads
Carolina Code Camp - The Good and the Bad
This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was...
2009-10-12
927 reads
Congratulations to John Magnabosco
Congratulations to John Magnabosco for being awarded as a Microsoft MVP. I met John last year at the Indy Tech...
2009-10-12
616 reads
Congratulations to John Magnabosco on SQL MVP Status
See his quiet post about it here. This comes right after finishing up his first book titled Protecting SQL Server...
2009-10-12
280 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-12
3,346 reads
PASS Update #15
We just had our October board meeting, this one ran the full hour and was a good discussion, catching up...
2009-10-12
229 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers