Viewing 15 posts - 41,101 through 41,115 (of 49,571 total)
Mahesh Bote (2/11/2009)
[font="Verdana"]When Inner query is joined with Outer query, it is called co-related query. and the relation is called as query co-relation[/font]
Only when the inner query contains a reference...
February 11, 2009 at 10:37 pm
Did you run checkdb again after running the checkusage? It's normal for checkusage not to give errors. It fixes problems.
Those won't generate errors on SQL 2000. CheckDB on SQL 2000...
February 11, 2009 at 10:18 pm
FelixG (2/11/2009)
I do know it's mandatory to split out filegroups to optimize the overall performance.
It's not mandatory. It's only needed when the drive that the data file is on...
February 11, 2009 at 2:42 pm
Change the inner join to LEFT Outer and change the count as follows
CASE WHEN b.BlogId IS NULL THEN 0 ELSE COUNT(*) END AS CountComments
February 11, 2009 at 2:12 pm
krypto69 (2/11/2009)
The reason for dynamic sql, the front end has various fields the user may/may not enter and we don't know which they'll send.
Which is reasonable, but the way you've...
February 11, 2009 at 1:48 pm
The format for aliases is Expression AS Alias, and your subquery is both unnecessary and incomplete. So..
SELECT title,
body,
catid,
datePublished,
...
February 11, 2009 at 1:36 pm
Two questions.
What's the definition of Logger2?
Why is this dynamic SQL?
February 11, 2009 at 1:32 pm
george sibbald (2/11/2009)
Throwing files at user databases seems to becoming very popular, I suspect this might be one of those urban myths..................
It is. There are articles at the SQLCAT site...
February 11, 2009 at 1:28 pm
Have you done as the error said and run a checktable (or better yet, a full checkDB)? Please post the errors it returned.
February 11, 2009 at 1:12 pm
You do realise that by discarding the logs you are risking the attached database been transactionally inconsistent or even suspect?
February 11, 2009 at 1:00 pm
I have to ask, why are you attaching a database without a log?
February 11, 2009 at 11:09 am
Phil Harbour (2/11/2009)
February 11, 2009 at 11:03 am
FelixG (2/11/2009)
The new server has 8 processors and I would like to have 1 database file per proccessor,
Why? That recomendation is solely for TempDB because of potential allocation...
February 11, 2009 at 10:41 am
Not sysdatabases. The view that has the log_reuse_wait_descr column is sys.databases, a SQL 2005 system view.
February 11, 2009 at 10:35 am
Please post table structure, sample data and desired result.
Thanks
February 11, 2009 at 7:00 am
Viewing 15 posts - 41,101 through 41,115 (of 49,571 total)