Viewing 15 posts - 10,171 through 10,185 (of 49,566 total)
syslogins is an old SQL 2000 compatibility view. Since you couldn't disable logins in SQL 2000, the view won't show the disabled property. Use sys.server_principals, which is the current view...
January 30, 2014 at 5:02 am
GilaMonster (1/29/2014)
Where is it showing 4GB? What are you checking, looking at or running to get the size of the file?
Post your query or screenshot or whatever else is showing...
January 30, 2014 at 3:49 am
PearlJammer1 (1/30/2014)
Yet there is no message in the sql error log to say that a dbcc checkdb command ran on the system databases or another databases for that matter.
Then it...
January 30, 2014 at 2:37 am
Test your query against representative data volumes. Does it perform acceptably? If so, don't waste your time trying to fix something which isn't a problem.
If it doesn't perform acceptably, then...
January 30, 2014 at 2:36 am
Same things that happens any other time you take a log backup, nothing special.
I wouldn't try restoring the log unless you're doing the initial setup of the mirroring
January 30, 2014 at 2:33 am
Consider a view or custom UDF in each database that does the calculation. If it's a function, you'll have to pass it a parameter of getdate because of the restriction...
January 30, 2014 at 12:32 am
You can still not nest transactions, it just requires a little more work around whether there's an open transaction, whether to start another transaction, when to rollback, etc.
January 30, 2014 at 12:25 am
BriPan (1/29/2014)
Can anyone suggest me what to do with that column how can i...
January 29, 2014 at 11:54 pm
samsql (1/29/2014)
Kindly suggest.
Tune the code, tune the indexes (or get a consultant in to do so). See the book and articles I referenced to guide you.
January 29, 2014 at 11:15 pm
All tables (well, almost all) should have a primary key and should have a clustered index. Whether these are the same or not is another matter.
If you want an ordered...
January 29, 2014 at 11:08 pm
Tune the code, tune the indexes
Chapter 3 - https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
and
January 29, 2014 at 10:59 pm
durai nagarajan (1/29/2014)
Some times it allows you to take tail log backup (with continue on error) and restore it , you may get all the data.
WITH NO_TRUNCATE
and that's called...
January 29, 2014 at 10:55 pm
Then you may be able to hack-attach the database and take a tail-log backup.
http://www.sqlskills.com/blogs/paul/disaster-recovery-101-hack-attach-a-damaged-database/
http://www.sqlskills.com/blogs/paul/disaster-recovery-101-backing-up-the-tail-of-the-log/
January 29, 2014 at 11:41 am
What recovery model is the database in?
January 29, 2014 at 10:53 am
Viewing 15 posts - 10,171 through 10,185 (of 49,566 total)