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
114 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
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
11 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
94 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
140 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
2 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
2 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
66 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
224 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
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers