Viewing 15 posts - 28,426 through 28,440 (of 49,552 total)
Both the replace and the leading % will prevent index seeks. The SELECT * will likely make SQL just scan the table as you're asking for every single column
As written...
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 17, 2011 at 2:21 am
Yeah, that'll do it.
Post the queries and plans?
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 17, 2011 at 2:04 am
kln2020 (1/17/2011)
ok, how can I know the defult time that sql define for checkpoint ?
Depends on activity and some config settings.
I ask you this because when I run some...
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 17, 2011 at 1:56 am
Sorry, I don't understand what you're asking. Could you be clearer please?
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 17, 2011 at 1:03 am
Koen (da-zero) (1/17/2011)
Lynn Pettis (1/16/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
January 17, 2011 at 1:02 am
An 825 error requires no repairs.
825 means that an IO operation failed, but then succeeded on the 2nd, 3rd, 4th or 5th retry. Hence why it's classified a severity 10....
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, 2011 at 10:40 pm
(DB_STR, <code page>, 2000) <Source column name> should work. Replace <code page> with the code page you're using and <Source column name> with the name of the source column
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, 2011 at 10:19 pm
Lynn Pettis (1/16/2011)
(No, I am not providing a link to this one as this is just a rant.)
Considering how active (not) a sunday night is, it's not hard to guess...
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, 2011 at 5:56 pm
Lynn Pettis (1/16/2011)
GilaMonster (1/16/2011)
...
Gail, just read this thread. Interesting how the OP couldn't deduce what you were saying from your original answer. I guess the real problem we...
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, 2011 at 2:51 pm
Literally at some point later. Either when a checkpoint runs or when the lazy writer runs and selects that page.
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, 2011 at 2:49 pm
Can Gus and Stefan please PM me an email address if they are still interested in proof-reading an article.
Thanks
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, 2011 at 1:57 pm
They don't.
In Exchange log records are later written to the DB, that's not how SQL's log works though. When a change is made in SQL it is made to 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
January 16, 2011 at 1:27 pm
Probably because your data file had to grow, and it won't grow by just 2 pages, it grows by whatever the autogrow size is. Other than the 2 pages allocated...
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, 2011 at 10:54 am
Because the amount of used space didn't chance, the amount of free space did. Hence the percentage of the file that was in use increased.
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, 2011 at 10:52 am
Shrink won't reduce the amount of space used within the log, only the size of the file.
So if the log was 200 MB and 20MB of it was in use,...
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, 2011 at 10:03 am
Viewing 15 posts - 28,426 through 28,440 (of 49,552 total)