Viewing 15 posts - 13,216 through 13,230 (of 22,214 total)
GilaMonster (2/16/2011)
Ian Scarlett (2/16/2011)
Grant Fritchey (2/16/2011)
but I think I'm right on this one if implicit transactions are on.
I also thought that if you executed a procedure on a connection with...
February 16, 2011 at 7:19 am
Marco V (2/16/2011)
Grant Fritchey (2/16/2011)
And now it's a new one. It was time to change.did the post trigger it?
Yep. Wouldn't have bothered probably. I'm not overly driven by it. Just...
February 16, 2011 at 7:07 am
Ian Scarlett (2/16/2011)
Grant Fritchey (2/16/2011)
February 16, 2011 at 7:02 am
And now it's a new one. It was time to change.
February 16, 2011 at 6:59 am
muten79 (2/16/2011)
I have been having a read about best practices when designing a database.
I have developed an application using OIDs (object identifiers) for any class I will store in...
February 16, 2011 at 6:53 am
No one script is going to tell you what you need. There are just too many variables that you haven't defined for me to suggest a single point of focus....
February 16, 2011 at 5:28 am
kvr1985 (2/16/2011)
thank you for informationi will read the article later .how can find the slow running queries.
You can find slow running queries by using a server-side trace to gather metrics...
February 16, 2011 at 5:25 am
Assuming a standard stored procedure, when the procedure reaches it's end. With a query outside of a procedure, when the batch completes (there's a go statement or it's the end...
February 16, 2011 at 4:34 am
There was a chat about Babylon 5 one day and I decided to switch. I'm too lazy to make it something else. That's about it.
February 16, 2011 at 4:32 am
Are you sure the only difference is hardware? How much different is that hardware? Are there multiple CPU's in UAT but not in Dev or vice versa? What are the...
February 16, 2011 at 4:31 am
That's a very broad topic. What's going wrong? What have you not been able to do? Are parts working but not other parts?
February 16, 2011 at 4:25 am
You want to set up a server side trace to do that. I have a small article here on SSC[/url] describing how to do it.
February 16, 2011 at 4:19 am
Basic metrics such as wait states and queues, cpu load, disk i/o, these are the things that tell you the server is under load. It doesn't tell you why necessarily....
February 15, 2011 at 11:25 am
I'm with Cold Coffee on this, there are mechanisms that don't involved a JOIN to put data from different tables together, but you're still defining some type of relationship between...
February 15, 2011 at 10:10 am
Jeff Moden (2/15/2011)
The article also has the following statements:
...[font="Arial Black"]whereas, with a nonclustered index the leaf level contains the address to...
February 15, 2011 at 8:17 am
Viewing 15 posts - 13,216 through 13,230 (of 22,214 total)