Viewing 15 posts - 10,171 through 10,185 (of 49,552 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...
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
January 30, 2014 at 5:02 am
No difference
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
January 30, 2014 at 4:57 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...
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
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...
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
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...
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
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
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
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...
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
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.
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
January 30, 2014 at 12:25 am
BriPan (1/29/2014)
Can anyone suggest me what to do with that column how can i...
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
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.
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
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...
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
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
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
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...
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
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/
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
January 29, 2014 at 11:41 am
What recovery model is the database in?
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
January 29, 2014 at 10:53 am
Viewing 15 posts - 10,171 through 10,185 (of 49,552 total)