Problem Solving

List the MDF file for every database in SQL Instance declare @files table ( db_name sysname, physical_name nvarchar(260) ) inser...

Returns a list of dates from first of year to end of year DECLARE @startofyear DATETIME, @endofyear DATETIME SET @startofyear = DATEADD(...

Script to search inside tables DECLARE @SearchStr nvarchar(100) SET @SearchStr = 'STRING TO SEARCH' CREATE TABLE #Results (C...

The following example partitions the query by columns foo and bar and generates a number for each sequence containing the same 'foo'...

CREATE FUNCTION [dbo].[fn_String_SplitByDelimiter] ( @List VARCHAR(MAX), @Delimiter VARCHAR(255), @ElementNumber int ) RETU...

This query will list all tables of the selected database, sorted by the table which is taking up most data space in MB from the database.  I...

In Windows 8, you have to right-click  devenv.exe  and select "Troubleshoot compatibility". 1.     select "Troubleshoot pr...