Viewing 15 posts - 1,231 through 1,245 (of 49,552 total)
Beatrix Kiddo - Wednesday, June 28, 2017 1:49 AMI'm planning to go to Cape Town in December.
Yay. Cape Town's nice in...
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
June 28, 2017 at 6:56 am
Try dropping the constraint and recreating it WITH NOCHECK.
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
June 28, 2017 at 4:19 am
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
June 28, 2017 at 3:51 am
Though so. Here's the problem.
FROM dbo.sfaCUSTOMER cross join (SELECT custid as newCustID, classid as newClassID, [name] as newName, billname as newBillname, team as newUser3
FROM Customer where...
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
June 26, 2017 at 3:56 pm
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
June 26, 2017 at 3:42 pm
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
June 26, 2017 at 3:32 pm
I suspect in updating after running, you may have done something to hide the error.
The first block that returned a count could not possibly have done so, because 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
June 26, 2017 at 2:22 pm
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
June 26, 2017 at 2:11 pm
Could you explain more what you're looking for?
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
June 26, 2017 at 3:11 am
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
June 23, 2017 at 8:08 am
Can you be a little more explicit about what you're looking for?
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
June 23, 2017 at 6:38 am
No plans, since it's winter. Next trip will likely be September for SQLSaturdays.
However, come December, I'm thinking about spending a week at the coast again. Below is what the view...
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
June 23, 2017 at 2:01 am
Can you please run the following on the destination database and post the full output?
DBCC CHECKDB WITH NO_INFOMSGS
Do you have any backups of that SHIPMATETEST, or...
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
June 23, 2017 at 1:53 am
Why are you rebooting the servers every week?
You can run checkDB on a secondary server. Restore the backups, run checkDB on those. Double win there, the backups...
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
June 22, 2017 at 3:47 pm
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
June 22, 2017 at 8:13 am
Viewing 15 posts - 1,231 through 1,245 (of 49,552 total)