Viewing 15 posts - 25,561 through 25,575 (of 49,552 total)
sqlfriends (6/11/2011)
in SELECT 8 from sys.database_files, there is a field called size.what unit is it? I mean is it in byte, or kb or other ?
Straight from Books Online:
size
...
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
June 12, 2011 at 3:11 am
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-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
June 11, 2011 at 10:48 am
Save the file as a .sqlplan and attach it.
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
June 10, 2011 at 4:27 pm
SQLRNNR (6/10/2011)
GilaMonster (6/10/2011)
SanDroid (6/10/2011)
i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:
This is MCM level material....
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
June 10, 2011 at 4:23 pm
At minimum the log used for the update will be 2x the size of the data changing + log header, log block, etc overhead. That's cause it logs old 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
June 10, 2011 at 2:26 pm
GSquared (6/10/2011)
MMORPGs (currently playing RIFT)
Is it any good? I'm waiting for The Old Republic in anticipation...
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
June 10, 2011 at 2:18 pm
Don't reorder the columns in the key, it changes the index's usefulness.
Need to see query, index & execution plan to say more (and I assume since you say 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
June 10, 2011 at 2:16 pm
No. Are you sure the index is useful?
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
June 10, 2011 at 12:57 pm
No. Depends on index used, scan mode used, parallelism (and that's completely ignoring joins or other operators)
It's one of those things that will appear to work reliably until something causes...
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
June 10, 2011 at 12:41 pm
Without an order by there is absolutely no guarantee whatsoever what record a TOP 1 will return. Depends on what order the last operator in the execution plan leaves it...
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
June 10, 2011 at 12:10 pm
Grant Fritchey (6/10/2011)
OK. Your level of paranoia just exceeded mine. You sure you're not a DBA?
Lol. No, not a DBA, but I do tell people how to do DBA work...
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
June 10, 2011 at 11:46 am
Grant Fritchey (6/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
June 10, 2011 at 11:08 am
Object explorer. Right click the table or index, script-> 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
June 10, 2011 at 11:01 am
LutzM (6/10/2011)
Some folks refer the transaction log backup as an incremental log backup though....
I can call a horse a car, doesn't make it one. Incremental backups != transaction log backups.
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
June 10, 2011 at 11:00 am
p.s. take that article with a pinch of salt (maybe a saltpan sized one) There's a lot of bad info in there unfortunately.
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
June 10, 2011 at 10:56 am
Viewing 15 posts - 25,561 through 25,575 (of 49,552 total)