Viewing 15 posts - 43,426 through 43,440 (of 49,552 total)
If neither query does exactly what you want, post the table structure, some sample data and your expected result.
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 30, 2008 at 10:26 am
MrBaseball34 (10/30/2008)
Well, that doesn't seem to work either.
Please define 'that doesn't seem to work'. Did it throw an error? If so, what error. Does it give incorrect results? If so,...
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 30, 2008 at 10:13 am
The second portion of your where clause is effectively turning the join into an inner join
select count(new.PolicyID) as New, count(ren.PolicyID) as Ren
from Policies new left join Policies ren on new.PolicyID=ren.OldPolicyID
where...
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 30, 2008 at 10:09 am
Duplicate post.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic594447-391-1.aspx
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 30, 2008 at 10:01 am
There's nothing similar to audit logins for anything else. If you want to track DDL changes, you'll have to use a DDL trigger or a server-side trace that's permanently running....
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 30, 2008 at 9:58 am
Backup and restore's the safest. If you haven't made changes to model on SQL 2000, you can ignore that one. Unless you're moving all the jobs, etc, ignore msdb as...
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 30, 2008 at 9:46 am
Loner (10/30/2008)
The size of tempdb is 328 MB.
Yes, you said so earlier. What's the initial size for tempDB? The size it gets created at on a restart? (Should...
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 30, 2008 at 9:45 am
Loner (10/30/2008)
When I query the sysprocesses, I saw a lot of PAGEIOLATCH_SH. What is that meant?
What were the wait resources?
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 30, 2008 at 7:05 am
These two links should help
http://www.microsoft.com/learning/mcp/mcts/sql/
http://www.microsoft.com/learning/mcp/mcitp/dbdev/
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 30, 2008 at 7:04 am
Loner (10/30/2008)
The autoshrink is not turned on in tempdb but the unrestricted file growth is turned on.
As it should be. What's the initial size for tempDB?
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 30, 2008 at 7:02 am
You are correct, an order by in a view or subquery is ignored. Order by only applies if it's in the outer select statement, unless there is a row-limiting top...
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 30, 2008 at 5:41 am
The default trace is hard coded at 5 files. The only thing you can do with it is disable it.
I would suggest you set up your own trace. Put 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 30, 2008 at 3:50 am
Matt Miller (10/29/2008)
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 30, 2008 at 2:14 am
ALZDBA (10/30/2008)
GilaMonster (10/29/2008)
... SQL 2000? ...Indeed.
Try doing DBCC indexdefrag from time to to time on those 'no downtime' systems. It is an online operation.
This means that I'll only be...
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 30, 2008 at 2:09 am
Makarand Mohandas (10/29/2008)
Another option is try to backup of the tempdb before u try truncate it or shrink it.
You can't backup tempDB at all
Backup database tempdb to disk =...
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 30, 2008 at 1:44 am
Viewing 15 posts - 43,426 through 43,440 (of 49,552 total)