Viewing 15 posts - 11,221 through 11,235 (of 22,214 total)
It really depends on the query. I had one that took 3 minutes to compile but ran in about 500ms. It was an abnormal situation (86 table join), but easily...
March 9, 2012 at 6:06 am
Dave Ballantyne (3/7/2012)
havent been around 'the thread' for a while, and only dipped in and out of SSC, been a bit busy :ermm:
Im running a lunch time user group...
March 7, 2012 at 4:08 pm
try pulling up an estimated plan to see what it's trying to do. Then you can compare the good execution with the bad one.
February 27, 2012 at 9:54 am
D.Oc (2/26/2012)
Grant Fritchey (2/25/2012)
Wow! That's great. The job I have currently was the only one that seemed aware I had written anything on the subject of SQL Server (except one...
February 26, 2012 at 5:39 am
Lynn Pettis (2/25/2012)
Grant Fritchey (2/25/2012)
Lynn Pettis (2/24/2012)
February 25, 2012 at 3:17 pm
LutzM (2/25/2012)
Jeff Moden (2/25/2012)
Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx
<shudder>
It becomes rather scary when seen in...
February 25, 2012 at 12:28 pm
Jeff Moden (2/25/2012)
Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx
That's just an ouchie. No other way to...
February 25, 2012 at 12:18 pm
I'd suggest picking up a copy of Itzik Ben-Gan's excellent book, TSQL Query Fundamentals
February 25, 2012 at 12:17 pm
Lynn Pettis (2/24/2012)
February 25, 2012 at 5:06 am
Stefan Krzywicki (2/24/2012)
BrainDonor (2/24/2012)
HowardW (2/24/2012)I'm not convinced these things are a massive opportunity to learn new skills in details,
I think it depends on the presentation you go to and...
February 24, 2012 at 10:02 am
Going back on topic for just a moment, Gail, did you enjoy the exchange with the guy that wanted to delete his log over on SO? People can be such...
February 24, 2012 at 5:09 am
Loundy (2/24/2012)
sqlzealot-81 (2/23/2012)
Try re-registering TextMgrP.dll.
This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"
Also, If you have a 3rd party IntelliSense installed (such...
February 24, 2012 at 4:57 am
Brandie Tarvin (2/24/2012)
I just tried to check a couple of topics via the notification...
February 24, 2012 at 4:38 am
Oh, well then... maybe you need an index.
Oh, and are you on the latest service pack? They had quite a few issues with the RTM version and SP1 didn't fix...
February 23, 2012 at 2:50 pm
Sounds like the index is no good, but I'll bet you already figured that out.
To get started with spatial, I'd pick up a copy of Alistair Aitchison's book, Beginning Spatial....
February 23, 2012 at 12:46 pm
Viewing 15 posts - 11,221 through 11,235 (of 22,214 total)