SSIS Issues : A Day of Learning
Seldom are the days when you run into complex issues but resolve them in the shortest interval of time.
Thanks to...
2017-11-24
477 reads
lokesh sharma
- Interests: Writing and troubleshooting SQL Queries obviously :-). Other than that a fitness freak
SQL Query Experiment - "WHERE" & "ON"
Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept.
This happened recently...
2017-11-14 (first published: 2017-11-02)
4,801 reads
Be Aware of CARTESIAN PRODUCT When Using Join Keys in SQL
I got a massive satisfaction last week when I was able to bring down the execution time of a sql...
2017-06-06
4,211 reads
Dump Data From SQL 2005 table to Excel 2016
By First looking at the topic name, does the task sound simple to you? Well, I thought so but it...
2017-06-01 (first published: 2017-05-22)
1,431 reads
Decrease Stored Proc Execution Time By Limiting the Table Size
Hi Guys,
Hope everyone is doing well. Last week, I was working on the most exciting task on which any database...
2017-05-30
835 reads
Run a Job on SQL Azure (Using SSIS Package)
Requirements: A valid azure account, Local Instance of SQL Server (>= 2012), SQL Server Data Tools, Excel 2007 or above
Scenario: Dump...
2017-03-23 (first published: 2017-03-11)
2,032 reads
SQL QUERY NIGHTMARE
Last week, we faced a basic and yet the only major problem that sql developers/admin had to deal with and...
2016-10-07 (first published: 2016-09-23)
4,319 reads
SSRS 2005 Bug - Percentage calculated column when Exporting to Excel
Nature of the Issue Faced :- Say you have 3 columns in a tablix/table on the report. There are 3 textboxes...
2016-05-30 (first published: 2016-05-20)
1,118 reads
Possible PARAMETER SNIFFING Scenario in SQL
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to...
2016-05-11 (first published: 2016-04-29)
3,679 reads
ALTERNATIVE TO DISABLING A SQL JOB STEP (FOR SSIS PACKAGES)
For relational data-warehouses where you have the data load scheduled during off hours, timing of different steps in a sql...
2016-05-06
1,285 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers