Viewing 15 posts - 26,266 through 26,280 (of 49,552 total)
IN does not work with a variable. You either need to use dynamic SQL (and risk SQL Injection) or find a split function and use IN with a subquery.
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
May 8, 2011 at 9:46 am
It's still cheating whether you buy them or ask for them, can still result in your certifications being revoked. Use of braindumps is forbidden by the rules of the exams.
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
May 8, 2011 at 9:44 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
May 8, 2011 at 8:12 am
Re the diff backup, google DCM (differential change map)
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
May 8, 2011 at 8:11 am
Dumps are cheating. They are actual questions taken from the real exams in violation of the NDA that all exam candidates must accept.
Using or distributing braindumps can result in your...
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
May 8, 2011 at 3:33 am
WebTechie38 (5/7/2011)
2) I am not understanding how I am breaking the log chain.
The switch to simple recovery breaks the log chain. Means that log backups taken after 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
May 7, 2011 at 4:46 pm
Page count in sys.dm_db_index_physical_stats.
It's not that you can't, it's that it's totally pointless. The point where reindexing has a performance impact is usually somewhere around 1000 pages.
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
May 7, 2011 at 12:47 pm
Generally only in the case of a disaster (fatal corruption, drive failure, server failure, 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
May 7, 2011 at 12:39 pm
Let me guess, the indexes are 2-3 pages in 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
May 7, 2011 at 12:22 pm
Not post. Call customer support. Unless it's a new bug they will charge you for the call.
http://support.microsoft.com/kb/295539
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
May 7, 2011 at 12:21 pm
SkyBox (5/7/2011)
I may have to modify my backup plan as the size increases.
If you need zero downtime, or anything close to that, a backup plan is not sufficient. It's part...
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
May 7, 2011 at 12:09 pm
Jeff Moden (5/7/2011)
GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
You can only say that once. I don't know if you had anything to do with it but congratulations...
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
May 7, 2011 at 12:07 pm
The general recommendation is to chose a fixed MB growth, as the % can give you nasty surprises with larger files.
The autogrow should not be relied on, it should be...
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
May 7, 2011 at 3:45 am
Off to SQLSaturday, the first one in Africa
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
May 6, 2011 at 11:50 pm
Brandie Tarvin (5/6/2011)
Editor's Note:
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
May 6, 2011 at 11:44 pm
Viewing 15 posts - 26,266 through 26,280 (of 49,552 total)