Viewing 15 posts - 3,751 through 3,765 (of 49,552 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'....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2016 at 7:14 am
Probably, yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2016 at 5:55 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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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'...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2016 at 1:57 am
Bandwidth, latency and data out of the country (for 1 and 3)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2016 at 8:59 am
Eirikur Eiriksson (1/25/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2016 at 6:15 am
https://www.google.com/?q=sql+2012+evaluation
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2016 at 5:30 am
Viewing 15 posts - 3,751 through 3,765 (of 49,552 total)