|
|
-
|
|
On of the many requirements in SSIS projects, is to append a Date and Time part to the file name which has to be uploaded. I have faced similar requirement many a times, and almost every time I struggle to create an expression to convert the Date and ti...
|
|
-
|
|
When you run the following codeselect name from sys.objects
having 1=1
you get the following error Msg 8120, Level 16, State 1, Line 2
Column 'sys.objects.name' is invalid in the select list because it is not contained in either an aggregate function or...
|
|
-
|
|
Previous posts on this series
Exploring SSIS - Understanding the basicsExploring SSIS - Execute SQL task with simple parameter
I have started a series on Exploring SSIS where I will explain various features available. In this post, we will see the u...
|
|
-
|
|
What kinds of locks are acquired by SQL Server during Index Maintenance? Why is the underlying table not available during a REBUILD, but available during a REORGANIZE? Read this post to know more!...
|
|
-
|
|
I have posted a question for July 2012 at Question of the month July 2012 - How does COALESCE(null,null+1,null) work? Did you know why the second query works without any error?
A NULL value can be of two types. Typed NULL and non-Typed NULL.
SELECT SUM...
|
|
-
|
|
In a rare case when you need to control the execution sequence of database triggers, you can use the sp_settriggerorder statement to do so. However, the recommended best practice always remains that you should have business logic dependent upon execution sequence within stored procedures....
|
|
-
|
|
Often you see people complaining that although the file exists in the directory, the code throws an error Operating system error 2(The system cannot find the file specified.). Ok. The following need the file path to be specified in the code
1 Backup/Res...
|
|
-
|
|
My blog has many practical tips and best pratices for SQL/BI developers,but I haven’t focused on interview questions for SQL/BI developers so far. This might change in the future. It’s been a challenge for many people to break into or stay competitive in the SQL/BI profession.
I am very......
|
|
-
|
|
Microsoft SQL Server is home to many myths and legends, and I have developed an interest in knowing about them. It is really a very interesting exercise to know about these myths, and prove them incorrect if the situation permits. The Myth One such myth is that a table name in a Microsoft SQL Serv......
|
|
-
|
|
Recently, someone in the team faced a fairly common requirement - to generate a comma-separated string from values stored in a table. This being the last post of the year, I thought of sharing the 2 most-commonly used methods I know of implementing this requirement. Do you know any other? If you s......
|
|