Viewing 15 posts - 20,071 through 20,085 (of 49,552 total)
lhowe (2/27/2012)
I don't think I can avoid using LIKE in the first name since there can be first names like Michael or Mike.
Like's not going to help there, unless you're...
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
February 27, 2012 at 7:20 am
Koen Verbeeck (2/27/2012)
I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, I would've already kicked him out.
Pre-interview technical test maybe.
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
February 27, 2012 at 7:18 am
GSquared (2/27/2012)
Amusingly, that reminds me of one of the more common scam issues in EVE Online. The scam artist claims to be doing research on trust between strangers for...
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
February 27, 2012 at 7:16 am
Jeff Moden (2/27/2012)
One of the statements made was that dynamic SQL is a solution for parameter sniffing.
I certainly didn't make that claim.
I said that dynamic SQL is...
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
February 27, 2012 at 7:07 am
It might, but again it depends on whether SQL escalates the locks to table locks or not. SQL 2005 does not have partition-level locks, only row, page and table. If...
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
February 27, 2012 at 6:48 am
To be blunt, there's no way that will work. SQL requires full control over the files while the database is open. Also, the two files work in sync, if 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
February 27, 2012 at 6:45 am
As much as it needs, up to the limit you set (max server memory)
p.s. Be patient. Bumping your post after 6 hours is unnecessary. We're all volunteers, we all post...
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
February 27, 2012 at 6:03 am
The way that the snapshot works is that it only stores the old versions of pages that have changed in the source database since the snapshot was created. That's why...
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
February 27, 2012 at 6:01 am
HowardW (2/27/2012)
GilaMonster (2/27/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
February 27, 2012 at 6:00 am
Shrink is not how you control the growth of the log. The log should be big enough for the largest single transaction, the largest number of transactions between 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
February 27, 2012 at 3:46 am
eba.seller (2/26/2012)
I have read several articles and still haven't found the answer to this. Can anymore give me a step by step answer to my problem?
Sure, 2 posts above yours...
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
February 27, 2012 at 2:45 am
bteraberry (2/26/2012)
Are you saying that parameter sniffing is more likely with dynamic sql?
Parameter sniffing is the ability of the optimiser to sniff values of parameters and to compile queries based...
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
February 27, 2012 at 2:44 am
Jeff Moden (2/26/2012)
Subsequent runs, even on so simple a problem, show what I'm talking about (you and I actually agree on this... optional parameters will always be a problem).
That has...
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
February 26, 2012 at 2:15 pm
p.s. I'd rather over-estimation than under-estimation, but over-estimation means a fair-good chance that the optimiser will use operators that are suitable to huge row counts, ones that have high startup...
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
February 26, 2012 at 1:01 pm
The point of the dynamic SQL approach is to have a number of plans for the specific combinations of parameters that are passed. Having the dynamic SQL contain all 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
February 26, 2012 at 12:53 pm
Viewing 15 posts - 20,071 through 20,085 (of 49,552 total)