Viewing 15 posts - 40,621 through 40,635 (of 49,552 total)
Like Lynn, I have no problem with the idea of an "Answered post" It is something lacking here. I do have a small problem with this though:
I followed some of...
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
March 4, 2009 at 1:28 am
Lynn Pettis (3/4/2009)
You know, I don't mind helping him, but there are times I really have to wonder how he got to where he is.
I just don't have the...
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
March 4, 2009 at 1:20 am
Can you post the table definitions, index definitions and execution plan (saved as a.sqlplan file, zipped and attached) please?
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
March 4, 2009 at 1:10 am
Jeff Moden (3/4/2009)
Heh... I shouldn't post so late at night... I forgot the bloody spaces. :hehe:
Howcanyouforgetthespaces?
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
March 4, 2009 at 1:04 am
Lynn Pettis (3/4/2009)
And he is supposedly a Senior Software Engineer with a Masters in Computer Application and wants to pursue a Phd?
Our friend again? All yours, I'm not touching his...
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
March 4, 2009 at 1:03 am
Mangal Pardeshi (3/4/2009)
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
March 4, 2009 at 12:53 am
Yup, list all the column names (as you've done in your example)
If you don't want to type, and I don't blame you, then there's a quick way. Expand out object...
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
March 4, 2009 at 12:40 am
WHERE (a IS NULL AND b IS NULL)
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
March 4, 2009 at 12:28 am
one (3/3/2009)
Why all this worry about having the clustered index unique? 🙂
A clustered index is always unique. The only question is do you make it unique, or does SQL make...
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
March 3, 2009 at 1:06 pm
Paul Randal (3/3/2009)
Not you Gail, dmoldovan.
Yup. I realised that. Just noticed that he'd misquoted me and wanted to set the record straight.
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
March 3, 2009 at 12:38 pm
sqlcentral (3/3/2009)
The level field isn't unique across all rows, only across rows with the entry and group ids identical.
Then try this
SELECT * FROM YourTable OuterTable WHERE EXISTS (
...
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
March 3, 2009 at 12:15 pm
noeld (3/3/2009)
That is why I don't really think "Clean Shutdown" is something you can choose.
It's not. SQL will always try to cleanly shut down all of its databases before...
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
March 3, 2009 at 12:12 pm
dmoldovan (3/3/2009)
As GilaMonster said, you should NEVER use DBCC REBUILD_LOG.
Actually I said it should never be the first thing tried.
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
March 3, 2009 at 11:55 am
sqlcentral (3/3/2009)
That will only ever allow me to return 1 row, correct?
No. There's a group by in the subquery, so that query will return 1 row for...
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
March 3, 2009 at 10:58 am
sqlcentral (3/3/2009)
Yeah, there was no forum for Sql server 2000.
Yes there is. The 2000 forums are below the 2005 forums on the forum home page.
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
March 3, 2009 at 10:54 am
Viewing 15 posts - 40,621 through 40,635 (of 49,552 total)