Viewing 15 posts - 41,086 through 41,100 (of 49,552 total)
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...
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 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,
...
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 11, 2009 at 1:36 pm
Two questions.
What's the definition of Logger2?
Why is this dynamic SQL?
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 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...
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 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.
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 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?
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 11, 2009 at 1:00 pm
I have to ask, why are you attaching a database without a 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
February 11, 2009 at 11:09 am
Phil Harbour (2/11/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
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...
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 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.
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 11, 2009 at 10:35 am
Please post table structure, sample data and desired result.
Thanks
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 11, 2009 at 7:00 am
What's the exact error that you're getting?
Turn traceflag 1204 on and the deadlock detector will write a deadlock graph into the error logwhenever it finds the deadlock. That graph 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
February 11, 2009 at 6:56 am
The MERGE statement is used to merge two tables together so that the destination looks like the source.
Are these inserts, updates and deletes coming from a different table? If not,...
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 11, 2009 at 6:45 am
Krishna (2/11/2009)
Partition could be benefited if the table is queried heavily for performance reasons
If can, but the partition function must be chosen very carefully, considering how the table 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
February 11, 2009 at 6:43 am
karthikeyan (2/11/2009)
I want to know the lock count held by a procedure.
Why?
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 11, 2009 at 5:05 am
Viewing 15 posts - 41,086 through 41,100 (of 49,552 total)