Contents tagged with sql server
-
SQL Server Migration Assistant and Exceptions in Functions
https://www.dbbest.com/blog/exception-sql-server-udf/
http://migration572.rssing.com/chan-6919524/all_p1.html
-
Debugging SQL Server – Setting Up Windows Debugger by Amit Bansal
https://www.youtube.com/watch?v=h6tCva6oHio&feature=youtu.be&fbclid=IwAR1C08Nj1HTV_1lLKWPtL0xziPzDz0oqRWoybFY4LlgDIGpOtg90cb7Nat8
https://developer.microsoft.com/en-us/windows/downloads/windows-10- … more
-
SQL Server: Datefirst Setting For Determining Day of Week Number
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-datefirst-transact-sql?view=sql-server-2017 more
-
MS SQL Server - How to get Date only from the datetime value
https://tableplus.io/blog/2018/09/ms-sql-server-how-to-get-date-only-from-datetime-value.html
-
SQL Server TSQL Else if Syntax
http://dba.fyicenter.com/faq/sql_server/IF_ELSE_IF_ELSE_Statement_Structures.html more
-
Execute SQL Server Stored Procedure With User Parameter In Power BI
https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/
-
SQL Server Format Function
https://database.guide/3-ways-to-get-the-month-name-from-a-date-in-sql-server-t-sql/ more
-
Running Python Code in SQL Server
https://www.sqlservercentral.com/articles/a-quick-start-to-running-python-code-in-sql-server more
-
SQL Server: How to Move TempDB to Another Drive & Folder
https://www.brentozar.com/archive/2017/11/move-tempdb-another-drive-folder/
https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases?view=sql-server-2017
-
Create Table DDL via TSQL
https://www.sqlservercentral.com/articles/create-table-ddl-via-tsql-1
-
SQL Server Sample Databases
https://docs.microsoft.com/en-gb/sql/samples/sql-samples-where-are?view=sql-server-2017 more
-
SQL Server Database Monitoring
--Find active connections to the instance
USE master;
GO
EXEC sp_who2 'active';
GO
--Find number of active connections to database
USE master;
GO
SELECT DB_NAME(dbid) AS DBName,
spid,
COUNT( … more
-
SQL Server Linked Servers and Excel Performance Compared to SSIS
https://www.mssqltips.com/sqlservertip/4241/data-import-performance-comparison-tsql-vs-ssis-for-large-import/
-
SQL Server Management Studio Tips
http://www.sqlservercentral.com/articles/Management+Studio+(SSMS)/160267/ more
-
Linked Server to SQL Azure
https://www.sqlshack.com/create-linked-server-azure-sql-database/
https://stackoverflow.com/questions/28590832/i-need-to-add-a-linked-server-to-a-ms-azure-sql-server
https://stackoverflow.com/ … more
-
SQL Server Transaction Log Backups
https://www.mssqltips.com/sqlservertutorial/8/sql-server-transaction-log-backups/
-
How to identify the SQL Server Service Account in T-SQL
https://sqlity.net/en/1868/identify-sql-server-service-account-in-t-sql/
-
SQL Server Drop Temporary Table Syntax Enhancement in SQL Server 2016
SQL Server 2016 and onwards:
DROP TABLE IF EXISTS #MyTable
Prior to SQL Server 2016:
IF OBJECT_ID('tempdb.dbo.#MyTable', 'U') IS NOT NULL DROP TABLE #MyTable; more
-
SQL Server Recursive CTE
https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-cte-basics/
https://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/
-
SQL Server: Collate DATABASE_DEFAULT to Resolve "Cannot resolve the collation conflict between ..."
SELECT * FROM MyTable1 t1, MyTable2 t2
inner join t1.field1 on t2.field1 COLLATE DATABASE_DEFAULT