Viewing 15 posts - 30,721 through 30,735 (of 49,552 total)
Both.
If there are multiple files in a filegroup SQL will stripe data across all of 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
September 14, 2010 at 2:47 am
Try taking another backup?
With a SQL 2000 backup, Verifyonly is going to check the headers and just a couple other things. Not a guarantee that the backup will restore.
Also 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
September 14, 2010 at 2:35 am
There's no fixed set of questions, different companies will ask different questions. Memorising questions is not the way to go about preparing for an interview. A good interviewer can tell...
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
September 14, 2010 at 2:26 am
Sounds like the backup is corrupt or the original database is corrupt. Is there any way you can get a fresh backup of the 2000 database? If so, run this...
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
September 14, 2010 at 2:17 am
The only content you're going to find at the MS site is the list of skills measured.
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us#tab2
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
September 14, 2010 at 2:16 am
shaik.masrath (9/14/2010)
It is not possible to take Transactional log backup. becoz in simple recovery model transactions are not stored in .LDF file after a full backup.
Um, no.
In simple recovery inactive...
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
September 14, 2010 at 2:01 am
Hey Jeff. Please join the club of people that clearly don't know what a BIT column is. How dare you say that the working code is not working! 😀 :hehe:
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
September 13, 2010 at 3:32 pm
Redgate's SQL Compare is good here.
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
September 13, 2010 at 3:31 pm
sqlbuddy123 (9/13/2010)
So here is the deal..If Total Memory >= Target Memory ------> Represents Memory Pressure
If Total > Target it means that SQL is trimming its working set due to a...
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
September 13, 2010 at 3:27 pm
Ninja's_RGR'us (9/13/2010)
GilaMonster (9/13/2010)
Please note: 4 year old thread.Are they any less clueless now?
Not from what I've seen here.
Doubt it. That would violate the law of conservation of cluelessness.
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
September 13, 2010 at 1:52 pm
Please note: 4 year old 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
September 13, 2010 at 1:27 pm
The book Steve recommended is a good one.
The thing is, perf tuning's a huge area and one that's not easy to learn by yourself. I got a start by learning...
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
September 13, 2010 at 11:45 am
The primary key is an index, always. Whether it's better as clustered or nonclustered is hard to say without analysing the system. The queries that run against the tables determine...
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
September 13, 2010 at 9:53 am
Please note: 4 year old thread bumped by a spammer.
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
September 13, 2010 at 9:46 am
Please post execution plan as a .sqlplan file as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Can you edit that query and qualify the join columns with their table names? Sounds like you've managed to create...
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
September 13, 2010 at 9:39 am
Viewing 15 posts - 30,721 through 30,735 (of 49,552 total)