Viewing 15 posts - 4,441 through 4,455 (of 49,571 total)
Post them again please, just to be sure.
October 21, 2015 at 5:52 am
Nested views kill performance.
That view is querying other views, can you post their definitions please?
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...
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...
October 21, 2015 at 5:33 am
Nope, as long as there are no services running as local admin, you should be fine.
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
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....
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?
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,...
October 21, 2015 at 2:52 am
Please post new questions in a new thread.
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...
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.
October 20, 2015 at 2:01 pm
Would you mind deleting those hundreds of lines and rather just attaching the .sqlplan file please?
October 20, 2015 at 1:59 pm
j.sjoelund (10/20/2015)
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...
October 20, 2015 at 8:12 am
Viewing 15 posts - 4,441 through 4,455 (of 49,571 total)