Viewing 15 posts - 2,401 through 2,415 (of 5,394 total)
When you update stats you force a recompile for the procedure, so I don't uderstand what the difference might be after you recompile it manually.
Are you sure you're not running...
November 7, 2011 at 3:37 am
First of all determine if you REALLY have to delete the rows from the referencing tables. Is that really what you want to do?
That said, you have three options:
1)...
November 7, 2011 at 3:34 am
SQL Kiwi (11/6/2011)
Gianluca Sartori (10/27/2011)
GilaMonster (10/27/2011)
Gianluca Sartori (10/27/2011)
Vishal.Gajjar (10/27/2011)
Adhoc queries need to be exactly same for reuse. i.e. case-sensitivity, white spaces, etc...True indeed, except for whitespaces.
Actually he's completely right. The...
November 7, 2011 at 2:28 am
I ended up with a similar solution in the past because I had no other option.
However, be aware that this is not the best way to enforce security. Users should...
November 2, 2011 at 3:38 am
The wall charger outputs 2.1 A at 5.1 V, which is twice as the maximum power you can get out of a USB port.
That's why it's much quicker at charging.
October 28, 2011 at 9:23 am
Apple computers can provide up to 1100 mA at 5 V through the USB port when an Apple peripheral or device is connected directly to the port (no hubs).
"Normal" USB...
October 28, 2011 at 9:15 am
Vishal Sinha (10/27/2011)
Thanks for the input. That is what I am thinking of doing - update in batches.
I'm pretty sure it won't help. Investigate the indexes instead, that SORT table...
October 28, 2011 at 2:04 am
Could not allocate space for object 'dbo.SORT temporary run storage: 141160416542720' in database 'tempdb' because the 'PRIMARY' filegroup is full.
This message says it all.
October 27, 2011 at 8:54 am
I bet that the DISTINCT sort fills the tempdb, not the INSERT.
October 27, 2011 at 8:52 am
LadyRuna (10/27/2011)
I got it right, but only because I've read Grant Fritchey's book about execution plans. 🙂
Ouch! I read that book as well.
I'm totally hopeless.
October 27, 2011 at 8:48 am
ksummerlin-532910 (10/27/2011)
tommyh (10/27/2011)
Yes the stream aggregate gets called first... but it hasnt finished. So is the important part which gets called first or which gets finished first? Personally i think...
October 27, 2011 at 7:28 am
GilaMonster (10/27/2011)
Gianluca Sartori (10/27/2011)
Vishal.Gajjar (10/27/2011)
Adhoc queries need to be exactly same for reuse. i.e. case-sensitivity, white spaces, etc...True indeed, except for whitespaces.
Actually he's completely right. The plan cache key for...
October 27, 2011 at 6:13 am
GilaMonster (10/27/2011)
Gianluca Sartori (10/27/2011)
In SQL Server 2000 we did not have "plan cache", there was just "procedure cache" and it was a totally different story.
2000 did cache ad-hoc queries, it...
October 27, 2011 at 6:10 am
Kiara (10/27/2011)
Stefan Krzywicki (10/26/2011)
Kiara (10/26/2011)
Droid Bionic here. I have an iPad2 - and I just don't like it all that much.
What dont you like about it? Everyone I know...
October 27, 2011 at 5:57 am
ChrisM@Work (10/27/2011)
Gianluca Sartori (10/27/2011)
ChrisM@Work (10/27/2011)
Gianluca Sartori (10/27/2011)
Strange coincidence!...
Nah - you're strange, I'm a coincidence 😛
:hehe: Quite right.
Had to post - now we're even again
It's an inglorious battle for 40th place:...
October 27, 2011 at 4:33 am
Viewing 15 posts - 2,401 through 2,415 (of 5,394 total)