Viewing 15 posts - 42,526 through 42,540 (of 49,566 total)
Maybe I'm missing something, but the two queries unioned look the same.
Why do you need to union 24 results sets? There may be a better way.
December 8, 2008 at 1:39 am
leonp (12/7/2008)
but I also want to understand where Jeff and Gail were going with their queries before I draw any conclusions
What I'm trying to get at is whether the...
December 8, 2008 at 12:42 am
leonp (12/7/2008)
I guess point-in-time recovery doesn't mean a lot to our users for this DB.
Have you asked them?
I can't tell you what the best backup type is. Only...
December 7, 2008 at 10:17 am
Means either the SQL service is restarting every night, or there's a job that's cycling the error log (sp_cycleerrorlog)
Check the beginning of the new error log, either you'll see SQL's...
December 7, 2008 at 10:13 am
debjani.bedajana (12/7/2008)
Gail,And I can run the execution plan in SQL 2000 query analyzer. But it is not letting me save it.
Please post in the correct forum in the future. If...
December 7, 2008 at 9:54 am
The question you should ask yourself in this situation is the following.
"If the DB fails 10 hours after the last full/diff backup, is the loss of all changes made in...
December 7, 2008 at 1:51 am
There's very little difference, as far as the query optimiser's concerned, between a join condition and a where clause predicate.
December 6, 2008 at 1:31 pm
2) Restore all log backups up to the point of the corruption. Use the same STOPAT and NORECOVERY options on each one.
3) Immediately perform a full backup of the database...
December 6, 2008 at 1:07 pm
sqlguy (12/6/2008)
Grant Fritchey (12/6/2008)
You mentioned that there are some types of joins that could prevent index usage. Can you give me an example of this?
CAST(Table1.Col1 AS INT) = CAST(Table2.Col1...
December 6, 2008 at 1:01 pm
Derek (12/6/2008)
Could it be possible in the FROM?
No. Same problem as in the where. Join conditions must be conditions, not statements.
Just trying to parse that query shows that it won't...
December 6, 2008 at 3:05 am
Derek (12/6/2008)
I would think WHERE (dbo.tblSkillsetType.SQLSnippet) would cause an error
Yes it will. The where clause must consist of conditions, where one expression is compared against another. As I said in...
December 6, 2008 at 2:26 am
The only way to do that is to use dynamic SQL, build up the final query and then use sp_executeSQL to run it.
Be aware of the downsides of dynamic SQL...
December 6, 2008 at 1:32 am
Does the directory 'R:\MSSQL\BACKUP' exist?
Is there anything more useful in the SQL error log
December 6, 2008 at 1:22 am
sqlguy (12/5/2008)
And I know that if a query has 5 or more tables then this indicates that the query should be refactored.
Why 5? What's magic about a 5 table...
December 6, 2008 at 1:21 am
madhu.arda (12/5/2008)
Dead lock occured again. I have couple of questions:1.In this dead lock, SPID 90 is automatically killed by SQL Server right?
Spid 90 wasn't even involved. The deadlock...
December 6, 2008 at 1:12 am
Viewing 15 posts - 42,526 through 42,540 (of 49,566 total)