I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

It's quite old, but new for me. Great method to parse string is using of recursive CTE, as showed in Table Function:

    CREATE FUNCTION fn_SplitString(@str NVARCHAR(MAX), @sep NVARCHAR(MAX))
    RETURNS TABLE
    AS
    RETURN
    (
    	WITH...
                        

It's quite old, but new for me. Great method to parse string is using of recursive CTE, as showed in Table Function:

    CREATE FUNCTION fn_SplitString(@str NVARCHAR(MAX), @sep NVARCHAR(MAX))
    RETURNS TABLE
    AS
    RETURN
    (
    	WITH...
                        

I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this ...

I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this ...

I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this ...

I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this ...

Set `ARITHABOBRT` and `ANSI_WARNINGS` as OFF to handle division by Zero error SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 1/0 This will not throw an error. Result will be NULL ...

Set `ARITHABOBRT` and `ANSI_WARNINGS` as OFF to handle division by Zero error SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 1/0 This will not throw an error. Result will be NULL ...