RECENT POSTS
Implementing the OUTPUT Clause in SQL Server
SQL ServerinsertedOUTPUTdeleted
January 20, 2017
When you perform a DML operation using an INSERT, UPDATE, DELETE or MERGE statement, an OUTPUT clause can be used to return information regarding the rows affected. You can find this useful when you need to archive, audit or even troubleshoot the…
SSIS – How to deal with commas in data when exporting to a CSV file
January 18, 2017
At work, I often find myself exporting data in .csv format for our clients. I am talking about thousands of data, to the point that I never really noticed this issue. I am talking about data that contain special characters like a comma for example.…
[SOLVED]: The specified ‘@notify_email_operator_name’ is invalid” error
SQLScript@notify_email_operator_nameThe specified '@notify_email_operator_name' is invalid” errorSQL ServerSQL Agent Job
March 22, 2016
Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 245 The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator). Most times, this error is encountered when we script a SQL Server Agent job and…
SOLVED: Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation
SQL_Latin1_General_CP1_CI_AIresolve the collation conflictCOLLATIONSQL_Latin1_General_CP1_CI_AS
March 21, 2016
I got this error at work today while trying to insert records into a table in two different databases. INSERT INTO [Database_1].[dbo].[table_1]SELECT * FROM [Database_2].[dbo].[table_2] WHERE ID_GUID =…
SQL SERVER – Find Currently Running Query – T-SQL
February 2, 2016
Sometimes, your server might be running slow and you are wondering which of the processes is consuming your resources. For me, I would run this query and it helps me to see the culprit. You can also kill the task. SELECT sqltext.TEXT,…
GETDATE() vs { fn NOW() } – SQL Server
January 25, 2016
GETDATE() is a T-SQL function that returns the current system date and time. {fn {NOW()} on the other hand is an ODBC canonical function which is supported by the SQL Server OLEDB provider. This means, it can also be used in T-SQL. SELECT…
Google chrome refuses to uninstall: please close all google chromewindows and try again
June 20, 2014
Have you been faced with the trying to uninstall google chrome and you get the error : please close all google chrome windows and try again eventhough you have closed the google chrome browser? Well, don't worry, just follow the following simple…
Abayomi Obawomiye
I am a SQL Server/Business Intelligence Developer in Chandler Arizona. I share resources on beginner & advanced concepts in SQL Server.