Fun With DBCC FREEPROCCACHE

Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...

TechNet Magazine - Oct Q&A

Unexpected Consistency Checks, Troubleshooting Memory Usage, More from Paul Randal.

SQL Q & A: Database Consistency, Temporary Tables, and More

Why does DBCC CHECKDB find corruption errors that disappear? Does tempdb really cause performance issues? Are there any drawbacks to using the FILESTREAM datatype? Paul Randal answers these reader questions and more.

Replicating Identity Columns

TechEd: 80 minute video of Corruption Survival Techniques presentation

A great presentation from Paul Randal of SQL Skills from TechEd 2008. Definitely worth the time to watch.

DBCC

RE: Need a RELIABLE table-exist test

or IF Object_id('##table') > 0 begin ... end [Edit] I don't know what you're talking about Noeld.. this works perfectly on my pc . BTW.. It's tag team not team tag team.

RE: SQL Server does not exist or access denied

Is your ODBC connection set to use TCP/IP or has it defaulted to named pipes?

RE: Permissions denied

Maybe it's first step to dba? If you are a newbie on SQL Server the real dba doesn't want you to permit all rights till you won't read enough books?I remember myself in that situation  Though I was given a test sql server with sa rightsI think you must ask this who gave you such rightsCheers

RE: Phone Interview Questions

I suppose I would define Jr. level as entry level which means they have never had "real world" experience.  Just think of all the stupid questions you first asked when you first joined this forum.  That's what I would consider Jr. level.  Thank God we have contributors that don't make us feel so stupid when […]