Viewing 15 posts - 1,516 through 1,530 (of 5,685 total)
Sure, go for it. It'll help if you use the code="sql" wrapper you'll see on the left when you're posting, as it'll help keep format and the like for...
June 4, 2012 at 1:38 pm
pallavi.unde (6/4/2012)
Is there any optimized / repair command require for database to increase a performance ???
Monster.com, Ladders.com, etc...
You need a professional if you need heavy duty perfomance tuning.
That said,...
June 4, 2012 at 1:36 pm
CXPacket as you've already realized is merely parallelism waiting on certain threads. The CXPacket is rarely the cause of the issue, but a symptom. What you'll need to...
June 4, 2012 at 1:35 pm
SQLUserC (6/1/2012)
But if you write multiple backups to the same file, will SQL know to restore the most recent one in time?
When you're doing the restore, particularly through the GUI,...
June 1, 2012 at 3:05 pm
jcrawf02 (6/1/2012)
or a dismembered starfish
Noooo! Not more starfish!
June 1, 2012 at 1:00 pm
Awesome to hear, thanks everyone. I'll make sure we can swap up to the Native Client 10.
June 1, 2012 at 12:55 pm
For me it started because I was getting involved in a topic and got pushed over to another topic and then started browsing a third one in the middle of...
May 31, 2012 at 2:00 pm
Thanks for the kind words Myles and I'm glad it could help.
just_myles (5/28/2012)
May 30, 2012 at 1:30 pm
sp_getapplock is a simple way to make sure external calls don't end up stepping on each other during a shared usage.
Under most circumstances I've used to to make sure something...
May 25, 2012 at 4:45 pm
Chad Crawford (5/24/2012)
May 25, 2012 at 1:41 pm
I've created my own workaround but I still don't know what the problem was with the direct entry parameters above.
My workaround was to alter the PK generating script in Layer...
May 23, 2012 at 8:02 pm
SSRS 2k5 assistance requested by me. I've got parameters that just won't behave. I could use a hand if any of you have both the experience and the...
May 23, 2012 at 7:44 pm
Lynn Pettis (5/23/2012)
AAARRRRRGGGGGGG!!!!!!!Really, he just needs to go away. He isn't helpful at all.
Is it sad that not only do I know the person you're talking about, but the...
May 23, 2012 at 6:34 pm
Personally, I will usually fire up a trace against the database and goof off with a particular component of the environment. From there, I'll see what procs are called...
May 23, 2012 at 4:28 pm
Steve Jones - SSC Editor (5/23/2012)
Evil Kraig F (5/23/2012)
May 23, 2012 at 4:23 pm
Viewing 15 posts - 1,516 through 1,530 (of 5,685 total)