Many a time we need copies of an object but with different names. I also got a requirement to process the files in parallel using SSIS. We had already...
2021-09-17 (first published: 2021-09-09)
505 reads
I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s...
2021-09-13 (first published: 2021-08-28)
453 reads
Here is a simple T-SQL script that may come handy if you need the month end dates of last N years. N is the number of years. The output...
2021-09-03 (first published: 2021-08-13)
320 reads
Here is the simple and practical use case of NTILE function. We’ve used it to divide the rows of sys.columns into N batches. N is the batch size. We’ve...
2021-08-25 (first published: 2021-08-15)
569 reads
Here is a simple T-SQL script that may come handy if you need the month end dates of last N months. N is the number of months. The output...
2021-08-13
13 reads
I was working on an ETL solution, which was expected to run for hours. It has become extremely important to track the errors properly, so as to debug the...
2021-07-05 (first published: 2021-06-21)
390 reads
It’s being quite a long time when I made the last post. Actually, I was lacking a topic that should trigger me to write. Finally, I got one when...
2021-05-12 (first published: 2021-04-28)
896 reads
Transactions are of various kinds in SQL Server such as Autocommit, Implicit, Explicit and Batch-scoped. I personally found this article quite helpful if you wish to understand Implicit Transactions....
2021-03-22 (first published: 2021-03-16)
159 reads
As we all know, there are various numeric data types, such as TINYINT, INT, SMALLINT, BIGINT, NUMERIC, DECIMAL, SMALLMONEY, MONEY and FLOAT. I was working on a SSIS package,...
2021-03-10 (first published: 2021-03-07)
334 reads
T-SQL query to find the list of objects referring Linked Servers
2021-01-19 (first published: 2021-01-13)
998 reads
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Hi friends, Is it possible to configure ALwaysON with two instances on one node...
I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three...
Hello everyone! We have a small group of users (4) using MS Access 2000...
Ask SSC