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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 9, 2010 at 5:52 am
shahid00704 (1/8/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 9, 2010 at 2:53 am
ddlawal (1/8/2010)
Chicago.
Little bit far from my neck of the woods.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 8, 2010 at 1:45 pm
Viewing 15 posts - 34,861 through 34,875 (of 49,552 total)