Viewing 15 posts - 34,111 through 34,125 (of 49,552 total)
CirquedeSQLeil (2/9/2010)
GilaMonster (2/9/2010)
george sibbald (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.
Expert?...
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
February 9, 2010 at 10:02 pm
Roust_m (2/9/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
February 9, 2010 at 9:55 pm
The only way that you can get a clustered index seek is to filter on the clustered index. Since you're not filtering on the clustered index columns, you're not going...
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
February 9, 2010 at 9:41 pm
J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be so rude...
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
February 9, 2010 at 2:06 pm
Digs (2/9/2010)
All you ask for is in this thread, just in different posts.:-)
The only execution plan I see is in your first post. That's an estimated plan. I need 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
February 9, 2010 at 12:09 pm
Steve Jones - Editor (2/9/2010)
The other problem is that the MVP is a community service award, but perceived as a technical one.
It's both. Someone who blogs 5 times a...
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
February 9, 2010 at 11:14 am
No, it is not.
The only way is to script all the objects, export all the data and recreate the DB on a lower version.
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
February 9, 2010 at 9:52 am
GSquared (2/9/2010)
Gail, I'm not sure past-tense verbs work in this context. Didn't Hitchhiker's Guide have a discussion of verb tenses in time travel situations?
No, but the common English language...
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
February 9, 2010 at 9:41 am
Steve Cullen (2/9/2010)
Unless you or someone else creates a table in msdb, they are all system tables. Unless I'm missing something.
The tables in MSDB are not classified system tables...
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
February 9, 2010 at 9:35 am
It looks like you have a condition after the ELSE. That's not how CASE works, the ELSE is the catch-all for data that doesn't satisfy any of the preceding checks
CASE
...
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
February 9, 2010 at 9:32 am
No worries, that's why we have the article on posting best practices, for new people to read.
Doctork11 (2/9/2010)
I corrected my posting. 😀
Where? I can't see table design or any...
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
February 9, 2010 at 9:27 am
That's because they are classified user tables. Try
WHERE OBJECTPROPERTY(id, N'IsMSShipped') = 0
If that doesn't work, can you explain what tables you do what to see and what tables you don't...
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
February 9, 2010 at 9:26 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
February 9, 2010 at 9:11 am
george sibbald (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.
Expert? Yeah right...
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
February 9, 2010 at 9:06 am
mehmetburak.akkus-832492 (2/9/2010)
hi guys 🙂is there a full description or a white paper for this command ?
Um.... Take a look at the comments on the first page, take a look at...
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
February 9, 2010 at 8:56 am
Viewing 15 posts - 34,111 through 34,125 (of 49,552 total)