Viewing 15 posts - 3,751 through 3,765 (of 49,571 total)
ChrisM@Work (1/27/2016)
Two databases on the same "instance" isn't allowed or the two databases can't reference each other using three-part naming?
With Azure SQL DB, there's no such thing as 'instances'....
January 27, 2016 at 2:19 am
BrainDonor (1/26/2016)
You can't use replication to keep the old version up-to-date, because they're more than two versions apart. I don't know if the same restriction would apply to mirroring.
Mirroring requires...
January 26, 2016 at 7:14 am
Summarised consultant comment: "The system is written badly, so you'll have to accept lots of data loss if there's a disaster"
The full vs simple decision is one of data loss....
January 26, 2016 at 5:55 am
Ed Wagner (1/25/2016)
Several countries also have laws restricting where PII on their citizens can be stored.
We do, and that was the reason behind my 'data out of the country'...
January 26, 2016 at 2:03 am
If it's a licensing requirement, disable the extra cores in the BIOS. I know that's what you have to do for Enterprise if you don't want to use all cores,...
January 26, 2016 at 1:59 am
No. One at a time. The LSN is an always-increasing value, so if SQL starts using a VLF, it can't go back and write to an earlier one.
January 26, 2016 at 1:57 am
Bandwidth, latency and data out of the country (for 1 and 3)
January 25, 2016 at 8:59 am
Eirikur Eiriksson (1/25/2016)
January 25, 2016 at 8:57 am
You have a catch-all query there. The WITH RECOMPILE does not give the same effects w.r.t. that query as option recompile does. option recompile relaxes the optimiser's requirements for the...
January 25, 2016 at 8:41 am
Add a filter for OBJECTPROPERTYEX(object_id, 'IsUserObject') = 1, or change the join to sys.tables to an inner join.
As it is, you're getting all the system tables as well as the...
January 25, 2016 at 6:43 am
IT2012 (1/24/2016)
(I know that the statement is testing whether the variable @phrase_type is null
That's not what it's doing. It's part of what it will do, but not all it will...
January 25, 2016 at 4:02 am
Corruption, especially repeated corruption, is very likely an IO subsystem problem. It's not necessarily the disks, it could be anything from SQL all the way down to the disks, switch,...
January 25, 2016 at 3:58 am
hlrx (1/22/2016)
For example, this compiles and runs fine in one batch:[font="Courier New"]CREATE TABLE test1 (col1 INT NOT NULL)
ALTER TABLE test1 ALTER COLUMN col1 INT NULL
INSERT test1 VALUES (NULL)
GO[/font]
Yes it does,...
January 23, 2016 at 6:15 am
January 23, 2016 at 5:30 am
Viewing 15 posts - 3,751 through 3,765 (of 49,571 total)