Viewing 15 posts - 36,256 through 36,270 (of 49,552 total)
jordon.shaw (10/16/2009)
This project is almost becoming more trouble than its worth, but the boss wants it done.
May I politely suggest that you (politely) point out to your boss that...
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
October 16, 2009 at 9:42 am
ben.ward 42132 (10/16/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
October 16, 2009 at 9:42 am
jordon.shaw (10/16/2009)
With this code, I'm getting the errors that I pointed out on the last page, saying no column was specified.
See my edited post above. I rewrote the query 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
October 16, 2009 at 9:28 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
October 16, 2009 at 9:15 am
jordon.shaw (10/16/2009)
Sorry, I didn't see the from sys.tables, let me try that!
No, no, no, no, no, no!!!!
That was just an example of how the syntax works. See how I did...
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
October 16, 2009 at 9:15 am
The auto-close is the cause. Why is it enabled?
When autoclose is true, SQL will shut the database down as soon as the last user disconnects. Next time someone wants 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
October 16, 2009 at 9:08 am
Then find the latest backup that's not corrupt and restore that. Look in Books Online for the procedure for restoring MSDB. It's not quite the same as for user databases.
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
October 16, 2009 at 9:06 am
Go and rebuild all your indexes on staging as well. Do it after the stats update.
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
October 16, 2009 at 9:01 am
jordon.shaw (10/16/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
October 16, 2009 at 9:00 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
October 16, 2009 at 6:16 am
Ninja's_RGR'us (10/16/2009)
1 - Do you think the exec plans could be saved into trace? I think I remember someone talking about that in PASS 2007.
Yes, look for the Showplan...
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
October 16, 2009 at 4:44 am
tabrez.test (10/16/2009)
is there any query to get the below result
You want the 4th highest salary to sort first, then the rest of the rows, ordered by salary ascending? That can...
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
October 16, 2009 at 4:24 am
tabrez.test (10/16/2009)
(order means as they are entered in database)
So you've got a column that stores the datetime that the row was inserted? Or an identity column?
If you have neither,...
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
October 16, 2009 at 4:11 am
What's the relationship between applicant and program? Eiher a direct relationship or one via other 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
October 16, 2009 at 4:09 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
October 16, 2009 at 1:46 am
Viewing 15 posts - 36,256 through 36,270 (of 49,552 total)