Extraordinary #1
I’ve seen tables that are referenced by many other tables in MSSQL databases and that number was usually being around...
2016-03-10
122 reads
Si vis pacem, para sql
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
6 reads
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
17 reads
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...
2016-03-10
103 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports:SQLServer default instance port...
2016-03-05
150 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
15 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
9 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports:
SQL Server default instance...
2016-03-05
84 reads
Rebuild of the System databases on Stand-alone and Failover Clustered SQL Server
The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is...
2016-03-02
239 reads
Rebuilding the system databases
The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is the same – https://msdn.microsoft.com/en-us/library/dd207003.aspx. When you install a SQL...
2016-03-02
14 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers