Viewing 15 posts - 5,116 through 5,130 (of 49,552 total)
I think it's multiple people. The linguistic/competence switch didn't happen as a single event. At the time, there were clueless threads interspaced with ones showing competance, carried on that way...
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
August 3, 2015 at 11:51 am
There's a stray newline at the end of the link. Copy and paste, or click on the link and edit it in the address bar.
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
August 3, 2015 at 11:47 am
Yes, you'll need all of them
Syntax is nothing fancy. A RESTORE DATABASE with the norecovery option, a bunch of RESTORE LOG with the NORECOVERY and STOPAT options (where stop at...
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
August 3, 2015 at 11:34 am
If your developers are unwilling to do their job (developing correct, working code), then suggest to your boss that he consider getting someone in who can fix these kinds of...
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
August 3, 2015 at 11:26 am
Restore the full backup as a new database, restore the transaction log backups until just before the data was deleted. Bring the DB online. Copy the deleted rows over to...
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
August 3, 2015 at 11:22 am
Tbh, it's a stupid question which tells nothing about a candidate's ability to do the job (unless they are being hired to develop a Trivial Pursuit game)
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
August 2, 2015 at 1:14 pm
Isolation level settings are session-specific. It only applies to the session from which you're running that query, not the whole 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
August 2, 2015 at 1:05 pm
You got an answer to that on your other 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
August 2, 2015 at 1:04 pm
Jayanth_Kurup (8/2/2015)
seems to be an isolation level issue , do you have optimistic concurrency enabled?
Latches aren't related to or affected by isolation levels. The latch in question is used...
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
August 2, 2015 at 11:10 am
Please post the query, table definitions, index definitions and the actual execution plan. Without those it's near-impossible to offer any useful advice.
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
August 2, 2015 at 7:57 am
No.
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
August 2, 2015 at 7:55 am
The first log you need is the first one which started after the data-copying portion of the full backup completes. That's usually very close to the end of the backup....
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
August 1, 2015 at 2:08 am
newbieuser (7/31/2015)
Just wanted to know if there are any major changes/differences in the overall database/server level setting from the previous versions.
There are plenty of changes between the versions, new stuff,...
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
August 1, 2015 at 2:05 am
Honestly, I'd just go back to that person and explain to them how SQL's memory works and why looking at the page file is pretty much a waste of 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
August 1, 2015 at 2:03 am
Could you please post the CREATE TABLE statements for each of the listed tables, as well as same sample data in the form of INSERT statements, so that we can...
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
July 31, 2015 at 2:15 pm
Viewing 15 posts - 5,116 through 5,130 (of 49,552 total)