Viewing 15 posts - 29,911 through 29,925 (of 49,552 total)
Why on earth are you looking for this? This has all the signs of someone trying to get around a keyword blacklist, maybe SQL injection, maybe code standards, etc.
Why 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
October 16, 2010 at 3:55 am
jaffrey (10/16/2010)
Its like what are the concepts to be asked in the interview.I am expecting that info only..
Who knows. It's not as if there's a standardised list that interviewers ask....
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
October 16, 2010 at 3:53 am
upstart (10/15/2010)
Table fragmentation can occur when modifying data .
If you're going to copy some one else's work into a forum post, at least have the courtesy to credit them. That...
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
October 15, 2010 at 4:32 pm
chulheekim (10/15/2010)
We're looking for a quick and easy fix.
Sorry, no such thing in performance tuning. Seriously, find the worst offenders (5 at max), fix them. Often that will result 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
October 15, 2010 at 4:25 pm
CirquedeSQLeil (10/15/2010)
Alvin Ramard (10/15/2010)
For some reason the MythBusters show with the cement truck just came to mind. :w00t:Epic
Big boom.
That's one of my all-time favourites, along with the shattering a...
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
October 15, 2010 at 4:23 pm
Copy stuff onto a flash drive, then leave it plugged into my desktop when I go out.
Fortunately I've got into the habit of checking for it as I put my...
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
October 15, 2010 at 2:03 pm
Long running transaction. Broken transactional replication. Disconnected database mirroring. Problematic CDC (or is it CT)
All of those can cause log growth. Next time it happens check the value of log_reuse_wait_desc...
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
October 15, 2010 at 1:14 pm
mtillman-921105 (10/15/2010)
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
October 15, 2010 at 1:12 pm
Possible: yes. Advised: Absolutely not.
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
October 15, 2010 at 1:10 pm
Brandie Tarvin (10/15/2010)
Gail,Isn't your project's "deadline" sometime next week?
It's either next Wed or end of the month, depending who you ask.
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
October 15, 2010 at 12:41 pm
In any recovery mode, the log can only be truncated to the start of the oldest active transaction or oldest unreplicated transaction (if transactional replication is present), whichever is older.
If...
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
October 15, 2010 at 12:36 pm
GSquared (10/15/2010)
And my evil master plan for conquering the world by working for a small marketing company is going exactly as I have forseen it!! 🙂
Badly?
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
October 15, 2010 at 12:31 pm
Luke L (10/15/2010)
GilaMonster (10/15/2010)
WayneS (10/15/2010)
I take it that you forgot to take your knives in with you??? :hehe:I wasn't even there today. This latest bout of insanity came by email.
Sounds...
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
October 15, 2010 at 12:30 pm
Maybe, but if your indexes are well-designed that shouldn't make that much of a difference.
Can you grab one or two of the worst performing queries and post them here? Please...
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
October 15, 2010 at 12:28 pm
WayneS (10/15/2010)
I take it that you forgot to take your knives in with you??? :hehe:
I wasn't even there today. This latest bout of insanity came by email.
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
October 15, 2010 at 12:06 pm
Viewing 15 posts - 29,911 through 29,925 (of 49,552 total)