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)
512 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)
460 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)
571 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)
322 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)
335 reads
It is a tiny query in size but can play a crucial role to avoid overhead, caused due to missing SET NOCOUNT ON definition in the stored procedures and...
2021-01-14
330 reads
By Steve Jones
Last week I was privileged to attend a live conference in Belgium. dataMinds Connect...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
I am missing something I guess. Here's our backup Plan Full backup weekly Differential...
We have one user who face this issue while connecting to SQL server ''Cannot...
Hello, I have recently inherited a SQL 2012 database (no backups available), running in...
Ask SSC