Full backups, the log chain and the COPY_ONLY option.
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,332 reads
SQL In The Wild
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-22
1,576 reads
Are int joins faster than string joins?
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
5,312 reads
Quest Webcast: Dos and Don’ts of Database corruption
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
640 reads
Is a clustered index best for range queries?
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,697 reads
Upcoming presentations
It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up...
2011-01-28
538 reads
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-18
6,080 reads
Capturing the Execution Plan
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the...
2011-01-04
1,390 reads
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-14
1,486 reads
Recompiles
I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event...
2010-11-18
2,142 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
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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...
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