Viewing 15 posts - 1,681 through 1,695 (of 49,571 total)
Eliyahu - Wednesday, March 8, 2017 6:18 AMIs SSMS that smart to add an INSERT to the CREATE INDEX?
No. SSMS is...
March 8, 2017 at 7:00 am
March 8, 2017 at 5:45 am
Looks like the command behind an index rebuild (but that wouldn't fail due to a key violation)
March 8, 2017 at 5:18 am
SQL's whitespace behaviour is weird in general.
This is valid and works:
SELECT*FROM master
. sys .
objects ;
March 8, 2017 at 2:51 am
March 8, 2017 at 12:19 am
Yep. I get that. Tell me what that constraint should be for a...
March 8, 2017 at 12:16 am
It's in the database header pages, and it's not accessible.
Deleting info from MSDB and still being able to take a differential backup should not be a surprise. If...
March 7, 2017 at 4:42 am
MSDB just contains the history about what backups were taken of what databases when. All databases know whether they've had a full backup, what full backup the diffs belong to...
March 7, 2017 at 3:32 am
March 7, 2017 at 2:34 am
SQL Server...
March 7, 2017 at 12:31 am
March 7, 2017 at 12:31 am
March 6, 2017 at 1:09 pm
March 6, 2017 at 1:07 pm
TheSQLGuru - Monday, March 6, 2017 7:35 AMDidn't Gail tell you to drop and recreate the empty tables?
Yup, because rebuild can...
March 6, 2017 at 7:40 am
DBCC CheckAlloc is probably what you need to pick those up without a full checkDB.
Do you really have over 9000 files in that database?
Index rebuild won't...
March 6, 2017 at 6:35 am
Viewing 15 posts - 1,681 through 1,695 (of 49,571 total)