Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Get out of a jam by using SQL Server's DBCC
- DBCCTo perform DBCC is it necessary that the DB should be in 'Single-User-Mode'. If is it so why? Can anyone justify it?Regards,G.Rajamurali.DBCCIts not necessary for the DB to be in single user mode to run DBCC, it is necessary for the
- Tags: DBCC, grajamurali@..., Microsoft SQL Server, security, server, software
- Discussion threads 2007-01-02
- Get out of a jam by using SQL Server's DBCC
- Arthur Fuller reveals why you should get to know the database consistency check DBCC. He also explains how to run DBCC and how to use five of its extensions. In moments of distress, the database consistency check DBCC may prove to be your most valuable friend. This tip...
- Tags: Microsoft SQL Server, DBCC, Arthur Fuller, Storage, Databases, server, database, SQL Server Newsletter, TechRepublic Inc., Index, Argument, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2006-12-21
- How to show senior (non IT) managers what performance gains they can get
- Right get ready to laugh but my company has 10 2000 SQL servers but no DB, or in fact anyone approaching a DB. SO I have taken it on myself to have a look around having had some experience before, But please go easy on the answers as my SQL...
- Tags: Performance management, edward@..., performance
- Discussion threads 2007-11-01
- Inserting specific values into identity columns
- Setting the next index valueYou may also want to execute DBCC CHECKIDENT to check then set the next identity value if you plan to insert new rows.
- Tags: Value at Risk, techr@..., one more thing, software
- Discussion threads 2005-07-14
- dbcc logical scan
- I have a database on sql server 2000 sp4. Not long ago I had something wrong with my transaction log and the DB went into "suspect mode". Microsoft showed me basically how to destroy the transaction log and rebuild it. I didnt loose any data, everything had already been commited....
- Tags: Databases, fragmentation, Avg
- Discussion threads 2005-12-29
- Track down deadlock errors with the SQLDiag utility
- SQLDiag, introduced in SQL Server7.0, is a very handy SQL Server utility that you can use to monitor yourdatabase server for problems. It is a command-line tool that was created toprovide necessary information for Microsoft customer support calls. When run,the tool outputs data from different SQL Server utilities into a...
- Tags: database, deadlock, Microsoft SQL Server, server, SQLDiag, Tim Chapman
- Technical articles 2006-09-18
- Avoid (zip)
- Avoid is fun and challenging at the same time. Just control the blue ball with the arrow keys to avoid the increasing amount of red balls. The longer you last the more chance of becoming #1 on the high scores. This version is the first release on CNET Download.com.
- Tags: Arrow, MP Stuff
- Software downloads 2008-04-17
- Renaming/Removing extended system extended stored procedures
- Hi.Can someone please point me in the right direction for rendering a list of system extended stored procedures? I've tried using sp_rename, drop procedure, sp_dropextendedstoredproc and dbcc dropextendedstoredproc. All to no avail.I've tried creating a user that is a memeber of the sysadmin and securityadmin sever roles, and...
- Tags: craigh@...
- Discussion threads 2007-09-25
- Two SQL Server maintenance tips to help you service like a pro
- By Kaye GartenSure, database maintenance is usually left to the “DBA guys,” but occasionally as a developer you’ll be pressed into service. So, try out these two SQL Server maintenance tips and learn to change database owners and defrag your indexes with ease. Who knows? You could even teach those...
- Tags: Storage, Databases, Guest Contributor, server, database owner, database, ISUser1, ISUser2, Microsoft SQL Server
- Technical articles 2003-01-10
- MS SQL Maintenance Plan Help!
- I’m trying hard to figure out what the write way of managing our SQL server is. We have sporadic success. Sometimes the jobs work sometimes they do not.We would like to implement an effective MS SQL Maintenance Plan. Should we use the wizard or something else, not sure?Sorry if this...
- Tags: cd2041@..., DBCC CHECKDB, Help, job, Maintenance, maintenance plan, MS-SQL, Plan, software, sql maintenance plan
- Discussion threads 2005-08-10
- TechNet Webcast: Data Recovery in SQL Server 2005 (Level 200)
- This webcast covers troubleshooting methods and tools in Microsoft SQL Server 2005 that one can use to recover from various scenarios. Topics include database access problems, such as the database being marked as suspect during recovery; backup and restore failures; database runtime consistency failures, such as checksum; and DBCC CHECKDB...
- Tags: Data Recovery, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Microsoft TechNet, Storage, Databases, Digital Media, Hardware, Enterprise Software, Software, Data Management, Consumer Electronics, Personal Technology
- Webcasts
- Avoid Download for IE (zip)
- Avoid Download for IE has an interface that allows you to choose one of the following function, Stop Download or Enable Download. For each particular function you have chosen will take effect only when you restarted Internet Explorer. You can leave Avoid Download for IE in your System Tray by...
- Tags: Microsoft Internet Explorer, OneWordinKhmer, Web Browsers, Internet
- Software downloads 2008-07-11
- MSDN Webcast: Secrets to Fast Detection and Recovery From Database Corruptions (Level 400)
- It is all about limiting downtime and data loss when a corruption occurs, from knowing the tools, to understanding the choices, to planning a successful strategy. Some of the features discussed in this webcast are torn-page detection and page checksums, IO read-retry, backup checksums, consistency checks (DBCC CHECKDB and related...
- Tags: Microsoft Developer Network, Recovery, Webcast, Corruption, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Webcasts
- SSMS++ (exe)
- SSMS++ extends the management studio to give the DBA the features that let them run context sensitive critical DBCC commands. From the familar SSMS gui create, view and edit DDL/DML triggers as well as the full range of Service Broker objects (Message Types, Contracts, Queues, Services, Routes and Remote Service...
- Tags: Database Administrator, SSMS++
- Software downloads 2008-02-13
- Avoid e-mail mistakes with a single setting
- Control when Outlook sends messages to avoid embarrassing mistakes. by Susan Harkins
- Tags: Send/Receive, E-mail, Microsoft Outlook, Online Communications, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-10-13
- Avoid It (exe)
- In this Game Your objective is to avoid the monsters, and get the flag. The game has 25 levels, and only know of one person who has beaten it. And, Believe me its hard. To accesses controls press F1.
- Tags: Games, Personal Technology
- Software downloads 2006-11-16
- avoid direct acc of web svc in .NET
- Hi all,I 'm new to .NET development.1. For security reason, is it possible to avoid any direct access of web service in .NET but only allow access directly from application.2. how to avoid seeing the content of aspx file so the parameters 3. Any good reference site for looking at...
- Tags: Microsoft .NET, ana10, programming, Web
- Q&A 2006-04-24
- CRM: How to avoid falling down during implementation
- A lot of organizations have tried executing CRM, and a lot have failed. Here are the pitfalls to avoid. by Jay Rollins
- Tags: CRM, Advertising & Promotion, Customer Relationship Management (CRM), Sales Strategy, Enterprise Software, Databases, Marketing, Software, Sales, Data Management, Jay Rollins
- Blog posts 2008-11-24
- MS SQL 2000 Database
- Would appreciate info on whether we can perform compact on a MS SQL 2000 database? if so, how can this be done? Thanks.You should be able to tell SQL Server to do that automatically. Open SQL Server Manager and go to the database you want to compact. Right-click...
- Tags: Storage, Databases, database
- Q&A 2004-11-03
- << Previous
- page 1 of 1
- Next >>
