Viewing 15 posts - 19,711 through 19,725 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1268114-357-1.aspx
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
March 16, 2012 at 4:16 am
Backups in SQL Server are at a database, filegroup or file level, not schema. A schema is a logical grouping of objects, doesn't necessarily match to a phyical grouping 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
March 16, 2012 at 4:16 am
Yes, but...
While you could restore Fg2 separately (providing the DB's in full recovery and you're running Enterprise Edition), you'd have to then restore log backups to bring the filegroup up...
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
March 16, 2012 at 4:15 am
Edit: nm
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
March 16, 2012 at 2:53 am
Henrico Bekker (3/16/2012)
RESTORE HEADERONLYFROM DISK = N'C:\AdventureWorks2008R2-FullBackup.bak'
WITH NOUNLOAD;
GO
Why use NoUnload? It's an option only valid if the backup is on tape. For backups on disk that option 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
March 16, 2012 at 2:21 am
praspras42 (3/16/2012)
Can anyone explain me the other things that r specified in the messege.I mean wat is the requirement of other specification.
Can you explain a bit more what you want...
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
March 16, 2012 at 2:20 am
I asked Paul about that, he said as far as he knows it is an outstanding bug. It is benign though, only problem is that it's causing CheckDB to fail.
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
March 16, 2012 at 2:19 am
Yes, they will.
That said, indexing every column of the table is a poor strategy. It's unlikely to produce indexes that are useful to the queries and very likely 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
March 16, 2012 at 2:15 am
shovankar (3/16/2012)
Hi Suresh,I tried the following : select name, log_reuse_wait_desc from sys.databases where database_id = DB_ID('tempdb')
All that means is that there is currently nothing keeping the log active which...
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
March 16, 2012 at 2:15 am
Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=172135
Frankly, my advice remains the same. Check Connect and see if there are any matching bugs (I know there's a least one rollback-related bug but without knowing...
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
March 16, 2012 at 2:03 am
SANs aren't going to change index fragmentation(file system fragmentation, yes)
Index fragmentation is when an index's next logical page is not the next physical page within the file. How the files...
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
March 15, 2012 at 3:50 pm
Koen Verbeeck (3/15/2012)
It can be no coincidence that this topic is full of elite DBA's!
Damn, they're everywhere. How are honest developers supposed to get anything done I ask 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
March 15, 2012 at 2:58 pm
Grant Fritchey (3/15/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
March 15, 2012 at 2:57 pm
4 or 14 logical reads are comparable, and they're too close in time to make any broad conclusions on which is better. At that speed, the measuring inaccuracies are significant.
Personally...
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
March 15, 2012 at 2:52 pm
Optimise queries - find the heavy IO queries and tune them, or get someone in to tune them for you. See Grant's Query Performance Tuning Distilled book for more details
Upgrade...
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
March 15, 2012 at 2:48 pm
Viewing 15 posts - 19,711 through 19,725 (of 49,552 total)