Viewing 15 posts - 4,441 through 4,455 (of 49,552 total)
Post them again please, just to be sure.
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
October 21, 2015 at 5:52 am
Nested views kill performance.
That view is querying other views, can you post their definitions please?
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
October 21, 2015 at 5:51 am
CREATE TABLE enrollment_in (
BEN_DENT CHAR(1) NOT NULL CHECK (BEN_DENT IN ('Y', 'N'))
);
And change the data type to CHAR. There's no point...
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
October 21, 2015 at 5:36 am
You need to send down the backup that you restored the primary from (or any other backup taken after that time) and all log backups. You can't 'undo' an applied...
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
October 21, 2015 at 5:33 am
Nope, as long as there are no services running as local admin, you should be fine.
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
October 21, 2015 at 5:31 am
CheckDB again please, and don't edit the output at all.
GilaMonster (10/16/2015)
DBCC CheckDB ('<Database name>') WITH NO_INFOMSGS
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
October 21, 2015 at 5:30 am
It's not.
Instance1 is listening on port 21433
Instance2 is listening on port 21434
Hence when you connect and specify port 21433, you get Instance1, it's the instance listening on that port....
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
October 21, 2015 at 5:28 am
Is it an index or a heap?
Do you have a shrink operation which ran after the rebuild?
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
October 21, 2015 at 2:53 am
SQL Server doesn't have sharding.
It doesn't scale out easily, it's very, very, very hard to scale out a SQL Server. Any moving of historical data has to be done manually.
What,...
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
October 21, 2015 at 2:52 am
Please post new questions in a new thread.
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
October 21, 2015 at 2:49 am
According to someone on twitter, it can't be done (at least in SQL 2008 R2)
Why is it important that the filegroup be dropped? Is it causing errors?
Are you sure that...
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
October 21, 2015 at 2:48 am
Err...
INSERT INTO <table name> (<column list>)
VALUES (<list of values here>);
The version and edition you can get from SERVERPROPERTY. @@Version is a long string, not just the version itself.
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
October 20, 2015 at 2:01 pm
Would you mind deleting those hundreds of lines and rather just attaching the .sqlplan file please?
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
October 20, 2015 at 1:59 pm
j.sjoelund (10/20/2015)
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
October 20, 2015 at 9:55 am
The following indexes are redundant (left-based subsets of other indexes), and hence can be dropped
index_ServiceRequest_BusinessProcessStatus
index_ServiceRequest_LienholderPerformingLienFilingId
index_ServiceRequest_ServiceRequestStatus
Since most are single-column indexes, I doubt most are useful. That doesn't mean they won't be...
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
October 20, 2015 at 8:12 am
Viewing 15 posts - 4,441 through 4,455 (of 49,552 total)