Viewing 15 posts - 27,421 through 27,435 (of 49,552 total)
It shouldn't return 0 even in compat mode 80. Are you running it from the right DB? Index physical stats is not specific to a database (can be run from...
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 10, 2011 at 12:26 pm
RAISERROR ... WITH 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
March 10, 2011 at 11:56 am
Yup, that's the query to use, and you've already got it in limited mode (the most efficient)
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 10, 2011 at 11:51 am
[Jim].[dba].[Murphy] (3/10/2011)
A log truncation could have bad side effects if any part of that database is used by others; rows being modified in some way.
A log truncation runs...
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 10, 2011 at 11:40 am
Eric M Russell (3/10/2011)
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 10, 2011 at 11:37 am
Tara-1044200 (3/10/2011)
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 10, 2011 at 11:05 am
Regarding the failover time, check the throughtput and performance of your drives (log and data) and see if there are high latencies on either. Also consider changing the value 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
March 10, 2011 at 10:34 am
To do that in SQL you'd need a computed column on LEFT(other column), then you'd need to filter on that computed column. Not for performance, for when you really are...
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 10, 2011 at 10:31 am
If you have enterprise edition you can have a partitioned table. Very fast to insert into insert into an empty partition, then you can keep partitioned or merge the partition.
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
March 10, 2011 at 10:30 am
Try here - http://sqlcat.com/
You're probably not going to find large, public databases, but there are really large implementations around. Some examples:
MySpace
NASDAQ
etc
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 10, 2011 at 8:50 am
If they were good before the backup, they will be good after the restore. As for are they good in general, well, that's harder to tell. If you're having intermittent...
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 10, 2011 at 8:49 am
moris7 (3/10/2011)
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 10, 2011 at 8:45 am
Nope. Unless that's one of a few file-type backups that understands SQL, backing up the database files will get you nothing (if the backup cannot read locked files) or useless...
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 10, 2011 at 8:42 am
i must admit, data moving from dev to prod scares me. That's been a complete no-no in just about every large environment I've worked in. Too much risk of development/test...
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 10, 2011 at 8:34 am
Added at the end (past highest current value in index) is about the best for minimising fragmentation and page splits. unless you absolutely need it desc for some queries, leave...
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 10, 2011 at 8:22 am
Viewing 15 posts - 27,421 through 27,435 (of 49,552 total)