Profile cover photo
Profile photo
chetan Deshpande
36 followers
36 followers
About
Posts

Post has attachment
TIP - to fix orphan uers
Orphan Users When a database is moved from one server to another "Orphan users" is one of those little things that tend to create problem in smooth transition.  There could be 2 reasons because of which Orphan users might get created Associated Login for th...
Add a comment...

Post has attachment
Issues while Importing data from Excel to SQL using SSIS - 2 - Alphanumeric data in a column
This is something I had faced long long time ago...  This is what happened,I was given one excel sheet to import into database table. I created one package excel source and OLEDB destination..  Yes, I knowwwwww you geniuses, I could have done that using Imp...
Add a comment...

Post has attachment
Interview Question - To populate a table without specifying values in the INSERT statement
This one should be quick and most of must be aware of it.  Following question was asked to one of my friend in an interview for the post of Sr. Software Engineer How would you populate following table with 5 records without specifying values in INSERT state...
Add a comment...

Post has attachment
Query - to script the steps to move user database files around
Many times we don't pay attention while creating a user database and end up creating database files where they are not supposed to be.. in such scenarios often we find ourselves moving file across drives so as to arrange them to match our settings (or likin...
Add a comment...

Post has attachment
Interview Question - What will be the output of .... ? LEN() function
This blog is about what happens when we do not pay attention to Microsoft documentation ...  Recently, I had a simple question fielded to me which made me look STUPID.. Well being stupid is my right as a human being :) but making me look one is a different ...
Add a comment...

Post has attachment
Query - to script the steps to move user database files around
Many times we don't pay attention while creating a user database and end up creating database files where they are not supposed to be.. in such scenarios often we find ourselves moving file across drives so as to arrange them to match our settings (or likin...
Add a comment...

Post has attachment
Query - Query to find specific column across tables and across database
Here is the situation my friend came up with - list all the databases and tables with containing one specific column he required this info because his project was under migration and they were looking for this kind of information .. The query shared here ca...
Add a comment...

Post has attachment
Query - to find objects containing specific word
Sometime back we did one exercise where our objective was to find out the objects which don't work any more ..  for example suppose we had created a view v_tab with a simple select statement fetching abc column from XYZ table .. later on say after 3-4 month...
Add a comment...

Post has attachment
Query - to peek into Maintenance plan History
Today, it's about maintenance plan and it's history Often we run into situations where jobs executing maintenance plan does not show actual error that caused the failure. And more often than not in such scenarios browsing through maintenance plans history w...
Add a comment...

Post has attachment
Interview Question - Write a script to delete/Truncate data from all the tables of the specific database
Recently, I came across this question where candidate had to write a query to empty all the tables from the specific database. Prima facie it feels like a cakewalk for the candidate but believe me it's not. Why not ? Because one must consider the relationsh...
Add a comment...
Wait while more posts are being loaded