Viewing 15 posts - 151 through 165 (of 691 total)
I think 4 pages must be some kind of record. I think it should qualify you (us???) for special consideration in the new contest! If I hadn't seen that article...
March 4, 2005 at 12:14 pm
Don't know if this will take care of your problem, but if you'll right click on EM (in the start menu or desktop shortcut), select properties, then on the Shortcut...
March 4, 2005 at 12:08 pm
No problem! I'm glad you got it resolved! It was quite a challenge, huh?
Steve
March 4, 2005 at 10:46 am
I don't know about that version, but several years ago, we were using Veritas to back up a large database. When we attempted to restore the database during a disaster...
March 2, 2005 at 12:52 pm
TJP8,
If you answered this in a previous post, please forgive me for not going back and reading the whole thing! Is your recovery model full or bulk logged? In the...
March 2, 2005 at 12:49 pm
As Remi said, this is still running 2 queries, just one inside another....
use pubs
go
select top 10 au_lname, au_fname,
(select count(*) from authors) as num
from authors
Steve
March 2, 2005 at 11:56 am
subban,
The only information that you posted was for the heap (index id = 0). If you have nonclustered indexes on the table, the dbcc showcontig should have similar...
March 2, 2005 at 10:36 am
Occasionally, Taskpad will throw an error, and ask if you wish to "continue running scripts on this page". It seems some installations of Enterprise Manager are more prone to this...
March 2, 2005 at 10:31 am
The index ID in the showcontig results are for index ID = 0 , which is not an index, but is the heap (the data itself). If this is the...
March 1, 2005 at 12:43 pm
How long did you let the delete run before stopping it? When you stop an action like that, SQL has to roll back the changes, and that will take about...
March 1, 2005 at 12:32 pm
In most cases, your full backup file will be close to the size of the utilized part of the data file plus the utilized part of the transaction log. So,...
March 1, 2005 at 12:21 pm
From a different angle... I'm not sure I agree that shrinking the database in the scheduled backup job is standard stuff. Are you backing up weekly? daily? more often? If...
March 1, 2005 at 10:06 am
If you only consider acct_dt, in your current scenario, a query that searched based on acct_dt would use index PO_LINE_SHIP2. In your suggested scenario, a...
February 18, 2005 at 12:30 pm
Same here, Dave.
Couldn't get the output I needed from Microsoft Documented procedures, so I hacked my own. Works great! I just hope Microsoft doesn't change or eliminate it. But if...
February 17, 2005 at 4:36 pm
sp_change_users_login doesn't work for NT logins because it shouldn't have to. NT logins get their SIDS from NT, so they should not be orphaned.
Also, you can pretty easily fix...
February 17, 2005 at 3:36 pm
Viewing 15 posts - 151 through 165 (of 691 total)