Viewing 15 posts - 34,861 through 34,875 (of 49,552 total)
Steve Jones - Editor (1/9/2010)
that's annoying. I hope people don't answer them, and that was what I was worried with the #sqlhelp tag.
I answered it the same way I answer...
January 9, 2010 at 11:05 am
Paul White (1/9/2010)
It would be interesting to know why you need to know this though...
Agreed. It's not something I can see all that many uses in knowing. Maybe tran log...
January 9, 2010 at 10:57 am
Why does it have to be after the 2nd column?
If you absolutely have to have the table design in that order (for whatever reason), create a new table, copy all...
January 9, 2010 at 5:52 am
shahid00704 (1/8/2010)
January 9, 2010 at 3:12 am
badkow (1/8/2010)
Just thought no one was interested. :ermm:
If I wasn't interested, I wouldn't have asked for them in the first place.
January 9, 2010 at 3:07 am
SQL will take memory a needed and will not release it unless the OS demands it back.
So if you have a SQL service that has just started and no one...
January 9, 2010 at 3:05 am
Great, now I'm getting Twitter messages (along with the PMs and mails) "Please answer this forum thread"
January 9, 2010 at 3:03 am
If you understand Assembler, you can download a debugger and the public symbols from Microsoft and read through the dump yourself. Other than that, no. The Customer Support team have...
January 9, 2010 at 2:58 am
Is there more to the error log than what you've indicated?
Did you try to query the databases from Query Analyser like I asked?
January 9, 2010 at 2:55 am
Besides, the redgate tool is SQL 2000 only.
There's a chance that this problem is repairable without any data loss at all. However, seeing as the OP has not bothered to...
January 9, 2010 at 2:53 am
ddlawal (1/8/2010)
Chicago.
Little bit far from my neck of the woods.
January 9, 2010 at 2:47 am
Just bear in mind that there are some procs (any with recompile) that will never appear at all in the cache.
January 9, 2010 at 2:46 am
Did you read the article?
What I'm asking is sample data in a usable format, something I don't have to spend hours on to get into a SQL table.
January 9, 2010 at 2:44 am
Do some analysis, work out which of the queries is the slow one. Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Why are there distincts all over...
January 8, 2010 at 1:54 pm
Take DTA's recommendations with a very large pinch of salt. Test them all carefully before you decide to implement (yes, the statistics too).
It's also worth noting that SQL seldom will...
January 8, 2010 at 1:45 pm
Viewing 15 posts - 34,861 through 34,875 (of 49,552 total)