Viewing 15 posts - 8,656 through 8,670 (of 49,552 total)
Really small table?
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 20, 2014 at 5:21 am
It accesses the mirror DB.
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 20, 2014 at 2:19 am
patrickmcginnis59 10839 (6/19/2014)
GilaMonster (6/19/2014)
jasona.work (6/19/2014)
The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full.
Or delete a log...
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 20, 2014 at 1:04 am
SQL Express is a free, limited version of SQL Server.
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 20, 2014 at 1:02 am
Finally...
Restore from clean backup, not repairable.
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 20, 2014 at 1:01 am
jasona.work (6/19/2014)
The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full.
Or delete a log backup. Or delete...
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 19, 2014 at 1:48 pm
david.tyler (6/18/2014)
My current employer is trying to convince our DB group SQL Server is a dying technology and open source is the way to go.
So what's his motivation here, I...
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 19, 2014 at 11:11 am
david.gugg (6/19/2014)
GilaMonster (6/19/2014)
OCTom (6/19/2014)
What gives? I thought all of us developers got admin rights!?!? :laugh:
On dev servers, I'm very happy to give developers db_owner of the DB they're working 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 19, 2014 at 11:02 am
Post the table defs, post the stored proc, post some sample data and describe exactly what you want to be inserted into the other table
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 19, 2014 at 7:55 am
Ok, 6 steps back...
What is the actual problem you are trying to solve here, what are you trying to do?
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 19, 2014 at 7:44 am
OCTom (6/19/2014)
What gives? I thought all of us developers got admin rights!?!? :laugh:
On dev servers, I'm very happy to give developers db_owner of the DB they're working in, alter trace,...
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 19, 2014 at 7:34 am
It copies everything that is in the database. Table types and permissions are in the database.
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 19, 2014 at 5:14 am
PRR.DB (6/19/2014)
If possible; i will place witness in mirror server so automatically mirror become principal. In this case it very useful, without manual interaction !.
No, because it can cause false...
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 19, 2014 at 5:12 am
Test both options, see which is best.
Bear in mind that to enable an index you need to rebuild it, so it'll only be a good idea when the time...
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 19, 2014 at 4:38 am
If this query returns multiple Cat_IDs, which one do you want to be assigned to the variable?
SET @CaseID = (121)
-- SELECT
--bl.CASE_ID
-- FROM
--Patricia.dbo.BUDGET_LINE bl
-- JOIN cat_transaction ct ON bl.EXT_REFERENCE = ct.id
--...
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 19, 2014 at 4:34 am
Viewing 15 posts - 8,656 through 8,670 (of 49,552 total)