Viewing 15 posts - 15,916 through 15,930 (of 49,552 total)
If both logs are full, it'll autogrow one, then the other, repeat. SQL does not ever write log records in parallel to multiple log files.
As for the tests, can you...
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
October 25, 2012 at 5:12 pm
Why do you want each partition in its own filegroup?
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
October 25, 2012 at 3:30 pm
Luk (10/25/2012)
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
October 25, 2012 at 3:30 pm
Correlated subqueries do not run per row of the outer query (unless triangular joins or top 1 ... order by).
Correlated subqueries are not usually more expensive than joins, they usually...
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
October 25, 2012 at 1:53 pm
What wait type is the query incurring?
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
October 25, 2012 at 1:48 pm
What am I supposed to be looking at? Lots of VLF data, but I see nothing that tells me anything useful.
As I already said, if you check BoL, truncateonly is...
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
October 25, 2012 at 1:40 pm
samalex (10/25/2012)
GilaMonster (10/25/2012)
cppwiz (10/25/2012)
You will only have about 90 seconds per question to read, interpret and answer the question.The exams are 3 hours long and have 30-40 questions in them.
Wow,...
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
October 25, 2012 at 1:08 pm
cppwiz (10/25/2012)
You will only have about 90 seconds per question to read, interpret and answer the question.
The exams are 3 hours long and have 30-40 questions in them.
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
October 25, 2012 at 9:15 am
How are you inserting from a file?
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
October 25, 2012 at 8:14 am
You can set its deadlock priority to high.
Or, if you want help in fixing it, switch traceflag 1222 on. That will result in a deadlock graph been written to 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
October 25, 2012 at 7:40 am
arkiboys (10/25/2012)
how do I know that if the machine m goes down, then automatically the applications are redirected to the mdr (DR database machine)?
Run a DR test. Fail the mirroring...
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
October 25, 2012 at 6:07 am
If the mirroring is working, the data in the mirror DB will be correct. You could take a snapshot off the mirror and query that if you want.
SQL Agent jobs...
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
October 25, 2012 at 5:22 am
For DDL you may need to use EXECUTE AS in the procedure definition. Your original post asked about DML.
Just... why procedures that alter the DB structure?
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
October 25, 2012 at 4:59 am
Not ignores. At compile time (before any of the batch is executed), the variable doesn't have a value and hence any value it gets during execution can't be sniffed and...
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
October 25, 2012 at 4:58 am
Probably waits, yes.
3 reads doesn't look like there was much data...
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
October 25, 2012 at 4:32 am
Viewing 15 posts - 15,916 through 15,930 (of 49,552 total)