Return date as ddmmyyyy or any other format in SQL Server

Notice that use upper case MM to get month lower case mm will return minutes instead

SELECT FORMAT(GETDATE(), 'ddMMyyyy')

https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

What is the string length of a GUID? or uniqueidentifier data type - char(36)

It depends on how you format the Guid:

• Guid.NewGuid().ToString() => 36 characters (Hyphenated)
  outputs: 12345678-1234-1234-1234-123456789abc
• Guid.NewGuid().ToString("D") => 36 characters (Hyphenated, same as ToString())
  outputs: 12345678-1234-1234-1234-123456789abc

and

• Guid.NewGuid().ToString("N") => 32 characters (Digits only)
  outputs: 12345678123412341234123456789abc
• Guid.NewGuid().ToString("B") => 38 characters (Braces)
  outputs: {12345678-1234-1234-1234-123456789abc}
• Guid.NewGuid().ToString("P") => 38 characters (Parentheses)
  outputs: (12345678-1234-1234-1234-123456789abc)
• Guid.NewGuid().ToString("X") => 68 characters (Hexadecimal)
  outputs: {0x12345678,0x1234,0x1234,{0x12,0x34,0x12,0x34,0x56,0x78,0x9a,0xbc}}

Store is as Char(36) for best performance

System Schema - List of all Tables/Columns/Data Types/Primary Key

SELECT *
FROM sys.tables t,
     sys.all_columns c,
     sys.types ty
WHERE t.object_id=c.object_id
  AND c.system_type_id=ty.system_type_id 
AND ty.name='uniqueidentifier'

----Below SQL will pull Primary Keys as well

SELECT c.name,
       ty.name,
       c.max_length,
       i.is_primary_key,
       *
FROM sys.all_objects ta
INNER JOIN sys.all_columns c ON c.object_id=ta.object_id
INNER JOIN sys.schemas s ON s.schema_id=ta.schema_id
INNER JOIN sys.types ty ON c.user_type_id=ty.user_type_id
LEFT OUTER JOIN sys.index_columns ic ON ic.object_id=c.object_id
AND ic.column_id=c.column_id
LEFT OUTER JOIN sys.indexes i ON i.object_id=c.object_id
AND ic.index_id=i.index_id

Performance Tips

Char vs Varchar
Because of the fixed field lengths, data is pulled straight from the column without doing any data manipulation and index lookups against varchar are slower than that of char fields. CHAR is better than VARCHAR performance wise, however, it takes unnecessary memory space when the data does not have a fixed-length. So in cases where disk size is not an issue, it is recommended to use CHAR.

Bottom line is to use the data type that fits our need. You can use SQL varchar when the sizes of the column vary considerably, use varchar(max) when there are chances that string length might exceed 8000 bytes, use char when the sizes of the column are fixed and use nvarchar if there is a requirement to store Unicode or multilingual data.



-------------------------------------------------------------------
Adding Extra Join conditions some time helps as it gives maximum chances for Optimizer to Build better Query Plan 

select * from
table fth
join  table2 dp

on dp.[col1] =fth.[col1]
and dp.indicator=1
and dp.source_system=fth.source_system

Instead do if possible

select * from
table fth
join  table2 dp

on dp.[col1] =fth.[col1]
and dp.col2 =fth.col2
and dp.col3=fth.col3
and dp.indicator=1
and dp.source_system=fth.source_system

---------------------------------------------------
To get rid of Sort in query Plan try using left outer join Instead of Inner Join
------------------------------------------------

SQL server uses Nested loop instead of Hash Match when it believes that Inner Table has very few records that you can see from estimated no of rows on inner table try updating the DB Stats if it doesn't work then force Left Hash Join instead of Left Join

--------------------------------------------------

To get rid of Nested Loop in query Plan

If Query plan is using Nested Loop for some joins - Look if you have used IN clause on an attribute with is NULLABLE i.e.  where Customer_ID in (select Cust_ID from customerProdcutTable).

Now if CustomerID is nullable in customerProdcutTable then SQL will use Nested Loop instead of hash Join 

If the attribute is nullable the SQL server will chose to use Nested loop as It needs to cater for NULL values. 

You could also try to use another clause in Join condition with IN clause i.e. where Cust_ID is NOT NULL this may help SQL Server to use Merge join.

Or 

you could instead use

where exists (select 1 from customerProdcutTable )

this will enable SQL server to use Merge Join instead of Nested Loop.

Concatenate Message In RAISERROR

DECLARE @temp varchar(50)
DECLARE @ID int=1234

SELECT @temp= CAST(@ID AS VARCHAR(50))

RAISERROR(N'This is how you concat with Raise Error %s',1,1 ,@temp);


output is


/*------------------------
DECLARE @temp varchar(50)
DECLARE @ID int=1234

SELECT @temp= CAST(@ID AS VARCHAR(50))

RAISERROR(N'This is how you concat with Raise Error %s',1,1 ,@temp);
------------------------*/
This is how you concat with Raise Error 1234
Msg 50000, Level 1, State 1