SQL University–Recommendations for a Clustered Index
Welcome, SQL University Students to another extension class here at Miskatonic University, home to the Fighting Cephalopods (GO PODS!). Never...
2011-04-04
1,234 reads
Welcome, SQL University Students to another extension class here at Miskatonic University, home to the Fighting Cephalopods (GO PODS!). Never...
2011-04-04
1,234 reads
With a large-scale development of a database application, the task of supporting a large number of development and test databases, keeping them up to date with different builds can soon become ridiculously complex and costly. Grant Fritchey demonstrates a novel solution that can reduce the storage requirements enormously, and allow individual developers to work on thir own version, using a full set of data.
2011-03-29
3,364 reads
Just… Wow. What an event. What a great group of people. I’m just so lucky to be involved with fantastic...
2011-03-28
923 reads
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become...
2011-03-21
2,614 reads
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-21
1,115 reads
I have my opinions and experience, and I’ve no doubt you have yours. Paul Randal (blog|twitter) has put up another...
2011-03-17
745 reads
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-14
1,717 reads
I’ve talked before about one of the primary things that the Query Optimizer team at Microsoft tries to avoid, regressions....
2011-03-07
787 reads
Andy Warren posted a question the other day (well, issued a challenge actually), “What Should PASS Be?” I’ll let you...
2011-02-22
713 reads
I believe I’ve been far too quiet about this event.
In May, in Orlando Florida, there will be a two...
2011-02-17
651 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Comments posted to this topic are about the item The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Comments posted to this topic are about the item A Worse Computer; A Better...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers