GO statement breaks SSIS Execute SQL Task
I have lost an hour today trying to find a bug in my SSIS package, and it was so small...
2011-11-30
6,711 reads
I have lost an hour today trying to find a bug in my SSIS package, and it was so small...
2011-11-30
6,711 reads
I have been having a hard time believing my eyes when I noticed that these queries give different results:
1. select...
2011-09-27
739 reads
I used to think naively that IIF is an innocent little function that can only do good and help me...
2011-02-16
3,109 reads
I used to think naively that IIF is an innocent little function that can only do good and help me...
2011-02-11
3,052 reads
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,699 reads
Last week I was puzzled by one of my colleagues - he needed help in creating a Report Builder 2.0 SSRS...
2010-10-07
6,365 reads
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
2010-09-03
2,456 reads
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
2010-08-30
3,267 reads
During the configuration of one of the SSRS instances I have stumbled upon a problem with SSRS Subscription. Subscriptions were...
2010-08-04
1,002 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers