Viewing 15 posts - 5,326 through 5,340 (of 7,185 total)
I don't know any way of aliasing like that, but if you run all commands in the context of the one database, you only need dbo.TableName.
As for only returning the...
June 2, 2011 at 7:51 am
Don't shrink your transaction log. It needs to be the size it needs to be. Shrinking wastes resources and causes physical fragmentation on your disk.
It sounds as if...
June 2, 2011 at 2:10 am
Or you could keep it ISO, and avoid all those joins, with INFORMATION_SCHEMA.PARAMETERS.
John
June 1, 2011 at 7:57 am
No. What makes you think it might be?
If you give us more information on what you're trying to do, we may be able to suggest a better way for...
June 1, 2011 at 6:52 am
I don't know what differences there are between the sort orders for those two collations - quite possibly none. However, I do know that if you attempt to join...
June 1, 2011 at 4:31 am
Harsha
Try this:
http://www.lmgtfy.com/?q=filegroups
Nobody has mentioned filegroups in this thread, so it's not particularly relevant to the problem you've described. However, it certainly won't do you any harm to do a...
May 31, 2011 at 5:44 am
Unallocated (ie free) space in the database including log is 1595MB. Log size is 14MB, of which 6% is used. That means log free space is 94%, which...
May 31, 2011 at 5:00 am
Harsha
Use sp_spaceused to get the total free space in the database (includes data and log files). Then use DBCC SQLPERF(LOGSPACE) to calculate the amount of free space in the...
May 31, 2011 at 4:27 am
Harsha
Every three months? You've barely got six weeks between the first and last dates. Could the database file be not growing because there's sufficient space in the file...
May 31, 2011 at 4:14 am
I take it that the CompName column contains the name of the asset? If so, just remove the WHERE clause - you want to return data for all assets,...
May 31, 2011 at 3:44 am
stebennettsjb (5/27/2011)
May 27, 2011 at 8:57 am
I still don't think it'll help. BackupExec backups create backup files, so they'll appear in the backupset table. BACKUP LOG WITH TRUNCATE_ONLY doesn't create any files and so...
May 27, 2011 at 6:55 am
Ninja's_RGR'us (5/27/2011)
there's also the msdb backup history tables that might have a little more info (not sure about user tho).
There's a username column in the backupset table, but since the...
May 27, 2011 at 6:49 am
Try opening the default trace, which you'll find in the same folder as your errorlog files. If it's not in there, and you don't have anything set up to...
May 27, 2011 at 6:39 am
Ivan Mohapatra (5/26/2011)
what is unc ?
As Gail said, end of discussion on this thread.
May 26, 2011 at 4:46 am
Viewing 15 posts - 5,326 through 5,340 (of 7,185 total)