SSIS Package documentor
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
2016-11-04 (first published: 2015-09-01)
13,346 reads
Divya Agrawal
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
8,009 reads
Problem with scripting objects through query
This article from Divya Agrawal might help you to overcome the problem when multiple objects or statements are scripted together. This is technique that can eliminate errors from scripts built dynamically.
2009-10-30
1,950 reads
Compatibility issue and CROSS APPLY
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,350 reads
Split string using XML
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
12,610 reads
Execute SQL job through batch file
This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
2009-06-05
17,629 reads
2009-05-25
1,047 reads
Calculate the Running Total for the last five Transactions
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
4,549 reads
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
3,745 reads
Blogs
Understanding Disk Performance and IOPS in cloud platform
By nelsonaloor
In the past many years, apart from working as DBA, I was working with...
COVID-19, a wake-up call
COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...
ASF 030: Benni De Jagere interview
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
Forums
How to make join to teams display without join all teams ?
problem How to make left join to only teams displayed dynamically depend on fields...
sql server memory buffer cache building up question
question for DB Gurus when sql server is restarted, it will be slow at...
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Ask SSC