What problems occur because of the algorithm chosen to generate data? A new report says that social security numbers in the US can be predicted. Steve Jones has a few warnings about what algoriothms you choose.
2009-07-27
486 reads
Need a new laptop bag? MVP Grant Fritchey brings us a review of a large and versatile brief case that's a little different than the rest.
2009-07-24
1,429 reads
When you start applying for jobs, and face competition from other candidates, who do you think gets the interview? Is it the middle 50%? The bottom 20%? I bet you're thinking the top 5-10 candidates are granted interviews, which in today's world...
2009-07-24
2,332 reads
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others in the SQL community. Some of those who don’t use Facebook and Twitter (among others) have expressed skepticism of the real value of social networking. Does it work? Does it provide any value beyond entertainment? Can it actually help your career? I believe the answer to all of these queries is Yes.
2009-07-24
1,698 reads
Microsoft SQL Server 2008 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. This paper describes what data is collected, where it is stored, and which commands create, update, and delete statistics. By default, SQL Server 2008 also creates and updates statistics automatically, when such an operation is considered to be useful. This paper also outlines how these defaults can be changed on different levels (column, table, and database).
2009-07-24
2,506 reads
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
2009-07-24
570 reads
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
2009-07-24
556 reads
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
2009-07-24
811 reads
This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.
2009-07-24
8,966 reads
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
2009-07-23
5,037 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers