Viewing 10 posts - 1 through 10 (of 10 total)
Hi, as you are covering connecting to azure SQL you might also want to discuss the other authentication methods I.e. those related to azure
July 18, 2019 at 9:09 am
A good script that I have used a few times. Just found out today that because it is based on profiles (inner join ...) it does not script accounts that...
September 2, 2014 at 9:18 pm
Hi Shawn, I am trying to implement the same solution and having the same issue. Can you confirm that this will work if you failover to SQL2 and then take...
August 24, 2014 at 9:15 pm
Regarding your question about reading data from the mirrored database. You can by implementing a DBSnapshot
Please read http://technet.microsoft.com/en-us/library/ms175511.aspx
There are a few gotchas re performance and renewing the...
January 31, 2014 at 8:43 pm
No you do not need to block transactions. However, do not waste too much time between the backup and restore of the transaction log. When you set up the mirror...
January 31, 2014 at 8:38 pm
I presume you use a where clause somewhere along the way. I tend to see this type of issue when the statistics get out of date and I would assume...
May 15, 2009 at 9:25 pm
The issue is that you have a GO statement partway down your code. This effectively ends the batch and all variables are then forgotton. I would have to ask why...
August 2, 2006 at 3:21 pm
I agree with Vasc that both types (int and smalldatetime) use 4 bytes.
Unfortunately, the code from Remi Gregoire is all done on the...
June 8, 2005 at 7:17 pm
A previous post says that dates make good indexes. I tend to disagree. At the end of the day a date is stored as a number. Because types of smalldatetime and datetime allow...
May 31, 2005 at 2:10 am
If you have an identity column in teh table do the insert and then use
SET guid = @@IDENTITY
Once again this only work when inserting oe record at a time.
May 18, 2005 at 11:03 pm