List Foreign Keys referencing tables in SQL Server

How do I list foreign keys in a table in SQL? Read more →

How to fix Column in table is invalid for creating a default constraint

Fix the CONSTRAINT create failed Msg 1752, Level 16, State 0, Line 5 Read more →

How to check SQL Server Filegroup file sizes

I had a question from a fellow DBA about how to list every file per SQL Server filegroup , and report on the size in MB. This will give them a quick way of checking which file could be creating a capacity issue. Quite often , alerting is set up to check the whole drive , but won't check every file. So some granular report can identify the file causing a capacity issue --Return file , size in MB , filegroup SELECT sdf.name AS [File_Name], sdf.size/128 AS [Size_MB], fg.name AS [FileGroup_Name], sdf.physical_name as [File_physical_name] FROM sys.database_files sdf INNER JOIN sys.filegroups... Read more →

Quick Fix: DELETE statement conflicted with the REFERENCE constraint

Question: In the application error logs there is a message - The DELETE statement conflicted with the REFERENCE constraint FK_xxxxxxxxx What is causing this error ? How can I troubleshoot? Answer: The error is occuring because there is an attempt to delete a parent table data before the referenced child table data is deleted When a database uses a FOREIGN KEY , its purpose is to create a link between two tables. The foreign key is one or more columns in the a table referencing another table's PRIMARY KEY. A child table is the table hosting the FOREIGN KEYS.A parent... Read more →

How to migrate wide Excel worksheet into SQL Server table

Question: What is the limit on SQL Server Maximum Columns per table? I have a very wide Excel worksheet and want to migrate the data to a SQL Server table - where we can then manage the data? Answer: The standard SQL Server table maximum columns limit is 1024. Tables that include sparse column sets include up to 30,000 column A Sparse column set combines the table's sparse columns and translates into a structured representation. The column set is not stored physically in a table. Read more on SQL Server tables Table sizes and percentages (SQL Server DBA) SQL Server... Read more →