Viewing 15 posts - 16,816 through 16,830 (of 49,552 total)
What does the function ValidSSN do?
p.s. I hope SSN doesn't stand for social security number, because social security numbers should be stored encrypted if they're stored at all.
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
September 2, 2012 at 11:46 am
No, that's the physical name of the file. You need the logical name for shrink. It's the name column in sys.database_files.
p.s. Why are you shrinking 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
September 2, 2012 at 10:10 am
It's so good to know that I fall into the category of bad SQL programmer as well as poor database designer (for using surrogate keys) 😀
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
September 1, 2012 at 1:18 pm
As an ex-C++ and occasional C# programmer, I almost always use !=
! means NOT, so != literally means NOT Equals
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
September 1, 2012 at 8:57 am
No difference. They mean and do exactly the same thing.
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
September 1, 2012 at 3:38 am
A scheduled job that runs at 9am, disables the login and kills any active sessions using it. Another job that runs at 5pm and enables 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
August 31, 2012 at 4:01 pm
Nalini D (8/31/2012)
Did you try re-creating the indexes on the table?
Won't work. The repair fixed the damage to the nonclustered index and some damage to the clustered index, but 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
August 31, 2012 at 3:56 pm
Hell, a sharepoint DB...
Because of the way sharepoint stores the structure of the site in the tables, repairing a sharepoint DB with repair_allow_data_loss can result in an unusable site.
You did...
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
August 31, 2012 at 2:31 pm
Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
August 31, 2012 at 2:01 pm
vladimir.guerreiro (8/31/2012)
Actually, my ideia of comment here, is to see if anyone already had this crazy problem,
Sure, many times. All with very different causes.
You've described a very common symptom,...
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
August 31, 2012 at 1:52 pm
Not really. Mix of a really crap IO subsystem (500ms avg write latency) and a bad autogrow setting (10% on a file hundreds of GB in size)
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
August 31, 2012 at 12:25 pm
I remember seeing it, but back on SQL 2000. Maybe there was something else happening as well that caused it. Not sure.
There's also the case where autogrow takes too long...
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
August 31, 2012 at 11:56 am
Define 'change the lsn'
What is the problem or reason behind this question?
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
August 31, 2012 at 11:48 am
Could be one of a few things
The DB has reached the max size it's allowed and won't autogrow any more
The autogrow's too slow, probably because the growth increments are tiny...
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
August 31, 2012 at 11:44 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1352718-357-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
August 31, 2012 at 6:03 am
Viewing 15 posts - 16,816 through 16,830 (of 49,552 total)