Viewing 15 posts - 19,786 through 19,800 (of 49,552 total)
Steve Jones - SSC Editor (3/13/2012)
Lynn Pettis (3/13/2012)
Stefan Krzywicki (3/13/2012)
GSquared (3/13/2012)
Gianluca Sartori (3/13/2012)
No, seriously, you'd better ignore him.
A wise man once told me...
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
March 13, 2012 at 2:23 pm
SQL Guy 1 (3/13/2012)
This is what I also thought, but hoped that there is some solution. I've been waiting for many hours already.
Wait until it's finished, it's not...
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
March 13, 2012 at 2:15 pm
SQLKnowItAll (3/13/2012)
Does it make sense to do something like this?
SELECT TOP 1000 *FROM TableA OPTION(FAST 1000)
No, makes no sense whatsoever. You're saying get me the first 1000 rows as soon...
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
March 13, 2012 at 2:13 pm
Marts (3/13/2012)
Do you guys know if the server would tell me if there are deprecated features in there, or would they not come to the surface until called?
Features that have...
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
March 13, 2012 at 2:11 pm
You can't change SA's permissions, so the question is moot.
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
March 13, 2012 at 2:08 pm
And the system procedures won't show them things that they don't have permission on. So they can't use a system procedure to see the definition of a table that they...
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
March 13, 2012 at 9:59 am
Not without potentially breaking things. Those are system procedures.
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
March 13, 2012 at 9:45 am
Ken at work (3/13/2012)
So in addition to that you're saying that SQL 2005 may run somewhat slower on some queries. Swell!
A very small percentage of queries (and I mean very...
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
March 13, 2012 at 8:45 am
Please can you edit your post so that only the code is within the code blocks.
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
March 13, 2012 at 8:24 am
TheSQLGuru (3/13/2012)
Remember, max mem setting just controls the sql server BUFFER POOL - there are MANY other buckets of memory sql will use that are NOT constrained by that number.
Don'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
March 13, 2012 at 8:21 am
There are some query performance regressions in SQL 2005, usually involving 'questionable' SQL. Maybe post it (I suggest a new thread so that people see that it's a new question)...
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
March 13, 2012 at 6:52 am
Draelith (3/13/2012)
do I schedule a regular transaction log shrinking? Is this a safe thing to do? Is it recommended that I do this?
No, yes and no. Please read through...
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
March 13, 2012 at 3:31 am
Stefan Krzywicki (3/12/2012)
GilaMonster (3/12/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
March 13, 2012 at 3:18 am
Closed the gmail account the other week. I never wanted it, never intentionally created it, it just appeared one day as part of a google revamp. Two mail addresses on...
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
March 12, 2012 at 4:17 pm
Eugene Elutin (3/12/2012)
You don't need NTILE...
No, but the whole purpose of ntile is to assign rows to one of n sets, which is exactly what the OP wants.
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
March 12, 2012 at 4:15 pm
Viewing 15 posts - 19,786 through 19,800 (of 49,552 total)