A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2021-03-11 (first published: 2021-03-05)
2,114 reads
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2021-03-11 (first published: 2021-03-05)
2,114 reads
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
1,892 reads
See how to find those files that are not in use, but are taking up space on your instance.
2020-09-22 (first published: 2020-09-21)
1,965 reads
This function returns a 3 year calendar based on a 4-5-4/5-4-4/4-4-5 calendar, also known as a 52/53 week calendar. The basis of this calendar function was derived from the NRF retail calendar published at https://nrf.com/resources/4-5-4-calendar and the Wikipedia article published at https://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar. The calendar function requires 2 helper functions. The helper functions were derived from […]
2020-09-21 (first published: 2020-09-15)
2,606 reads
I have explored the SQL Server 2019, Intelligent Query Processing Feature – “Table Variable Deferred Compilation”.
The script contains some theory at the top and links to read.
After that, there are required queries to run on SQL Server 2019.
This way we can see the feature in action and look at it's strengths and caveats.
2020-08-03
1,421 reads
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2020-07-02 (first published: 2016-03-23)
1,303 reads
I bet, each DBA would change some settings after the SQL Server installation as per their company standard . I wrote this PowerShell script for one of my client who has below standards: Port should be 1433, static Disable SQL telemetry* & SQLWriter services Change recovery model to FUll for all databases except tempdb and […]
2020-07-02 (first published: 2020-06-21)
2,531 reads
Lately, I'm dealing with lots of DB migrations and came across situation that I have no proper dynamic script to move DB files to different location. There are an option to proceed manually scripting one by one DB and execute it. Another option is detach attach DB - I'm not a big fan of this […]
2020-07-01 (first published: 2020-06-24)
1,723 reads
Insert multiple rows in the table using insert syntax which is the same as single insert rows. So, we have to use value likewise, single rows than there is the same process but include coma and insert the value of another row in your query. In this paragraph, we were given a syntax with insert […]
2020-06-29
1,237 reads
Avoid conversion errors when using UNION to stack rows from multiple tables.
2020-06-19 (first published: 2020-06-16)
3,753 reads
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with...
Let’s have devs look at their own query performance. Yes, please, sign me up...
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
Hi All, Wonder if someone can clear something up for me and let me...
Hi I am brand new to Data Factory I am getting the following error...
I want to set the execution timeout in SSMS Connection properties on the 'Connect...