Tuning Tip: Identifying Overlapping Statistics
Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When...
2010-09-08
2,087 reads
SQL Saturday Glory
Have you taken the time to plan a fall get-away for some free SQL Server training? You can do this...
2010-09-08
771 reads
Schedule the backup job in Express Edition
Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express...
2010-09-08
463 reads
MDX - Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic...
2010-09-08
1,139 reads
A week far away...24 HOP!
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
649 reads
Common SQL Server Mistakes – GUID as a Clustered PK
I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work...
2010-09-08
1,476 reads
Speaking at SQLSaturday #48 in Columbia, SC
SQLSaturday #48 is October 2nd, 2010, at Midlands Technical College in West Columbia, SC. I’ll be doing two presentations, one...
2010-09-08
284 reads
New Ideas for SQLSaturday
Jack Corbett and I are trying a few new things at SQLSaturday #49 in Orlando this year (Oct 16, 2010)...
2010-09-08
268 reads
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,736 reads
What is Normalization in SQL ?
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,377 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers