Search results for query: *

You'll want to have a couple of years of experience with SQL Server 2008 before taking the exam. The Microsoft site explains the topics which are going to be covered on the exam. If you have gaps in your knowledge you'll want to get some books on those specific topics and practice with them on...

Not sure where you got the idea that you don't need insurance from. You'll still want to pick up E&O insurance to cover yourself. It isn't that expensive (depending on where you are, kind of work, etc.) and it is worth it to have. Some clients will require it. You'll need a lawyer to help...

Most companies will pay you very close to the deadline. Most of my clients that are NET 30 pay on day 29 or 30. A few day a day or two late. If they pay later than that, I start invoicing them late fees. That usually does the trick. If the client regularly pays late and they complain about...

Yes. The default way that SQL Server security works is that users can execute stored procedures without needing access to the underlying tables. The exception from this is if you are using dynamic SQL within the stored procedure. If you are using dynamic SQL within the stored procedure you'll...

Change the database to simple recovery mode. Checkpoing the database. Shrink the transaction log. Use a loop to create a table then delete the table over and over. Monitor which VLFs are in use to ensure that you overwrite all of the VLFs in the database. Here's a loop that you can use...

That's about the best way. Try adding the switch /Y to allow overwriting of files. Odds are there's a duplicate file name. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration) MCITP...

Lots of dynamic SQL using the undocumented procedure sp_MSforeachdb and sp_MSforeachtable. You'll need to get the list of columns to search by using the sys.columns table. Look for any columns which have a data type which can support text values. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL...

Try installing Visual Studio 2005 first. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration) MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008...

IntelliSence for SSMS sucks so bad because it's a low priority. The sad fact is that as there are only so many man hours there's only so much stuff that can be worked on and IntelliSence is pretty low on the list (I'm good friends with the PM that owns IntelliSence among other parts of SSMS)...

As it's a 32bit application it'll still be limited. You can use AWE to get past this but you'll be better off installing a 64bit edition of Windows and a 64bit install of SQL Server so that the memory problems just go away. This will require that you format and reinstall from the ground up...

For most of my large servers (64Gigs plus) I stick with 4-8 Gig page file. Doing memory size and higher doesn't really work with 256 Gigs of RAM. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007...

No you cannot use T/SQL to get a users password. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration) MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI /...

No, only a single witness is supported. You'll want to put the witness at the backup data center. Mirroring doesn't require quorum like Clustering does. The witness is the only machine that matters. If it looses connection to the primary it tells the secondary to take over. There's no...

You might want to look at the Virtual Storage Appliance (VSA) on vSphere 5. It'll let you build a cluster without the need for the shared storage and it'll handle the storage replication for you automatically. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA /...

Sounds like the file is corrupt, or the hard drive is turning off or something. Is it a USB hard drive? Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration) MCITP (SQL 2005 DBA / SQL...

Using OPENROWSET is a hack in this case and will take much more resources than doing a bulk insert. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration) MCITP (SQL 2005 DBA / SQL 2008...

You've got data mismatch problems in your system objects. Repair won't fix this. Do you have objects which match the object_ids that are reported? It sounds like someone went in and edited the system objects directly and made a mess of things. You might be able to do a repair with data loss...

Log shipping and maintenance plans are stored in the msdb database. You can just detach the databases and you'll be fine. The log shipping will need to be restarted from scratch. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI /...

The data should be about 8 Gigs give or take. The data types in use will change that a bit. That means that you'll need at least 8 Gigs of transaction log space as well. Also if you've got indexes on the destination table those take up space as well and need to be accounted for. Denny MCSA...

Just use sp_send_dbmail which will automatically attach the output of a query to the email. The output can either be an attachment or it can be the subject of the email. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0...