Viewing 15 posts - 5,326 through 5,340 (of 18,926 total)
toddasd (6/22/2011)
I had to qualify this part
FROM
...
June 22, 2011 at 3:03 pm
matt.newman (6/22/2011)
June 22, 2011 at 3:01 pm
vivekvinodhraj (6/22/2011)
And i dont know how to take graphical output... the zip file has trace file, and you can open using...
June 22, 2011 at 2:59 pm
Brandie Tarvin (6/22/2011)
TheSQLGuru (6/22/2011)
Anyone else find it ironic that a company is moving from a FREE SQL Server product to an Oracle product? :w00t:
Meh. I've seen odder business decisions....
June 22, 2011 at 10:41 am
vivekvinodhraj (6/22/2011)
hi, please let me know if you need any other details regards this issue
I can't even open the trace file (pre 2000).
And you can't post graphical execution plan so...
June 22, 2011 at 10:06 am
Convert the PK to clustered index and you'll be fine.
June 21, 2011 at 12:09 pm
You didn't post the same query as in the original question. That query will always delete everything...
You didn't answer my question about the clustered index on that table!
June 21, 2011 at 11:50 am
Craig Farrell (6/21/2011)
UPDATE tbl SET phoneNumber = '0'+phoneNumber WHERE LEFT( phoneNumber, 1) LIKE '[1-9]'... should work.
EDIT: Dang Ninjas... sneaking in unexpectedly EVERYWHERE!
It's easy when you type more than 3 words...
June 21, 2011 at 11:47 am
So you have no clustered index on that table?
We'll also need the actual execution plan of the slow delete to be able to debug this.
June 21, 2011 at 11:25 am
SELECT CASE WHEN LEFT(PhoneNo, 1) LIKE [0-9] THEN '0' ELSE '' END + PhoneNo FROM dbo.Table WHERE...
June 21, 2011 at 11:22 am
None of the system table are 100% accurate 100% of the time.
if you need an absolute exact count then you need to do count(*). But then again that number...
June 21, 2011 at 8:20 am
Nice script!!!
June 21, 2011 at 7:20 am
HowardW (6/21/2011)
LutzM (6/21/2011)
In SS2K it's possible to control the order of the rows returned via ORDER BY in the view...
June 21, 2011 at 6:20 am
Where the heck did you read that? I've seen indexed views in 2K8!
June 21, 2011 at 2:34 am
james.morrison 19355 (6/20/2011)
Run that in a job schedule for a week or two. Then search...
June 20, 2011 at 11:34 am
Viewing 15 posts - 5,326 through 5,340 (of 18,926 total)