Today I was reading(I always read Paul Randal).
http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx
I learned that whenever you query select count(*) it will select the the...
2009-10-09
1,949 reads
Microsoft has announced the upcoming end of mainstream support for SQL Server 2005 SP2 on January 12, 2010, and for...
2009-10-09
892 reads
One thing you need to be careful about with SQL Server 2005/2008 Database Mirroring is making sure that you don’t...
2009-10-09
1,318 reads
I took a few days off recently to get a break from work. I've rarely taken time off since last...
2009-10-09
661 reads
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,393 reads
Yesterday was a typical Florida afternoon, sudden down pour of rain, but not a storm. Just slow solid rain for...
2009-10-08
325 reads
I’ve been a regular speaker at the DevTeach/SQLTeach events in Canada for the past several years. Jean-Rene Roy and his...
2009-10-08
446 reads
If you’re attending the PASS Summit this year I hope you’ve decided to attend the two hour Networking to Build...
2009-10-08
571 reads
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-08
1,550 reads
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-08
9,652 reads
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers