Viewing 15 posts - 21,001 through 21,015 (of 49,552 total)
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
January 16, 2012 at 5:29 am
Jeff Moden (1/16/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
January 16, 2012 at 5:16 am
Sorry, what are you talking about? That made no sense at all.
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
January 16, 2012 at 5:06 am
SQl doesn't keep previous versions anywhere, so unless you have some form of source control or you have backups of the databases at the times those versions existed, you won't...
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
January 16, 2012 at 2:48 am
Yes it does make a difference, if it didn't I wouldn't have asked.
Multi-statement table valued functions do cache execution plans, they're treated more like procedures. That said, they have performance...
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
January 16, 2012 at 2:40 am
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
January 16, 2012 at 2:16 am
You would change the filegroup to read-write, move the data there, set it back to read-only and take a backup.
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
January 16, 2012 at 2:14 am
Inline table valued funtion or multi-statement table valued function?
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
January 16, 2012 at 1:49 am
Revenant (1/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
January 16, 2012 at 1:48 am
Jeff Moden (1/15/2012)
GilaMonster (1/14/2012)
I've seen Transcender sample tests before, they're miles from the real exams.
Then, totally switching gears, are such sample tests actually helping to learn those things necessary to...
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
January 16, 2012 at 1:46 am
Just make sure that's not an estimate on the high side.
As for locked pages - http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/
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
January 16, 2012 at 1:46 am
Jeff Moden (1/15/2012)
GilaMonster (1/14/2012)
Jeff Moden (1/13/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
January 16, 2012 at 1:41 am
Cool.
On that bug, while it says it's fixed I've heard someone say it's still a problem on even the latest builds, but I haven't confirmed that. If the table...
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
January 15, 2012 at 12:56 pm
One other thing, check that your SQL instances are patched (the latest service pack is SP3 for SQL 2008), as there was an insert-related lock escalation bug in earlier releases...
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
January 15, 2012 at 9:09 am
Pleasure.
Make sure you sort those nolocks out as well unless your users don't care about accuracy of data.
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
January 15, 2012 at 8:16 am
Viewing 15 posts - 21,001 through 21,015 (of 49,552 total)